=DATASETS

Free Excel practice datasets

Realistic (and sometimes deliberately messy) sample data for practicing the skills covered in our tutorials — lookups, PivotTables, SUMIFS/COUNTIFS, data cleaning, and financial modeling.

7 datasets

Conditional formatting

Conditional formatting practice: exam scores

40 students with three test scores each and no formatting applied yet, plus a questions sheet walking through a 3-color scale, a red fill for failing scores, a Top 10% highlight, and data bars.

Download .xlsx

Financial modeling

Financial modeling starter: loan amortization

A single-sheet loan amortization schedule driven by PMT, with a month-by-month breakdown of interest, principal, and remaining balance.

Download .xlsx

Data cleaning

Messy data cleanup practice

Deliberately inconsistent order data - extra whitespace, mixed case, duplicate rows, and numbers stored as text - for practicing TRIM, CLEAN, Remove Duplicates, or Power Query.

Download .xlsx

Pivot tables

PivotTable practice: sales transactions

300 rows of realistic sales transactions (date, region, product, rep, amount) already formatted as an Excel Table, ready to summarize with your first PivotTable.

Download .xlsx

SUMIFS & COUNTIFS

SUMIFS / COUNTIFS practice dataset

200 rows of sales data across region, product, month, and salesperson, plus a questions sheet for writing real multi-condition SUMIFS and COUNTIFS formulas.

Download .xlsx

Text functions

Text functions practice: messy contact data

Deliberately inconsistent contact records - extra whitespace, mixed case, and unstructured full names and addresses - plus a questions sheet for practicing TRIM, PROPER, LEFT, RIGHT, MID, FIND, and TEXTJOIN.

Download .xlsx

Lookup formulas