Class Central is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

Skillshare

Excel: Top 10 Excel Formulas to Work Smarter

via

This course may be unavailable.

Overview

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!

Syllabus

  • Advanced Excel: Top 10 Formulas to Work Smarter
  • Formula 1 - SUMIFS, COUNTIFS, AVERAGEIFS to Account for Exceptions
  • Formula 2 - IF (Nested Functions) Because Data Analysis is Often Not Simple
  • Formula 3 - IFERROR for Credible Reports
  • Formula 4 - VLOOKUP & HLOOKUP For Dynamic Lookups
  • Formula 5 - INDEX & MATCH for Flexible Lookups
  • Formula 5 - INDEX & MATCH for Complex Real-Cases
  • Formula 6 - The Most Useful Text Functions
  • Formula 6 - Advanced TEXT functions
  • Formula 7 - Excel's Top Date Functions
  • Formula 8 - OFFSET for Dynamic Calculations
  • Formula 9 - FREQUENCY, SMALL & LARGE to Organize and Rank
  • Formula 10 - SUMPRODUCT For the Gurus

Taught by

Leila Gharani

Reviews

Start your review of Excel: Top 10 Excel Formulas to Work Smarter

Never Stop Learning.

Get personalized course recommendations, track subjects and courses with reminders, and more.

Someone learning on their laptop while sitting on the floor.