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
39 students are watching this class
How students rated this class
Leave Review

Watch more to review

We ask our students to watch a few lessons before reviewing to make sure we get quality feedback!

Best Suited for
 --  Beginner Intermediate Advanced Beginner/Intermediate Intermediate/Advanced All Levels

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.

Be the first!

No ratings just yet—watch a few lessons to be the first to share whether this class met your expectations.

Expectations Met?
  • Exceeded!
    0%
  • Yes
    0%
  • Somewhat
    0%
  • Not really
    0%
Be the first to leave a review in our updated system!
Reviews Archive

In October 2018, we updated our review system to improve the way we collect feedback. Below are the reviews written before that update. You are welcome to edit your old review into the new system!

4 of 4 students recommend this class