Excel Practice

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.

  1. 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.

    · 7 min read

  2. 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.

    · 6 min read

  3. 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.

    · 5 min read