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
100 students are watching this class