Every lesson, in order
45 lessons and 127 graded exercises. Each one starts with a short walkthrough on sample data, then gives you a fresh sheet to solve yourself. The first 11 are free.
Foundations
FreeFormulas, the core functions, and the $ that trips everyone up.
| # | Lesson | Functions | Minutes | Exercises | Your progress |
|---|---|---|---|---|---|
| 1 | Your first formula | + − × ÷, ( ) | 6 | 2 | |
| 2 | SUM, AVERAGE, MIN, MAX & COUNT | SUM, AVERAGE, MIN, MAX, COUNT, COUNTA | 7 | 3 | |
| 3 | Relative vs absolute references | $A$1, $A1, A$1 | 9 | 3 | |
| 4 | Percentages & growth | %, ^ | 7 | 2 |
Logic & conditions
FreeIF, AND/OR, IFS, and counting or adding only the rows that match.
| # | Lesson | Functions | Minutes | Exercises | Your progress |
|---|---|---|---|---|---|
| 5 | The IF function | IF | 7 | 2 | |
| 6 | AND, OR & IFS | AND, OR, IFS | 9 | 3 | |
| 7 | COUNTIF & SUMIF | COUNTIF, SUMIF | 8 | 3 | |
| 8 | COUNTIFS, SUMIFS & AVERAGEIFS | SUMIFS, COUNTIFS, AVERAGEIFS | 10 | 3 |
Data tools
FreeConditional formatting, PivotTables and charts: the tools most Excel tests check.
| # | Lesson | Functions | Minutes | Exercises | Your progress |
|---|---|---|---|---|---|
| 9 | Conditional formatting with formulas | Conditional formatting, COUNTIF, $ | 10 | 3 | |
| 10 | PivotTables | PivotTable, Rows, Values, Filters | 12 | 4 | |
| 11 | Charts: pick the right one | Line, Column, Pie, Scatter | 9 | 4 |
Lookups
ProVLOOKUP, XLOOKUP, INDEX/MATCH and tiered lookups.
| # | Lesson | Functions | Minutes | Exercises | Your progress |
|---|---|---|---|---|---|
| 12 | VLOOKUP | VLOOKUP | 9 | 2 | |
| 13 | XLOOKUP | XLOOKUP | 9 | 3 | |
| 14 | INDEX & MATCH | INDEX, MATCH | 10 | 2 | |
| 15 | Tiered lookups & IFERROR | XLOOKUP, VLOOKUP, IFERROR | 9 | 2 | |
| 16 | Lookups with several criteria | XLOOKUP, &, INDEX, MATCH | 10 | 3 | |
| 17 | Last match, nearest value & wildcards | XLOOKUP, match_mode, search_mode | 10 | 3 |
Text cleanup
ProSplit, join and clean messy imported text.
| # | Lesson | Functions | Minutes | Exercises | Your progress |
|---|---|---|---|---|---|
| 18 | LEFT, RIGHT, MID & LEN | LEFT, RIGHT, MID, LEN | 8 | 3 | |
| 19 | Joining text | &, CONCAT, TEXTJOIN | 7 | 3 | |
| 20 | Cleaning messy data | TRIM, PROPER, LOWER, SUBSTITUTE | 8 | 3 | |
| 21 | TEXTBEFORE, TEXTAFTER & FIND | TEXTBEFORE, TEXTAFTER, FIND | 8 | 3 | |
| 22 | Splitting and counting list cells | TEXTSPLIT, COUNTA, TRIM, SUBSTITUTE | 9 | 2 |
Dates
ProHow Excel stores dates, and the math that follows.
| # | Lesson | Functions | Minutes | Exercises | Your progress |
|---|---|---|---|---|---|
| 23 | DATE, YEAR, MONTH & TEXT | DATE, YEAR, MONTH, TEXT | 8 | 3 | |
| 24 | EDATE, EOMONTH & NETWORKDAYS | EDATE, EOMONTH, NETWORKDAYS | 9 | 3 | |
| 25 | Tenure, quarters & weekdays | DATEDIF, WEEKDAY, MONTH, ROUNDUP | 10 | 3 |
Dynamic arrays
ProUNIQUE, SORT, FILTER and LET: one formula, many results.
| # | Lesson | Functions | Minutes | Exercises | Your progress |
|---|---|---|---|---|---|
| 26 | UNIQUE & SORT | UNIQUE, SORT | 9 | 3 | |
| 27 | FILTER | FILTER | 10 | 3 | |
| 28 | LET | LET | 8 | 2 | |
| 29 | SORTBY, TAKE & SEQUENCE | SORTBY, TAKE, SEQUENCE | 9 | 3 | |
| 30 | VSTACK & HSTACK | VSTACK, HSTACK | 9 | 3 | |
| 31 | LAMBDA with BYROW, MAP & SCAN | LAMBDA, BYROW, MAP, SCAN | 12 | 3 | |
| 32 | Self-building summary tables | UNIQUE, SUMIFS, SORTBY, SUMIF | 11 | 3 |
Analysis
ProRounding, ranking and SUMPRODUCT.
| # | Lesson | Functions | Minutes | Exercises | Your progress |
|---|---|---|---|---|---|
| 33 | ROUND, ROUNDUP & ROUNDDOWN | ROUND, ROUNDUP, ROUNDDOWN | 7 | 3 | |
| 34 | RANK, LARGE & SMALL | RANK.EQ, LARGE, SMALL | 9 | 3 | |
| 35 | SUMPRODUCT | SUMPRODUCT | 9 | 3 | |
| 36 | Running totals & share of total | SUM, $, Cumulative share | 9 | 3 | |
| 37 | Median, quartiles & outliers | MEDIAN, QUARTILE.INC, PERCENTILE.INC, STDEV | 11 | 4 | |
| 38 | MAXIFS & MINIFS by group | MAXIFS, MINIFS | 8 | 2 |
Finance
ProLoan payments, time value of money, NPV and IRR.
| # | Lesson | Functions | Minutes | Exercises | Your progress |
|---|---|---|---|---|---|
| 39 | Loan payments with PMT | PMT | 9 | 3 | |
| 40 | Future & present value | FV, PV | 8 | 2 | |
| 41 | NPV & IRR | NPV, IRR | 10 | 2 |
Errors & checks
ProHandle errors on purpose, catch duplicates, and prove two lists agree.
| # | Lesson | Functions | Minutes | Exercises | Your progress |
|---|---|---|---|---|---|
| 42 | Handling errors on purpose | IFNA, IFERROR, ISNUMBER | 10 | 3 | |
| 43 | Duplicates & reconciliation | COUNTIF, $, Expanding range | 11 | 3 |
Capstones
ProMulti-step challenges like the ones in analyst interviews.
| # | Lesson | Functions | Minutes | Exercises | Your progress |
|---|---|---|---|---|---|
| 44 | Capstone: sales report | SUMIFS, SORT, UNIQUE, # | 15 | 3 | |
| 45 | Capstone: analyst interview test | XLOOKUP, IF, AND | 12 | 3 |