Home

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.
A look at the Budget sheet
ItemAmountPaidPer monthPer yearShare of income
Income after tax5,200Monthlyformulaformula
Rent1,650Monthlyformulaformulaformula
Electricity and gas140Monthlyformulaformulaformula
Water180Quarterlyformulaformulaformula
See the file and its exercises

Customer data for Excel practice

150 customers with name, email, city, segment, signup date, orders and total spent. For COUNTIFS, XLOOKUP, text functions and dates.

1 sheets

  • Customers: 150 customers with ID, name, email, city, segment, signup date, orders, total spent and newsletter.
A look at the Customers sheet
Customer IDFirst nameLast nameEmailCitySegmentSignup dateOrdersTotal spentNewsletter
2,001NoahDavis[email protected]AustinPrivate45,78411,275Yes
2,002TylerSmith[email protected]ChicagoPrivate45,88292,395No
2,003MiaKing[email protected]ChicagoBusiness44,2492186,231No
2,004MasonSmith[email protected]DenverPrivate44,74545,075Yes
See the file and its exercises

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.
A look at the Employees sheet
Employee IDFirst nameLast nameDepartmentTitleStart dateAnnual salaryCityFull-time
1,001RobertWilliamsITDeveloper42,88750,500AustinYes
1,002SarahJohnsonWarehouseWarehouse worker41,15342,500ChicagoYes
1,003BrianBrownSalesSales rep45,35248,000DenverYes
1,004MeganJonesWarehouseWarehouse worker44,34838,500ChicagoNo
See the file and its exercises

Inventory data for Excel practice

80 products with SKU, category, supplier, stock, reorder point, cost and price. For XLOOKUP, SUMPRODUCT, COUNTIFS and stock value.

1 sheets

  • Inventory: 80 products with SKU, category, supplier, units in stock, reorder point, unit cost, sale price and last delivery.
A look at the Inventory sheet
SKUProductCategorySupplierIn stockReorder pointUnit costSale priceLast received
SKU-1001Notebook A5, squaredPaperPaperWorks23620244045,897
SKU-1002Coat standFurnitureNordic Supply14741069045,818
SKU-1003Copy paper A4, 500 sheetsPaperPaperWorks3840326045,768
SKU-1004Paper cups, 100KitchenCleanCo18025427545,785
See the file and its exercises

Messy data for Excel cleanup practice

60 orders with extra spaces, wrong case, numbers and dates stored as text, mixed phone formats and duplicates. For TRIM, PROPER, VALUE and SUBSTITUTE.

1 sheets

  • Orders: 60 exported orders with order number, customer, city, date, amount, phone and status, mess included.
A look at the Orders sheet
Order no.CustomerCityOrder dateAmountPhoneStatus
5,001amy rossAUSTIN2025-01-202,150705 555 4852Unpaid
5,002TOM FISHER Seattle2025-02-262,050574 555 6356Paid
5,003Jack GrayAustin 2025-04-031,3254305554942Paid
5,004Mark EvansDENVER2025-03-118258925559900Unpaid
See the file and its exercises

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.
A look at the Sales sheet
Order IDDateRegionSalespersonProductCategoryUnitsUnit priceRevenue
1,00145,658WestLucas WardMonitorElectronics151,40021,000
1,00245,658NorthEmma CarterKeyboardElectronics73502,450
1,00345,658NorthEmma CarterKeyboardElectronics43501,400
1,00445,659SouthNoah PriceOffice chairFurniture101,80018,000
See the file and its exercises

Finance data for Excel practice

A year of bank transactions for a small firm: 188 entries with date, voucher, description, category and amount. For SUMIF, SUMIFS and percentages.

1 sheets

  • Transactions: 188 bank transactions from 2025 with date, voucher number, description, category and amount.
A look at the Transactions sheet
DateVoucherDescriptionCategoryAmount
45,6581Rent, JanuaryRent-18,500
45,6602CleaningOffice-2,125
45,6643Accounting softwareSoftware-349
45,6674Invoice 1001Sales55,250
See the file and its exercises

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.

Create a free account