EXCEL: TOP 10 EXCEL FORMULAS TO WORK SMARTER

0
(0 Reviews)

Duration 2 h 56 m 41 s

Price

$ 6 Buy now
EXCEL: TOP 10 EXCEL FORMULAS TO WORK SMARTER

About Course

This top 10 Excel formulas Course introduces you to the most useful functions that will save you time on the job. You will work faster. You will work smarter. 

The course includes:

  • Complete workbook I use for demonstration
  • Exercise book (answers included)

The reason I created this specific Advanced Excel course, is because there are many advanced Excel users who are unaware of key Excel formulas in Excel. I understand that when you take an Excel training it can be so broad, and a lot of courses cover too many topics. It’s easy to get lost. You might also not immediately appreciate why some features are useful and how you can practically apply them. We are creatures of habit and it’s difficult to get our head around learning new techniques. As a result you might be missing out on some features that can majorly simplify the way you use Excel.

This course will help you fill in the gaps!

Course content

videoAdvanced Excel: Top 10 Formulas to Work Smarter2 m 26 s Start
videoFormula 1 - SUMIFS, COUNTIFS, AVERAGEIFS to Account for Exceptions14 m 3 s Start
videoFormula 2 - IF (Nested Functions) Because Data Analysis is Often Not Simple12 m 1 s Start
videoFormula 3 - IFERROR for Credible Reports5 m 53 s Start
videoFormula 4 - VLOOKUP & HLOOKUP For Dynamic Lookups11 m 27 s Start
videoFormula 5 - INDEX & MATCH for Flexible Lookups16 m 24 s Start
videoFormula 5 - INDEX & MATCH for Complex Real-Cases18 m 45 s Start
videoFormula 6 - The Most Useful Text Functions12 m 39 s Start
videoFormula 6 - Advanced TEXT functions17 m 27 s Start
videoFormula 7 - Excel's Top Date Functions20 m 25 s Start
videoFormula 8 - OFFSET for Dynamic Calculations14 m 48 s Start
videoFormula 9 - FREQUENCY, SMALL & LARGE to Organize and Rank15 m 27 s Start
videoFormula 10 - SUMPRODUCT For the Gurus14 m 56 s Start
ubaid

ubaid

Course Instructor

0
(0 Reviews)
See more