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

CSV opens directly in Excel and keeps the data and formulas, but not the number formatting or locked cells. The browser version is the better experience — you get told exactly why an answer is wrong, which a downloaded file cannot do.

Everything in one file

Every exercise

All 30 exercises in one file, each on its own labelled block.

Download all 30 exercises

By difficulty

  • Beginner exercises

    12 beginner exercises. One function, one step, a small and tidy dataset.

    Download (12)
  • Intermediate exercises

    12 intermediate exercises. Two or three functions combined, or one function with conditions.

    Download (12)
  • Advanced exercises

    6 advanced exercises. Nested logic across a realistic dataset, with edge cases that bite.

    Download (6)

By topic

  • Formulas2 exercisesCSV
  • Logical Functions5 exercisesCSV
  • Lookup & Reference5 exercisesCSV
  • Text Functions4 exercisesCSV
  • Date & Time2 exercisesCSV
  • Math Functions3 exercisesCSV
  • Statistical Functions5 exercisesCSV
  • Data Cleaning2 exercisesCSV
  • Data Analysis2 exercisesCSV

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.