Excel Formulas & Functions Mastery

Transform your career trajectory by mastering formulas and functions, the foundation of spreadsheets. Whether you're starting from scratch or leveling up to expert proficiency, this course goes beyond memorization to build true understanding. Build the technical fluency required to navigate high-stakes interviews with ease and solve complex workplace challenges faster than your colleagues.

Last updated: May 2026

9 Lessons

10 Videos

9 Quizzes

Try a free lesson, upgrade anytime

Ready to build real Excel formula skill?

Try a free video lesson and quiz from the course. When you want the full curriculum and every future course addition, unlock Pro for Life.

Try Free Lesson See Pro Details

What you'll learn

Develop the mental model for how Excel evaluates and resolves formulas step by step
Master the core Excel functions for logic, aggregation, lookups, and error handling
Establish formula foundations to learn any new Excel function faster and more intuitively
Debug broken formulas faster and build spreadsheet solutions with more confidence
Turn concepts into practical formula skill through quizzes and practice problems

Key Concepts

Formula evaluation Nested logic Cell referencing Function syntax Error handling Conditional aggregation Lookup strategy Legacy lookup patterns Text normalization

Core Functions

XLOOKUP INDEX MATCH XMATCH SUMIFS COUNTIFS AVERAGEIFS MAXIFS MINIFS IFS IFERROR IFNA SUMIF COUNTIF AVERAGEIF VLOOKUP HLOOKUP IF AND OR NOT SUM AVERAGE COUNT COUNTA COUNTBLANK MEDIAN MIN MAX MODE TRIM LOWER UPPER PROPER SUBSTITUTE REPLACE TEXT EXACT + more

Course content

Lesson 1

Thinking in Formulas

2 video lessons 1 quiz

Learn how formulas differ from functions, how core operators and order of operations work, and how Excel resolves nested expressions.

Arithmetic, Comparison, and Text Operators Tutorial

3 min Pro

How Excel Evaluates a Formula Tutorial

5 min Pro

Thinking in Formulas Quiz Quiz

5 questions Pro

Lesson 2

Cell Referencing

1 video lesson 1 quiz

Learn how relative, absolute, and mixed references behave when formulas are copied so you can anchor the right rows and columns.

Relative, Absolute, and Mixed Cell Referencing Tutorial

5 min Pro

Cell Referencing Quiz Quiz

5 questions Pro

Lesson 3

Function Structure

1 video lesson 1 quiz

Learn how Excel functions are structured, how required and optional arguments work, and how to read function syntax with confidence.

Function Structure Tutorial

5 min Pro

Function Structure Quiz Quiz

5 questions Pro

Lesson 4

Error Basics

1 video lesson 1 quiz

Learn what common Excel errors mean, what causes them, and when to use IFERROR or IFNA to handle them.

Error Basics Tutorial

5 min Pro

Error Basics Quiz Quiz

6 questions Pro

Lesson 5

Logic Functions

1 video lesson 1 quiz

Learn how IF, AND, OR, NOT, and IFS use logical tests to return the right outcome.

Logic Functions Tutorial

6 min Pro

Logic Functions Quiz Quiz

5 questions Pro

Lesson 6

Core Aggregation Functions

1 video lesson 1 quiz

Learn how SUM, AVERAGE, MEDIAN, MODE, MODE.SNGL, MIN, MAX, COUNT, COUNTA, and COUNTBLANK summarize ranges and measure what is present in a dataset.

Core Aggregation Functions Tutorial

4 min Pro

Core Aggregation Functions Quiz Quiz

5 questions Pro

Lesson 7

Conditional Aggregation

Free Lesson 1 video lesson 1 quiz

Learn how COUNTIFS, SUMIFS, AVERAGEIFS, MAXIFS, MINIFS, COUNTIF, SUMIF, and AVERAGEIF use criteria to summarize only the rows that match.

Conditional Aggregation Tutorial

7 min Free

Conditional Aggregation Quiz Quiz

6 questions Free

Lesson 8

Lookup Functions

1 video lesson 1 quiz

Learn the lookup mental model, how XLOOKUP, XMATCH, and INDEX work in modern Excel, and how to read legacy VLOOKUP, HLOOKUP, and MATCH formulas.

Lookup Functions Tutorial

17 min Pro

Lookup Functions Quiz Quiz

10 questions Pro

Lesson 9

Text Manipulation

1 video lesson 1 quiz

Learn how to normalize and compare text so messy spreadsheet data can be cleaned into a more reliable format.

Text Normalization & Comparison Tutorial

5 min Pro

Text Manipulation Quiz Quiz

9 questions Pro

May 2026 expansion

May update

New lessons are rolling out throughout May, and Lifetime Pro price will increase following this. Lock in Lifetime Pro before the price increase and gain access to all future lessons at no extra cost.

New lessons coming

Lifetime Pro price increase coming

Lock In Lifetime Pro

Course introduction

See why strong Excel formula skills create leverage, speed, confidence, and career value in real work.

Common questions

What is free and what is paid?

The Conditional Aggregation video lesson and quiz are free to try. Pro Lifetime unlocks the full course and the full practice problem library.

How do the practice problems fit with the course?

Use the course to learn the underlying formula patterns, then use the problem library to apply those patterns in realistic challenges organized by difficulty and function.

Do I need Excel installed?

No. None of the course lessons or site practice problems require you to have excel downloaded. Everything can be managed directly from your browser.