Free Excel course, from first formula to FILTER
12 units and 36 bite-size lessons. Read the key ideas here, then practice each one in a real spreadsheet.
- A1Unit 1: Cells and formulasRead the grid, write your first formulas. Meet the grid · Basic arithmetic · Ranges and percents
- ΣUnit 2: SUM and friendsAdd, average, and count whole columns. SUM · AVERAGE, MIN, MAX · Counting
- $Unit 3: Cell referencesFill down without breaking anything. Relative references · Absolute references · Mixed references
- IFUnit 4: Logic with IFMake your sheet decide things. IF basics · AND and OR · Nested decisions
- #?Unit 5: Conditional mathCount and sum only what matches. COUNTIF · SUMIF and AVERAGEIF · Multiple conditions
- AaUnit 6: Working with textClean, join, and slice words. Cleaning text · Joining text · Slicing text
- ⌕Unit 7: LookupsFind answers in another table. VLOOKUP · XLOOKUP · INDEX and MATCH
- ✓Unit 8: Clean resultsHandle errors and round like a pro. Reading errors · Rounding · Final challenge
- 31Unit 9: Dates and timeDeadlines, durations, and calendars. Date basics · Date math · Calendars and labels
- ✂Unit 10: Data cleanupFix messy exports before they bite. Find and replace · Check your data · Duplicates and uniques
- %Unit 11: Business mathGrowth, margins, loans, and savings. Percentages · Loans and savings · Totals that matter
- {}Unit 12: Dynamic arraysOne formula, whole tables of answers. Spill basics · FILTER · Array math