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.
Learning path · 13 guides · about 72 min in total
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.
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
Build a monthly budget that calculates itself
Beginner · 6 min read - 2
Number formats: dates, currency, percentages and leading zeros that don't vanish
Beginner · 5 min read - 3
Drop-down lists and data validation: stop people typing what they shouldn't
Beginner · 5 min read - 4
SUMIFS and COUNTIFS: sum and count with conditions
Intermediate · 6 min read - 5
XLOOKUP: find data in another table in seconds (and forget VLOOKUP)
Intermediate · 7 min read - 6
- 7
Protect sheets and cells: allow typing only where it belongs
Intermediate · 5 min read - 8
Teamwork in Excel: co-authoring, comments, notes and version history
Beginner · 5 min read - 9
Print in Excel without cutting anything off: print area, fit to one page and repeat headers
Intermediate · 5 min read - 10
Combine data from several sheets or files (and stop copy-pasting every month)
Advanced · 7 min read - 11
Your first Excel macro: record a repetitive task and replay it with one click
Advanced · 6 min read - 12
Checkboxes in Excel: forms, to-do lists and automatic counts
Beginner · 5 min read - 13
A self-grading multiple-choice quiz in Excel (drop-down lists and automatic score)
Intermediate · 6 min read
Other paths
The essential formulas
From SUM to XLOOKUP and FILTER: the functions that solve 90% of everyday work, with examples you can copy.
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 + AI: formulas you understand
For people who ask ChatGPT, Gemini or Claude for formulas. AI suggests; you check, understand and decide.