Sorry, your browser is not supported
To have the best experience using Skillshare, we recommend that you use one of these supported browsers.

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 Videos (2h 57m)
    • Advanced Excel: Top 10 Formulas to Work Smarter

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

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

      12:00
    • Formula 3 - IFERROR for Credible Reports

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

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

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

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

      12:38
    • Formula 6 - Advanced TEXT functions

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

      20:24
    • Formula 8 - OFFSET for Dynamic Calculations

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

      15:26
    • Formula 10 - SUMPRODUCT For the Gurus

      14:55

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!

1 of 1 students recommendSee All

Leila is an amazing teacher. Her teaching style makes learning Excel fun, interesting, and easy. I have really enjoyed all of her lessons. I would recommend her to anyone interested in learning Excel properly.

46

Students

--

Projects

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