9 Lessons
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: March 2026
10 Videos
8 Quizzes
Start free, upgrade anytime
Ready to build real Excel formula skill?
Begin this course free with 3 included tasks. When you want the full curriculum, April lesson releases, and every future course addition, unlock Pro for Life.
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
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
+ more
Course content
Lesson 1
Course Introduction
1 video lesson
Lesson 1
Course Introduction
1 video lesson
Learn why formula mastery creates speed, confidence, and career value, and how the course roadmap builds that into practical spreadsheet problem-solving skill.
Lesson 2
Thinking in Formulas
2 video lessons
1 quiz
Lesson 2
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.
Lesson 3
Cell Referencing
1 video lesson
1 quiz
Lesson 3
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.
Lesson 4
Function Structure
1 video lesson
1 quiz
Lesson 4
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.
Lesson 5
Error Basics
1 video lesson
1 quiz
Lesson 5
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.
Lesson 6
Logic Functions
1 video lesson
1 quiz
Lesson 6
Logic Functions
1 video lesson
1 quiz
Learn how IF, AND, OR, NOT, and IFS use logical tests to return the right outcome.
Lesson 7
Core Aggregation Functions
1 video lesson
1 quiz
Lesson 7
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.
Lesson 8
Conditional Aggregation
1 video lesson
1 quiz
Lesson 8
Conditional Aggregation
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.
Lesson 9
Lookup Functions
1 video lesson
1 quiz
Lesson 9
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.
April 2026 expansion
April update
New lessons are rolling out throughout April, 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