Free Excel practice files

Each workbook has messy sample data, the worked solution, and notes. No email required to download.

XLOOKUP #N/A practice workbook

10 messy payment IDs, diagnostics and the fixed formula.

A UK-format export with dates, ZIP codes and long IDs that Excel breaks, plus repair formulas.

Broken and fixed date-range SUMIFS side by side, with hidden spaces in the data.

Practice Power Query From Folder; README has the expected row count and total.

Invoice data and three FILTER exercises with expected results.

Duplicate customer rows out of date order, solved with MAXIFS + XLOOKUP.

Six months of sales in a Table, a formula-driven dashboard and two charts.

Orders and customers exports with messy keys and an expected exceptions list.

Files contain no macros. Check formulas in your own version of Excel — functions like XLOOKUP, FILTER and UNIQUE need Microsoft 365 or Excel 2021+.