Excel Practice Exercises With Free Sample Data

Practice needs data. Generate a sheet of sample records and work through these exercises.

Open the Mock Data Generator

Generate the Orders or Students dataset in the box below and download Excel. You get a real .xlsx with a header row. Orders has order id, customer id, product, quantity, unit price, status and date. Students has course, year, marks and attendance.

Exercises with the Orders sheet. 1) Turn the range into a table and sort it by unit price. 2) Filter to Shipped orders in one month. 3) Add a Total column with quantity times unit price. 4) Build a pivot table of total by product. 5) Use COUNTIFS to count Cancelled orders per month.

Exercises with the Students sheet. 6) Use AVERAGEIF to find the average marks per course. 7) Use conditional formatting to colour marks below 50 red. 8) Make a column chart of average marks by course. Then try XLOOKUP or VLOOKUP by looking up a student id in a second sheet.

Keep a copy of the original sheet, so you can start again. If you want a bigger or different data set, generate it again with New random data or choose your own columns in the Mock Data Generator.

Everything runs in your browser and nothing is uploaded.

Open the Mock Data Generator

Related tool pages

  • Fake Data Generator: Generate realistic fake data online: names, emails, addresses, dates and more, up to 500,000 rows, as CSV, JSON, Parquet or Excel. Free.
  • Test Data Generator: Generate test data for databases and apps: names, emails, addresses, dates and numbers, up to 500,000 rows, as CSV, JSON, Parquet or Excel. Free.
  • Student Data Generator: Fake Student Records: Generate fake student data for class projects: IDs, names, courses, marks and attendance. Download CSV, Excel, JSON or Parquet. Free.
  • Student Marks Dataset Generator: Create a student marks dataset by student, subject and exam for SQL, Excel pivot tables and charts. Free, in your browser.
  • Sample Data for SQL Practice: Generate sample tables for SQL practice (students, orders, employees), download CSV and query it in your browser. Free.
  • Dummy Data for Excel Practice: Generate dummy sales, student or employee data and download Excel to practise filters, pivot tables and VLOOKUP. Free.

How to use the Mock Data Generator: step by step

  1. Pick Orders or Students and download Excel.
  2. Work through the exercises one by one.
  3. Save your work under a new name.
  4. Generate a new sheet to repeat the exercises.

When to use the Mock Data Generator

  • Practise pivot tables and charts
  • Learn VLOOKUP and XLOOKUP
  • Prepare for an Excel test
  • Build a demo workbook

Example

Input: Dataset: Customers, 3 rows

Output: id,name,email 1,Maya Patel,maya.patel@example.com 2,Leo Fischer,leo.fischer@example.com

Frequently asked questions

Is the data real?

No. It is random and fictional, so it is safe to share.

Can I get the same data again?

No – each click makes new data. Download to keep a set.

How many rows can the Data Generator create?

Up to 500,000 rows at a time. Choose column types such as names, emails, addresses and dates, then download as CSV, JSON, Parquet or Excel.

Tip: Keep an untouched copy of the file. Practice goes faster when you can reset.