Learn Excel › All lessons
All lessons
Five blocks, from your first SUM to pivot tables. Each block ends with a practice mission and a test: pass it and the next block opens.
-
1Block 1
The basics
- Adding up+, SUM, SUMIF, SUMIFS8 exercises
- CountingCOUNT, COUNTA, COUNTIF, COUNTIFS6 exercises
- Averages and roundingAVERAGE, MIN, MAX, ROUND, LARGE6 exercises
- References and percentages$A$1, percentages, text to number5 exercises
- The sales reportMission5 questions · no tips5 exercises
- Test: the basicsTest10 questions
-
2Block 2
Logic and calculations
-
3Block 3
Looking things up
-
4Block 4
Text and dates
-
5Block 5
Working with data
- Entering dataAutoFill, drop-down lists, Wrap Text, Merge5 exercises
- Sorting and filteringSort, Filter, Remove Duplicates, Text to Columns, Tables5 exercises
- Pivot tables and chartsPivotTable, charts3 exercises
- Formatting and protectingConditional formatting, Freeze Panes, Lock Cells, Paste Special5 exercises
- The expense reportMission5 questions · no tips5 exercises
- Test: working with dataTest6 questions