Every lesson, in order
29 lessons and 78 graded exercises. Each one starts with a short walkthrough on sample data, then gives you a fresh sheet to solve yourself. The first 8 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 |
Lookups
ProVLOOKUP, XLOOKUP, INDEX/MATCH and tiered lookups.
| # | Lesson | Functions | Minutes | Exercises | Your progress |
|---|---|---|---|---|---|
| 9 | VLOOKUP | VLOOKUP | 9 | 2 | |
| 10 | XLOOKUP | XLOOKUP | 9 | 3 | |
| 11 | INDEX & MATCH | INDEX, MATCH | 10 | 2 | |
| 12 | Tiered lookups & IFERROR | XLOOKUP, VLOOKUP, IFERROR | 9 | 2 |
Text cleanup
ProSplit, join and clean messy imported text.
| # | Lesson | Functions | Minutes | Exercises | Your progress |
|---|---|---|---|---|---|
| 13 | LEFT, RIGHT, MID & LEN | LEFT, RIGHT, MID, LEN | 8 | 3 | |
| 14 | Joining text | &, CONCAT, TEXTJOIN | 7 | 3 | |
| 15 | Cleaning messy data | TRIM, PROPER, LOWER, SUBSTITUTE | 8 | 3 | |
| 16 | TEXTBEFORE, TEXTAFTER & FIND | TEXTBEFORE, TEXTAFTER, FIND | 8 | 3 |
Dates
ProHow Excel stores dates, and the math that follows.
| # | Lesson | Functions | Minutes | Exercises | Your progress |
|---|---|---|---|---|---|
| 17 | DATE, YEAR, MONTH & TEXT | DATE, YEAR, MONTH, TEXT | 8 | 3 | |
| 18 | EDATE, EOMONTH & NETWORKDAYS | EDATE, EOMONTH, NETWORKDAYS | 9 | 3 |
Dynamic arrays
ProUNIQUE, SORT, FILTER and LET: one formula, many results.
| # | Lesson | Functions | Minutes | Exercises | Your progress |
|---|---|---|---|---|---|
| 19 | UNIQUE & SORT | UNIQUE, SORT | 9 | 3 | |
| 20 | FILTER | FILTER | 10 | 3 | |
| 21 | LET | LET | 8 | 2 |
Analysis
ProRounding, ranking and SUMPRODUCT.
| # | Lesson | Functions | Minutes | Exercises | Your progress |
|---|---|---|---|---|---|
| 22 | ROUND, ROUNDUP & ROUNDDOWN | ROUND, ROUNDUP, ROUNDDOWN | 7 | 3 | |
| 23 | RANK, LARGE & SMALL | RANK.EQ, LARGE, SMALL | 9 | 3 | |
| 24 | SUMPRODUCT | SUMPRODUCT | 9 | 3 |
Finance
ProLoan payments, time value of money, NPV and IRR.
| # | Lesson | Functions | Minutes | Exercises | Your progress |
|---|---|---|---|---|---|
| 25 | Loan payments with PMT | PMT | 9 | 3 | |
| 26 | Future & present value | FV, PV | 8 | 2 | |
| 27 | NPV & IRR | NPV, IRR | 10 | 2 |
Capstones
ProMulti-step challenges like the ones in analyst interviews.
| # | Lesson | Functions | Minutes | Exercises | Your progress |
|---|---|---|---|---|---|
| 28 | Capstone: sales report | SUMIFS, SORT, UNIQUE, # | 15 | 3 | |
| 29 | Capstone: analyst interview test | XLOOKUP, IF, AND | 12 | 3 |