Free downloads · no signup

Practice on small examples.
Keep the workings.

Try the Excel guides with synthetic data, check the answers, then adapt a copy for your own work.

The Excel practice workbook

Seventeen sheets bring the source rows, checks and results together.

Text amounts, formulas and a corrected total.
Repeated IDs, missing records and exact-match lookups.
Leading-zero text codes and readable date labels.
A budget, category summary, chart and working PivotTable.
Drop-down choices, validation and a separate pasted-value check.
A Checks sheet with the expected results.

Macro-free XLSX. No configured external connections. Your original files are not part of this download.

Download the Excel workbook Get all exercise files as a ZIP

Two practice reports have equal totals but different invoices

The free exercise is separate from the invitation-only $5 Report Tools Starter Kit. No payment or signup is needed for these files.

Monthly-file exercise

Three starting CSVs, a held-out fourth file, an optional Power Query recipe and a source-count checklist.

Expected controls: 3 files → 6 rows → 2,100. Add the fourth file: 4 files → 8 rows → 3,600. Keep invoice codes as text and source filenames attached.

Download the file exercise

The optional recipe is reviewed against Microsoft documentation. Native Excel Power Query execution is not yet verified; the shared workbook has no embedded external connection.

A reference for your next export

Keep twelve Windows desktop shortcuts beside the task: make a Table, filter, move, edit, fill and format.

Download the printable reference

Formula results and PivotTable refresh were checked in LibreOffice 26.8. XLOOKUP requires Microsoft 365 / Excel 2021 or later; a VLOOKUP alternative is included. Native Excel menu and refresh verification remains pending.

Need to prepare your own export? Combine CSV/TSV files or pasted cells in the private list workspace. Keep the source rows and save a result on your device.

Try the private list tool