Excel & spreadsheet skills
For older students and parents who want to learn Excel or sharpen their skills. Every question gives you a real little spreadsheet: you type the formula, and the sheet works out the answer as you type.
Included in your Zero2Hero subscription, and free for everyone until June 30, 2027.
Who it's for
Students from about Grade 9, and parents who use spreadsheets at home or at work: budgets, sales lists, marks, schedules.
How it works
- Click a cell to put its address in your formula; shift-click another cell to make a range.
- Each topic has 3 levels, hints that point you to the next step, and a short lesson.
- The same formulas work in Microsoft Excel and Google Sheets.
Function names
We teach the English names (SUM, IF, XLOOKUP). If your Excel is in French or Spanish, type it your way: SOMME, SI, NB.SI or SUMA, SI, CONTAR.SI all work, with ; between the parts if that's what your Excel uses.
π Reports
Building reports: summary tables, two-way tables like a PivotTable, clean results with IFERROR, and choosing the right chart.
Topics
- 1Cells, references and simple formulasFree to tryStart β
- 2Adding up with SUMStart β
- 3AVERAGE, MIN and MAXStart β
- 4Counting with COUNT, COUNTA and COUNTBLANKStart β
- 5Absolute references with $Start β
- 6ROUND, ROUNDUP and ROUNDDOWNStart β
- 7Decisions with IFStart β
- 8COUNTIF and SUMIFStart β
- 9Several conditions with COUNTIFS, SUMIFS and AVERAGEIFSStart β
- 10Looking things up with XLOOKUP and VLOOKUPStart β
- 11Joining and cleaning textStart β
- 12Working with datesStart β
- 13Percents for discounts, change and goalsStart β
- 14Clean reports with IFERRORStart β
- 15Top values and rankingStart β
- 16UNIQUE, FILTER and SORTStart β
- 17Reports: a summary tableStart β
- 18Reports: a two-way table, like a PivotTableStart β
- 19Reports: choosing the right chartStart β
- 20Loans and savings with PMT and FVStart β
More topics are on the way.
Zero2Hero is not affiliated with Microsoft. Excel is a trademark of Microsoft Corporation.
