Free Excel practice files
Every exercise as a downloadable file, with the dataset filled in and the answer cells left blank. Useful if you want to practise offline, on a plane, or in the version of Excel your employer actually gives you.
These are CSV files
Everything in one file
Every exercise
All 72 dataset exercises in one file, each on its own labelled block.
By difficulty
Beginner exercises
28 beginner exercises. One function, one step, a small and tidy dataset.
Intermediate exercises
30 intermediate exercises. Two or three functions combined, or one function with conditions.
Advanced exercises
14 advanced exercises. Nested logic across a realistic dataset, with edge cases that bite.
By topic
- Excel Basics3 exercises
- Formulas3 exercises
- Logical Functions11 exercises
- Lookup & Reference9 exercises
- Text Functions10 exercises
- Date & Time3 exercises
- Math Functions8 exercises
- Statistical Functions10 exercises
- Data Cleaning4 exercises
- Data Analysis11 exercises
Want structured practice?
The files above are the datasets. The packs sequence them into modules and add the part a CSV cannot carry — a solution workbook with the working formula, why it works, and the mistake people make instead.
Practising offline versus in the browser
A downloaded file gives you the real thing: your own copy of Excel, your own keyboard shortcuts, and no internet connection required. That is genuinely valuable, and it is why these exist.
What it cannot give you is feedback. When your formula returns the wrong answer, the file has no way to tell you that your range is not locked, or that you have used SUMIF where the task needs two conditions. That is the part that turns practice into learning, and it only happens in the browser version.
A reasonable pattern: work through an exercise here until the feedback stops surprising you, then use the download to rehearse it at speed in real Excel.