Course curriculum

    1. Welcome!

    1. TOP Excel Functions

    2. TOP Excel Shortcuts

    1. Day 1: Getting Started with Microsoft Excel 📊

    1. Lesson 1. Data Clean up 🧹

    2. Lesson 2: The Power of Sum & Sumproduct 💪

    3. Lesson 3: AVERAGE Function & Percentage Gain 📈

    1. Lesson 4: Unlocking the Power of VLOOKUP 🔑

    2. Lesson 5: The Dynamic Duo – INDEX & MATCH 🧩

    3. Lesson 6: XLOOKUP Magic ✨ – Excel 365 & 2021

    1. Lesson 7: Mastering SUMIF, SUMIFS, COUNTIF & COUNTIFS 🔢

    2. Lesson 8: MAX, MIN, LARGE & SMALL Functions 📊

    3. Lesson 9: Exploring Frequency Analysis 📊

About this course

  • $399.00
  • 79 lessons
  • 4.5 hours of video content

What my students say about course

5 star rating

Excellent introduction to Excel

David Klenk

I just completed the course Top Must-Know Excel Functions taught by Farizat. The course is well structured and gives the student the extra material needed to work through sample problems and homework problems. It is not simply a lecture with homew...

Read More

I just completed the course Top Must-Know Excel Functions taught by Farizat. The course is well structured and gives the student the extra material needed to work through sample problems and homework problems. It is not simply a lecture with homework, like so many other Excel courses.

Read Less
5 star rating

Awesome!

Lorena Godoy

Learned many tips that could've saved me so much time at my last position!

Learned many tips that could've saved me so much time at my last position!

Read Less