Most Common Excel Formulas - Excel at Your Job

  • Course provided by Udemy
  • Study type: Online
  • Starts: Anytime
  • Price: See latest price on Udemy
Udemy

Course Description

We will cover the following most common Excel formulas for intermediate users:

  1. Vlookup
  2. If Statements
  3. SumIF
  4. AverageIF
  5. CountIF
  6. TRIM
  7. Concatenate
  8. Left, Right, Mid
  9. Data Validation
  10. Removing Duplicates
  11. Conditional Formatting
  12. Data Filters

We also cover dynamic formulas versus static formulas, a few shortcuts here and there and the relative versus absolute references (otherwise known as locking cells). This course is designed for Intermediate users as we do not cover basic formulas like addition, subtraction, etc...

Who this course is for:

  • Anyone who is slow at their job and if they knew how to use Excel could become exponentially more efficient
  • Anyone who wants to learn the most common formulas that provide an incredibly strong foundation

Course content

5 sections • 17 lectures • 1h 10m total length

Instructor

Personal Finance Made Easy!
  • 4.2 Instructor Rating
  • 6,325 Reviews
  • 61,862 Students
  • 9 Courses

Personal Finance is easy. It takes 2 hours to learn. The hard part is staying motivated. We build the best personal finance courses,cause no unnecessary harm, use business to inspire and implement solutions to improve financial lives of our peers. Follow us on Instagram to find daily motivational videos. Instagram: @Brainy.Money

Expected Outcomes

  1. Students will know all intermediate level Excel formulas and functions Students will be significantly faster at their jobs when using Excel Requirements Basic Excel Knowledge - you know how to write a basic Excel formula such as Sum or multiplying two cells Description We will cover the following most common Excel formulas for intermediate users: Vlookup If Statements SumIF AverageIF CountIF TRIM Concatenate Left, Right, Mid Data Validation Removing Duplicates Conditional Formatting Data Filters We also cover dynamic formulas versus static formulas, a few shortcuts here and there and the relative versus absolute references (otherwise known as locking cells). This course is designed for Intermediate users as we do not cover basic formulas like addition, subtraction, etc... Who this course is for: Anyone who is slow at their job and if they knew how to use Excel could become exponentially more efficient Anyone who wants to learn the most common formulas that provide an incredibly strong foundation Show more Show less Course content 5 sections • 17 lectures • 1h 10m total length Expand all sections Introduction 1 lecture • 2min Introduction Preview 01:53 Overview and Getting Acquainted 3 lectures • 5min Course Overview Preview 02:11 What We Will Not Cover Preview 00:37 Excel File Download / Explanation Preview 02:41 The Most Common Formulas 9 lectures • 50min Vlookup Preview 07:58 If Statements 06:45 SumIF 06:10 AverageIF 03:45 CountIF 04:37 TRIM 05:14 Concatenate 04:22 LEFT, RIGHT, MID 08:08 Nested Formulas 03:23 Common Useful Excel Functionality 3 lectures • 11min Data Validation 05:50 Removing Duplicates 02:44 Conditional Formatting and Filters 02:17 Conclusion 1 lecture • 2min Conclusion 01:47 Instructor BrainyMoney and Son Han, CFA, CPA Personal Finance Made Easy! 4.2 Instructor Rating 6,325 Reviews 61,862 Students 9 Courses Personal Finance is easy. It takes 2 hours to learn. The hard part is staying motivated. We build the best personal finance courses,cause no unnecessary harm, use business to inspire and implement solutions to improve financial lives of our peers. Follow us on Instagram to find daily motivational videos. Instagram: @Brainy.Money Show more Show less Udemy Business Teach on Udemy Get the app About us Contact us Careers Blog Help and Support Affiliate Impressum Kontakt Terms Privacy policy Cookie settings Sitemap © 2021 Udemy, Inc. window.handleCSSToggleButtonClick = function (event) { var target = event.currentTarget; var cssToggleId = target && target.dataset && target.dataset.cssToggleId; var input = cssToggleId && document.getElementById(cssToggleId); if (input) { if (input.dataset.type === 'checkbox') { input.dataset.checked = input.dataset.checked ? '' : 'checked'; } else { input.dataset.checked = input.dataset.allowToggle && input.dataset.checked ? '' : 'checked'; var radios = document.querySelectorAll('[name="' + input.dataset.name + '"]'); for (var i = 0; i (function(){window['__CF$cv$params']={r:'6781481babd8079a',m:'bebecedbe353d95b1c87aeaa3227d7eb2f98bf9d-1627844137-1800-Ad/LUynmH1G52TO+hy+573/MTyJ7iOF1S6u/sAFNiQoeeunp7ChQ0AR6IrQVqBWtlVczasz84LCqVQzzdQ2zOiF/gOkJR3b4l3mqSdqyA0/qBNEJ0CCYXcw33pkqn7zBaGiuZm/9OlOtwxsdio/KdOphSDP4iYdd1XXCcqSs9hku',s:[0x96ca51bdea,0x5b8415241b],}})();
  2. Students will be significantly faster at their jobs when using Excel Requirements Basic Excel Knowledge - you know how to write a basic Excel formula such as Sum or multiplying two cells Description We will cover the following most common Excel formulas for intermediate users: Vlookup If Statements SumIF AverageIF CountIF TRIM Concatenate Left, Right, Mid Data Validation Removing Duplicates Conditional Formatting Data Filters We also cover dynamic formulas versus static formulas, a few shortcuts here and there and the relative versus absolute references (otherwise known as locking cells). This course is designed for Intermediate users as we do not cover basic formulas like addition, subtraction, etc... Who this course is for: Anyone who is slow at their job and if they knew how to use Excel could become exponentially more efficient Anyone who wants to learn the most common formulas that provide an incredibly strong foundation Show more Show less Course content 5 sections • 17 lectures • 1h 10m total length Expand all sections Introduction 1 lecture • 2min Introduction Preview 01:53 Overview and Getting Acquainted 3 lectures • 5min Course Overview Preview 02:11 What We Will Not Cover Preview 00:37 Excel File Download / Explanation Preview 02:41 The Most Common Formulas 9 lectures • 50min Vlookup Preview 07:58 If Statements 06:45 SumIF 06:10 AverageIF 03:45 CountIF 04:37 TRIM 05:14 Concatenate 04:22 LEFT, RIGHT, MID 08:08 Nested Formulas 03:23 Common Useful Excel Functionality 3 lectures • 11min Data Validation 05:50 Removing Duplicates 02:44 Conditional Formatting and Filters 02:17 Conclusion 1 lecture • 2min Conclusion 01:47 Instructor BrainyMoney and Son Han, CFA, CPA Personal Finance Made Easy! 4.2 Instructor Rating 6,325 Reviews 61,862 Students 9 Courses Personal Finance is easy. It takes 2 hours to learn. The hard part is staying motivated. We build the best personal finance courses,cause no unnecessary harm, use business to inspire and implement solutions to improve financial lives of our peers. Follow us on Instagram to find daily motivational videos. Instagram: @Brainy.Money Show more Show less Udemy Business Teach on Udemy Get the app About us Contact us Careers Blog Help and Support Affiliate Impressum Kontakt Terms Privacy policy Cookie settings Sitemap © 2021 Udemy, Inc. window.handleCSSToggleButtonClick = function (event) { var target = event.currentTarget; var cssToggleId = target && target.dataset && target.dataset.cssToggleId; var input = cssToggleId && document.getElementById(cssToggleId); if (input) { if (input.dataset.type === 'checkbox') { input.dataset.checked = input.dataset.checked ? '' : 'checked'; } else { input.dataset.checked = input.dataset.allowToggle && input.dataset.checked ? '' : 'checked'; var radios = document.querySelectorAll('[name="' + input.dataset.name + '"]'); for (var i = 0; i (function(){window['__CF$cv$params']={r:'6781481babd8079a',m:'bebecedbe353d95b1c87aeaa3227d7eb2f98bf9d-1627844137-1800-Ad/LUynmH1G52TO+hy+573/MTyJ7iOF1S6u/sAFNiQoeeunp7ChQ0AR6IrQVqBWtlVczasz84LCqVQzzdQ2zOiF/gOkJR3b4l3mqSdqyA0/qBNEJ0CCYXcw33pkqn7zBaGiuZm/9OlOtwxsdio/KdOphSDP4iYdd1XXCcqSs9hku',s:[0x96ca51bdea,0x5b8415241b],}})();