The essential formulas
From SUM to XLOOKUP and FILTER: the functions that solve 90% of everyday work, with examples you can copy.
Learning path · 13 guides · about 66 min in total
Excel from scratch, no fear
For people who only open Excel to make lists. Basic formulas, tables, filters and charts, in short guides and in order.
Your progress: 0 of 13White belt
Every completed guide brings you closer to the black belt. Saved only in this browser, no accounts or sign-up.The guides in this path, in order
- 1
Your first formulas: SUM, AVERAGE, MAX, MIN and AutoSum
Beginner · 5 min read - 2
Number formats: dates, currency, percentages and leading zeros that don't vanish
Beginner · 5 min read - 3
Fill handle and Flash Fill: type it once and let Excel complete the rest
Beginner · 4 min read - 4
Excel Tables: the format that makes filters, formulas and charts work on their own
Beginner · 6 min read - 5
Sort and filter data in Excel without scrambling your rows
Beginner · 5 min read - 6
Freeze Panes: keep the header row visible when you scroll down
Beginner · 3 min read - 7
Relative and absolute references ($A$1): why your formula breaks when you drag it
Beginner · 6 min read - 8
The IF function explained with examples (and nested IFs without getting lost)
Beginner · 6 min read - 9
Formula errors (#N/A, #VALUE!, #REF!, #DIV/0!): what they mean and how to fix them
Beginner · 5 min read - 10
Charts people understand: pick the right type and remove the clutter
Beginner · 6 min read - 11
Print in Excel without cutting anything off: print area, fit to one page and repeat headers
Intermediate · 5 min read - 12
The Excel keyboard shortcuts that actually save time
Beginner · 5 min read - 13
Checkboxes in Excel: forms, to-do lists and automatic counts
Beginner · 5 min read
Other paths
Reports and data analysis
From a list of thousands of rows to a clear report: clean data, pivot tables, charts, conditional formatting and a simple dashboard.
Excel for the office, freelancers and small business
Budgets, client lists, invoices and shared files: what you need to run a business or a department with Excel.
Excel + AI: formulas you understand
For people who ask ChatGPT, Gemini or Claude for formulas. AI suggests; you check, understand and decide.