Excel: Top 10 Excel Formulas to Work Smarter | Leila Gharani | Skillshare

Excel: Top 10 Excel Formulas to Work Smarter

Leila Gharani, Excel Instructor, Business Consultant

Play Speed
  • 0.5x
  • 1x (Normal)
  • 1.25x
  • 1.5x
  • 2x
13 Lessons (2h 57m)
    • 1. Advanced Excel: Top 10 Formulas to Work Smarter

    • 2. Formula 1 - SUMIFS, COUNTIFS, AVERAGEIFS to Account for Exceptions

    • 3. Formula 2 - IF (Nested Functions) Because Data Analysis is Often Not Simple

    • 4. Formula 3 - IFERROR for Credible Reports

    • 5. Formula 4 - VLOOKUP & HLOOKUP For Dynamic Lookups

    • 6. Formula 5 - INDEX & MATCH for Flexible Lookups

    • 7. Formula 5 - INDEX & MATCH for Complex Real-Cases

    • 8. Formula 6 - The Most Useful Text Functions

    • 9. Formula 6 - Advanced TEXT functions

    • 10. Formula 7 - Excel's Top Date Functions

    • 11. Formula 8 - OFFSET for Dynamic Calculations

    • 12. Formula 9 - FREQUENCY, SMALL & LARGE to Organize and Rank

    • 13. Formula 10 - SUMPRODUCT For the Gurus

25 students are watching this class

About This Class

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!





  • --
  • Beginner
  • Intermediate
  • Advanced
  • All Levels
  • Beg/Int
  • Int/Adv


Community Generated

The level is determined by a majority opinion of students who have reviewed this class. The teacher's recommendation is shown until at least 5 student responses are collected.

Leila Gharani

Excel Instructor, Business Consultant

I help companies use Excel better to improve their reports by providing customized training sessions, Dashboard Training and Enhanced Visualization Techniques. I also help improve processes, by designing interfaces and tools with VBA for Excel.

I have over 15 years of experience implementing and training users on Management Information Systems of different sizes and nature. Aside from onsite training, I offer comprehensive Excel online courses.I am also a Certified Microsoft Excel Expe...

See full profile

Report class