What You'll Learn

  • Understand and Use Essential Functions

    Master the most necessary functions in Excel for various tasks, empowering you to handle data efficiently

  • Automate Calculations and Repetitive Operations:

    Simplify your workflow by automating calculations and repetitive tasks with formulas.

  • Become a Formula Pro:

    From simple to advanced, learn to create powerful formulas in Excel and become an expert in using them.

Course Program

  • Module 1 - Mathematical Functions in Excel

    Sum & Sumproduct; Average Function and Percentage Gain

  • Module 2 - Lookup Functions

    Vlookup; Index Match; Xlookup

  • Module 3 - Advanced Math & Statistical Functions in Excel

    Sumif & Sumifs; Countif & Countifs Functions Max and Min, Large, Small Frequency Analysis

  • Module 4 - Logical Functions

    IF & IFs; AND, OR, NOT

  • Module 5 - Text Formulas

    Split and Merge Text; Text Formatting: PROPER, LOWER, UPPER; Trim Function; Transpose Data;;;

  • Module 6 - Date/Time Formulas

    TODAY and TDATE; DAYMONTH, MONTHYEAR, YEAR, MONTH, WEEK, DAY, HOUR, MINUTES, SECONDS DAYOFWEEK, WORKDAY, WEEKNUM DIFFDATE

Go from confused Excel User to Go-To Excel Pro

My goal is your success. It is very important for me to make sure you feel supported, and you are not alone on this journey

  • 20 recorded lessons with detailed instructions

  • Summary lesson in PDF format

  • Practice file for each lesson

  • Practical homework assignments for each lesson

  • Lifetime access to the course material

  • Private Community for support

  • Certificate upon completion

Bonuses for you!

  • 🎁 FREE mini Course

    Introduction to Microsoft Excel

  • 🎁 Bonus Lecture

    Pivot Table Intro

  • 🎁 Flashcards

    Excel Shortcuts

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