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 · 11 guides · about 69 min in total
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.
Your progress: 0 of 11White 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
Excel Tables: the format that makes filters, formulas and charts work on their own
Beginner · 6 min read - 2
Clean data: remove duplicates and extra spaces, and split text into columns
Intermediate · 6 min read - 3
Pivot tables in 5 minutes: summarize thousands of rows without writing formulas
Beginner · 7 min read - 4
Pivot tables in depth: group dates, % of total and calculated fields
Advanced · 7 min read - 5
Slicers and timelines: button filters for your reports
Intermediate · 5 min read - 6
Charts people understand: pick the right type and remove the clutter
Beginner · 6 min read - 7
Conditional formatting: let Excel highlight only what matters
Beginner · 5 min read - 8
- 9
Subtotals and grouping rows: reports that collapse and expand
Intermediate · 5 min read - 10
A simple dashboard with a pivot table, a chart and a slicer
Advanced · 8 min read - 11
Power Query: import and clean data once, then refresh with one click
Advanced · 8 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.
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.