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:26
    • 2. Formula 1 - SUMIFS, COUNTIFS, AVERAGEIFS to Account for Exceptions

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

      12:00
    • 4. Formula 3 - IFERROR for Credible Reports

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

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

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

      18:45
    • 8. Formula 6 - The Most Useful Text Functions

      12:38
    • 9. Formula 6 - Advanced TEXT functions

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

      20:24
    • 11. Formula 8 - OFFSET for Dynamic Calculations

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

      15:26
    • 13. Formula 10 - SUMPRODUCT For the Gurus

      14:55
35 students are watching this class

Project Description

Complete either of the below:

  • Download the Exercise Workbook and complete 2 of the exercises (without looking at the answers). Take a screenshot and post.
  • Use at least one of the formulas that you learnt in this course with which you are not yet fully comfortable with and try to use it on your own Excel files. Take a screenshot and post.

Good luck and enjoy! Excel is just so much fun!

Student Projects

project card
Nil Sagar
1 comment