Excel practice, written down
Exercises with answers and the reasoning behind them. Every one links to the lesson where you type it into a grid and get marked.
-
Excel practice exercises for beginners, with answers
Eight short Excel exercises on references, SUM, COUNT, AVERAGE and absolute references — each with the answer, the formula and why it works.
-
VLOOKUP practice exercises: five worked examples
Five VLOOKUP exercises from exact match to approximate match, with the answers, the two mistakes that cause #N/A, and when to reach for XLOOKUP instead.
-
The Excel keyboard shortcuts to practise first
Nine shortcuts that do most of the work in a spreadsheet, in the order to learn them, with a drill for each that you can run on any sheet.