Free Excel files to practice on
Real data to practice formulas and pivot tables on, and a budget template you can use right away. You can preview the sheets here. The files are free with an account.
Excel budget template
A ready-made budget in Excel: monthly bills, bills paid quarterly or yearly, spending by category, a running balance and your savings goals.
4 sheets
- Budget: Income and expenses per month and per year. Quarterly, twice-a-year and yearly bills are turned into a monthly amount.
- Spending: What you buy, with a date and a category. SUMIF shows how much of the budget is left in each category.
- Balance: Money in and out with a running balance: the balance above plus what came in, minus what went out.
- Savings: Your savings goals, what is still needed and how many months are left, rounded up with ROUNDUP.
| Item | Amount | Paid | Per month | Per year | Share of income |
|---|---|---|---|---|---|
| Income after tax | 5,200 | Monthly | formula | formula | |
| Rent | 1,650 | Monthly | formula | formula | formula |
| Electricity and gas | 140 | Monthly | formula | formula | formula |
| Water | 180 | Quarterly | formula | formula | formula |
Employee data for Excel practice
60 employees with department, title, start date, salary, city and full-time status. For COUNTIFS, AVERAGEIF, lookups and dates.
1 sheets
- Employees: 60 employees with ID, name, department, title, start date, annual salary, city and full-time status.
| Employee ID | First name | Last name | Department | Title | Start date | Annual salary | City | Full-time |
|---|---|---|---|---|---|---|---|---|
| 1,001 | Robert | Williams | IT | Developer | 42,887 | 50,500 | Austin | Yes |
| 1,002 | Sarah | Johnson | Warehouse | Warehouse worker | 41,153 | 42,500 | Chicago | Yes |
| 1,003 | Brian | Brown | Sales | Sales rep | 45,352 | 48,000 | Denver | Yes |
| 1,004 | Megan | Jones | Warehouse | Warehouse worker | 44,348 | 38,500 | Chicago | No |
Sales data for Excel practice
240 orders from one year with date, region, salesperson, product, category, units and revenue. For SUMIFS, lookups, dates and pivot tables.
1 sheets
- Sales: 240 orders from 2025 with date, region, salesperson, product, category, units, unit price and revenue.
| Order ID | Date | Region | Salesperson | Product | Category | Units | Unit price | Revenue |
|---|---|---|---|---|---|---|---|---|
| 1,001 | 45,658 | West | Lucas Ward | Monitor | Electronics | 15 | 1,400 | 21,000 |
| 1,002 | 45,658 | North | Emma Carter | Keyboard | Electronics | 7 | 350 | 2,450 |
| 1,003 | 45,658 | North | Emma Carter | Keyboard | Electronics | 4 | 350 | 1,400 |
| 1,004 | 45,659 | South | Noah Price | Office chair | Furniture | 10 | 1,800 | 18,000 |
Good to know
Why practice on real data?
An exercise with five rows shows you how a formula works. A file with hundreds of rows shows you whether you can use it: whether the ranges cover every row, whether the formula survives being copied down, and whether the answer looks reasonable. That is how Excel gets used at work.
How to download the files
Click a file to see all its sheets and exercises. The file itself needs a free account. Create one and you are sent straight back to the file.
Get the files free
A free account gives you every file and saves your progress in the exercises.