The 10 modules — work through them in order
01🧱Grid BasicsBeginnerCells, references, your first formula & the $ lock→02➕Core Formulas & FunctionsBeginnerSUM, AVERAGE, COUNT, ROUND, MAX/MIN, LARGE→03🚦Logical FunctionsBeginnerIF, nested IF, IFS, AND/OR/NOT, IFERROR→04✂️Text FunctionsBeginnerLEFT/MID/RIGHT, TRIM, PROPER, CONCAT, TEXTJOIN→05📅Dates & TimesIntermediateSerial numbers, DATE, DATEDIF, NETWORKDAYS→06🧮Conditional AggregationIntermediateSUMIFS, COUNTIFS, AVERAGEIFS & criteria→07🔎LookupsIntermediateVLOOKUP, XLOOKUP, INDEX-MATCH, IFERROR→08🧹Data Cleaning & PrepIntermediateTRIM, Text-to-Columns, Flash Fill, dedupe→09📊PivotTables & ChartsAdvancedPivot zones, grouping, the right chart→10✨Dynamic ArraysAdvancedSpill, FILTER, SORT, UNIQUE, LET, LAMBDA→
📚Function AtlasEvery useful Excel function — 187 across 10 families — with syntax and a worked example. Searchable. Keep it open while you work.Open the Atlas →
How each module works
1Read the hand-notes — ELI5 analogy, then step-by-step for every function.
2See it — mind maps, decision flowcharts and real charts.
3Type it — the Formula Sandbox runs your formula and turns the cell green.