--- title: "Excel practice data: free datasets with tasks and answers | PracticeExcel" description: "Two free Excel files to practice on: 240 sales orders and 60 employees. With 29 tasks on SUMIF, COUNTIF, lookups and dates, and answers you can check." canonical_url: "https://practiceexcelonline.com/learn/excel-practice-data" locale: en meta: "og:description": "Two free Excel files to practice on: 240 sales orders and 60 employees. With 29 tasks on SUMIF, COUNTIF, lookups and dates, and answers you can check." "og:image": "https://practiceexcelonline.com/_og/d/c_Page%2Ctitle_~RXhjZWwgcHJhY3RpY2UgZGF0YTogZnJlZSBkYXRhc2V0cyB3aXRoIHRhc2tzIGFuZCBhbnN3ZXJz%2Cdescription_~VHdvIGZyZWUgRXhjZWwgZmlsZXMgdG8gcHJhY3RpY2Ugb246IDI0MCBzYWxlcyBvcmRlcnMgYW5kIDYwIGVtcGxveWVlcy4gV2l0aCAyOSB0YXNrcyBvbiBTVU1JRiwgQ09VTlRJRiwgbG9va3VwcyBhbmQgZGF0ZXMsIGFuZCBhbnN3ZXJzIHlvdSBjYW4gY2hlY2su%2Ceyebrow_Excel%2Bguides%2Csite_practiceexcel%2Cp_Ii9sZWFybi9leGNlbC1wcmFjdGljZS1kYXRhIg%2Cs_AJ6wQTgSc0B7RQzc.png" "og:image:height": "600" "og:image:type": image/png "og:image:width": "1200" "og:title": "Excel practice data: free datasets with tasks and answers | PracticeExcel" "twitter:image": "https://practiceexcelonline.com/_og/d/c_Page%2Ctitle_~RXhjZWwgcHJhY3RpY2UgZGF0YTogZnJlZSBkYXRhc2V0cyB3aXRoIHRhc2tzIGFuZCBhbnN3ZXJz%2Cdescription_~VHdvIGZyZWUgRXhjZWwgZmlsZXMgdG8gcHJhY3RpY2Ugb246IDI0MCBzYWxlcyBvcmRlcnMgYW5kIDYwIGVtcGxveWVlcy4gV2l0aCAyOSB0YXNrcyBvbiBTVU1JRiwgQ09VTlRJRiwgbG9va3VwcyBhbmQgZGF0ZXMsIGFuZCBhbnN3ZXJzIHlvdSBjYW4gY2hlY2su%2Ceyebrow_Excel%2Bguides%2Csite_practiceexcel%2Cp_Ii9sZWFybi9leGNlbC1wcmFjdGljZS1kYXRhIg%2Cs_AJ6wQTgSc0B7RQzc.png" --- > Index of every page on this site: [llms.txt](https://practiceexcelonline.com/llms.txt) # **Excel practice data: free datasets with tasks and answers** Two free Excel files to practice on: 240 sales orders and 60 employees. With 29 tasks on SUMIF, COUNTIF, lookups and dates, and answers you can check. By Nicolaj Gajhede, founder of PracticeExcel · Updated November 2, 2026 · 12 min read It is hard to get good at Excel on a sheet with five rows. The real problems only show up with a few hundred rows: a range that stops too early, a date stored as text, a condition that catches one row too many. So here are two datasets the size of what you meet at work, with tasks that have an answer key. One file is a year of sales from an office equipment dealer, with 240 orders. The other is an employee list with 60 people in five departments. Both files have a sheet of tasks, and under each task on this page you can see the answer and a formula that gives it. Solve the task yourself first, then look. ## Sales data: 240 orders from a full year **Free with an account** ### **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. **What's in the file** - **Sales:** 240 orders from 2025 with date, region, salesperson, product, category, units, unit price and revenue. [**Create a free account to download**](https://practiceexcelonline.com/signup?next=/learn/excel-practice-data%23download-sales-data) [Already have an account? Log in](https://practiceexcelonline.com/login?next=/learn/excel-practice-data%23download-sales-data) Excel file (.xlsx). It also opens in Google Sheets. The account is free and also saves your progress in the exercises. The **Sales** sheet has one row per order and nine columns: | **Column** | **Contents** | **Example** | | --- | --- | --- | | A Order ID | A number from 1001 to 1240 | 1150 | | B Date | The order date in 2025, weekdays only | Jan 2, 2025 | | C Region | North, South, East or West | North | | D Salesperson | Two salespeople in each region | Emma Carter | | E Product | Six products | Office chair | | F Category | Furniture, Electronics or Office supplies | Furniture | | G Units | Number of items on the order | 4 | | H Unit price | The price per item | 1,800 | | I Revenue | Units times unit price | 7,200 | The data is clean on purpose: one header row, no blank rows, dates as real dates and numbers as real numbers. That way you can focus on the formulas. If you want to practice cleanup, the guide to [**cleaning data in Excel**](https://practiceexcelonline.com/learn/clean-data-in-excel) is the place to start. ## How to approach a task A task on hundreds of rows gets easier when you break it down before you type anything. Ask yourself three things: 1. **Which column do you calculate on?** Revenue, units or just the number of rows. That decides whether you need SUM, AVERAGE or COUNT. 2. **Which rows count?** Each condition in the question becomes a pair of a range and a criterion. "Furniture in the East region" is two conditions. 3. **Does the answer need rounding or a particular format?** An average with eight decimals or a share of 0.435 is correct, but it is not what the task asks for. Once you have answered those three questions, the formula is almost written. Then sanity-check the result: is the revenue for one region roughly a quarter of the total, and is the number of orders in a quarter roughly a quarter of 240? An answer that is ten times too big is usually a wrong range, not a math mistake. ## How to use the files Open the file and go to the **Tasks** sheet. Each task has a number, a question and an empty cell for your answer. Write the formula on the data sheet, in an empty column to the right of the data, or on a new sheet, and type the result next to the task. Then look up the answer on this page. Save a copy of the file before you start. That way you can sort, delete and change things freely and always start over with the clean data. The answers on this page only match the data as it is in the file, so check your answers before you start editing rows. The data rows run from 2 to 241 in the sales file and from 2 to 61 in the employee file. The answers on this page use the exact ranges, like I2:I241, because they are the easiest to read. You can also use whole columns like I:I, and then the formula keeps working when you add rows. SUM and SUMIF skip the header, but COUNTA counts it, so subtract 1 there. The header row has filter buttons, and it stays in view when you scroll down. Use the filters to check an answer by eye: filter on the North region, select the **Revenue** column and read the sum on the status bar at the bottom. It should match your formula. ## Formula tasks on the sales data The first tasks need one function each. Later ones combine two conditions, work with dates and round the result. The tasks are in the same order as in the file. ### **Formulas on the sales data** The tasks use the file Sales data for Excel practice. **Get the file** 1. **1\.** What is the total revenue for the whole year?
**Show the answer** **2,008,750** Formula:=SUM(I2:I241)
2. **2\.** How many orders are there in total?
**Show the answer** **240** Formula:=COUNTA(A2:A241)
3. **3\.** What is the revenue in the North region?
**Show the answer** **503,850** Formula:=SUMIF(C2:C241,"North",I2:I241)
4. **4\.** How many orders has Olivia Reed sold?
**Show the answer** **32** Formula:=COUNTIF(D2:D241,"Olivia Reed")
5. **5\.** How much furniture has the East region sold?
**Show the answer** **151,600** Formula:=SUMIFS(I2:I241,F2:F241,"Furniture",C2:C241,"East")
6. **6\.** What is the average revenue per order, rounded to a whole number?
**Show the answer** **8,370** Formula:=ROUND(AVERAGE(I2:I241),0)
7. **7\.** What is the largest single order?
**Show the answer** **25,600** Formula:=MAX(I2:I241)
8. **8\.** How many office chairs were sold in total?
**Show the answer** **249** Formula:=SUMIF(E2:E241,"Office chair",G2:G241)
9. **9\.** What was the revenue in March?
**Show the answer** **176,100** Formula:=SUMIFS(I2:I241,B2:B241,">="&DATE(2025,3,1),B2:B241,"<"&DATE(2025,4,1))
10. **10\.** How many headsets are sold per order on average? Round to one decimal.
**Show the answer** **11.5** Formula:=ROUND(AVERAGEIF(E2:E241,"Headset",G2:G241),1)
11. **11\.** How many orders are over 10,000?
**Show the answer** **76** Formula:=COUNTIF(I2:I241,">10000")
12. **12\.** Which product was sold in order 1150?
**Show the answer** **Monitor** Formula:=VLOOKUP(1150,A2:I241,5,FALSE)
13. **13\.** What share of revenue comes from furniture? Round to three decimals.
**Show the answer** **43.5%** Formula:=ROUND(SUMIF(F2:F241,"Furniture",I2:I241)/SUM(I2:I241),3)
14. **14\.** What is the date of the last order?
**Show the answer** **Dec 31, 2025** Formula:=MAX(B2:B241)
15. **15\.** How many orders did the West region get in the fourth quarter?
**Show the answer** **19** Formula:=COUNTIFS(C2:C241,"West",B2:B241,">="&DATE(2025,10,1))
### Totals with one condition SUMIF is the function you will use most on data like this. It takes three arguments: where to look, what to look for and what to add up. Revenue in the North region is `**=SUMIF(C2:C241,"North",I2:I241)**`. The two ranges should be the same length and start on the same row, or the formula adds up the wrong rows. COUNTIF counts rows instead of adding numbers, and it only needs two arguments. The criterion can also be a comparison in quotes: `**=COUNTIF(I2:I241,">10000")**` counts orders over 10,000. Leave out the thousands separator in the criterion. ### Two conditions at once SUMIFS takes as many conditions as you like, but the order is different from SUMIF: the range to add up comes first, followed by pairs of range and criterion. Furniture sold in the East region is `**=SUMIFS(I2:I241,F2:F241,"Furniture",C2:C241,"East")**`. A row only counts when both conditions match. COUNTIFS works the same way, just without a range to add up. Practice both in [**SUMIFS with two conditions**](https://practiceexcelonline.com/practice/sumifs/sumifs-two-conditions) and [**COUNTIFS with two conditions**](https://practiceexcelonline.com/practice/countifs/countifs-two-conditions). ### Dates as conditions Revenue in March is every order from March 1 up to, but not including, April 1. That is two conditions on the same column: `**=SUMIFS(I2:I241,B2:B241,">="&DATE(2025,3,1),B2:B241,"<"&DATE(2025,4,1))**` The comparison goes in quotes, and the date is joined on with &. DATE builds the date from year, month and day, so the formula works however dates are displayed on your computer. Use "less than the first of the next month" rather than "less than or equal to the last day of the month". That way you never have to remember how many days a month has. More on working with dates in the guide to [**Excel dates**](https://practiceexcelonline.com/learn/excel-dates). ### Averages and rounding AVERAGE gives the average with all its decimals. The tasks ask for a rounded number, so wrap the average in ROUND: `**=ROUND(AVERAGE(I2:I241),0)**`. The second argument is the number of decimals. Don't just format the cell to show fewer decimals. The number would look rounded, but every formula that uses it would still calculate with the decimals. AVERAGEIF is the average of the rows that match a criterion, with the same three arguments as SUMIF. Try it in [**Average one group with AVERAGEIF**](https://practiceexcelonline.com/practice/averageif/averageif). ### Look up an order The order ID is in the first column, so VLOOKUP can find an order directly: `**=VLOOKUP(1150,A2:I241,5,FALSE)**` looks for 1150 in column A and returns the value from the fifth column of the range, which is the product. FALSE means exact match, and that is what you want almost every time. XLOOKUP does the same without counting columns. The differences are explained in the guide to [**VLOOKUP, XLOOKUP and INDEX/MATCH**](https://practiceexcelonline.com/learn/vlookup-vs-xlookup-vs-index-match). ### Build a monthly summary Once you have solved the tasks, try pulling it all together in a small summary with one row per month. Type the first day of each month in column K, from Jan 1, 2025 in K2 to Dec 1, 2025 in K13. Next to it, add up the revenue for the month: `**=SUMIFS($I$2:$I$241,$B$2:$B$241,">="&K2,$B$2:$B$241,"<"&EDATE(K2,1))**` EDATE returns the same day one month later, so the formula takes every order from the first of the month up to the first of the next. The ranges are locked with $, while K2 has to move. Fill the formula down and you have twelve totals that add up to the revenue for the year. Check that with a SUM under the table. Add columns for the number of orders and the average order per month with COUNTIFS and AVERAGEIFS, and make a column chart of the revenue. That gives you the same thing a pivot table would, but with formulas you wrote yourself that update when the data changes. ## Employee data: 60 people in five departments **Free with an account** ### **Employee data for Excel practice** 60 employees with department, title, start date, salary, city and full-time status. For COUNTIFS, AVERAGEIF, lookups and dates. **What's in the file** - **Employees:** 60 employees with ID, name, department, title, start date, annual salary, city and full-time status. [**Create a free account to download**](https://practiceexcelonline.com/signup?next=/learn/excel-practice-data%23download-employees) [Already have an account? Log in](https://practiceexcelonline.com/login?next=/learn/excel-practice-data%23download-employees) Excel file (.xlsx). It also opens in Google Sheets. The account is free and also saves your progress in the exercises. The **Employees** sheet has one row per person and nine columns: | **Column** | **Contents** | **Example** | | --- | --- | --- | | A Employee ID | A number from 1001 to 1060 | 1025 | | B First name | The first name | Sarah | | C Last name | The last name | Smith | | D Department | Sales, Finance, IT, HR or Warehouse | Finance | | E Title | From sales rep to finance manager | Bookkeeper | | F Start date | The first of the month, from 2012 to 2025 | Aug 1, 2019 | | G Annual salary | Salary per year before tax | 48,500 | | H City | Chicago, Denver, Austin or Seattle | Austin | | I Full-time | Yes or No | Yes | The names are made up, and several people can share a first name. The employee ID is the only thing that is unique, so that is what you look up. The file is smaller than the sales data, but it has different kinds of columns. There is text that needs joining, dates going back many years, and salaries where the median and the average are not the same. ## Formula tasks on the employee data ### **Formulas on the employee data** The tasks use the file Employee data for Excel practice. **Get the file** 1. **1\.** How many employees work in IT?
**Show the answer** **7** Formula:=COUNTIF(D2:D61,"IT")
2. **2\.** What is the average salary in Sales, rounded to a whole number?
**Show the answer** **48,658** Formula:=ROUND(AVERAGEIF(D2:D61,"Sales",G2:G61),0)
3. **3\.** What is the highest salary?
**Show the answer** **67,500** Formula:=MAX(G2:G61)
4. **4\.** What is the total payroll for the whole company?
**Show the answer** **2,963,500** Formula:=SUM(G2:G61)
5. **5\.** How many employees in Denver work full time?
**Show the answer** **9** Formula:=COUNTIFS(H2:H61,"Denver",I2:I61,"Yes")
6. **6\.** What is the name of employee 1025? Give the first and last name.
**Show the answer** **Jessica Wilson** Formula:=VLOOKUP(1025,A2:I61,2,FALSE)&" "&VLOOKUP(1025,A2:I61,3,FALSE)
7. **7\.** How many started in 2020 or later?
**Show the answer** **26** Formula:=COUNTIF(F2:F61,">="&DATE(2020,1,1))
8. **8\.** When did the longest-serving employee start?
**Show the answer** **Apr 1, 2012** Formula:=MIN(F2:F61)
9. **9\.** What is the median salary?
**Show the answer** **48,250** Formula:=MEDIAN(G2:G61)
10. **10\.** What is the average salary of full-time warehouse employees, rounded to a whole number?
**Show the answer** **41,889** Formula:=ROUND(AVERAGEIFS(G2:G61,D2:D61,"Warehouse",I2:I61,"Yes"),0)
11. **11\.** How many earn more than 55,000?
**Show the answer** **16** Formula:=COUNTIF(G2:G61,">55000")
12. **12\.** What share of the employees work part time? Round to three decimals.
**Show the answer** **20%** Formula:=ROUND(COUNTIF(I2:I61,"No")/COUNTA(A2:A61),3)
13. **13\.** What is the total salary in Finance?
**Show the answer** **872,000** Formula:=SUMIF(D2:D61,"Finance",G2:G61)
14. **14\.** How many are managers? Every manager title ends in "manager".
**Show the answer** **13** Formula:=COUNTIF(E2:E61,"*manager")
### Text with wildcards Every manager title in the file ends in "manager": sales manager, finance manager, IT manager and so on. An asterisk in a criterion stands for any text, so `**=COUNTIF(E2:E61,"*manager")**` counts every title that ends in manager. `**"manager*"**` would count titles that start with manager, and `**"*manager*"**` titles that contain the word anywhere. Upper and lower case do not matter in a criterion. ### Join text together First and last names are in separate columns. A lookup returns one value, so to get the full name you do two lookups and join them with & and a space: `**=VLOOKUP(1025,A2:I61,2,FALSE)&" "&VLOOKUP(1025,A2:I61,3,FALSE)**` Forget the space in quotes and the names run together. ### Median or average The average salary is pulled up by the few managers with high salaries. The median is the salary in the middle when all salaries are in order, and a few high numbers do not move it. Compare AVERAGE and MEDIAN on the **Annual salary** column and see how big the gap is. That is why salary statistics usually use the median. ### Shares The share working part time is the number of No values under **Full-time** divided by the number of employees. COUNTA counts cells that are not empty, so it counts employees whatever the column holds. Format the result as a percentage, or multiply by 100 if you want a plain number. The guide to [**calculating percentages in Excel**](https://practiceexcelonline.com/learn/calculate-percentage-excel) has more examples. ### Years of service and raises The start date lets you work out years of service. DATEDIF counts whole years between two dates: `**=DATEDIF(F2,DATE(2025,12,31),"y")**` gives how many full years the person in row 2 has been employed at the end of 2025. The function does not show up in the list as you type formulas in Excel, but it works. Try a what-if question too: what does it cost if everyone gets a 3% raise? Put the rate in a cell of its own, such as L1, and work out the new payroll with `**=SUM(G2:G61)*(1+L1)**`. With the rate in its own cell, you can try 2% or 4% without touching the formula. ## Practice without an answer key Not everything in Excel is a formula. These exercises don't have a single number as the answer, but they train what you do every day with data like this: - **Sort** the sales data by revenue with the largest order at the top, then sort by region and date at the same time under Data, Sort. - **Filter** on one salesperson and one quarter, and read the row count on the status bar. - **Highlight** every order over 10,000 with conditional formatting, and color the rows from the North region with a formula. See how in the guide to [**conditional formatting**](https://practiceexcelonline.com/learn/conditional-formatting-excel). - **Build a summary table** with the regions in one column and SUMIF next to it so you can fill the formula down. Lock the ranges with $: `**=SUMIF($C$2:$C$241,K2,$I$2:$I$241)**`. Practice it in [**Total per region, ready to fill down**](https://practiceexcelonline.com/practice/summary-tables/summary-table-sumif). - **Make a chart** of revenue per month, using a summary table or a pivot table as the source. The [**guide to charts**](https://practiceexcelonline.com/learn/excel-charts) shows which type fits. - **Turn the data into a table** with Ctrl+T, and try writing formulas with column names instead of ranges. A table grows by itself when you add rows. - **Find the three largest orders** with LARGE, then look up their order IDs. - **Find the salesperson** with the most orders by building a small table of salespeople with COUNTIF. Sort the table afterward. - **Find the employees** who have been with the company for more than ten years with a filter on the start date. ## Pivot tables on the sales data The sales data is built for pivot tables: there are categories to group by, dates to roll up into months and quarters, and numbers to add up. The **Tasks** sheet in the sales file has 15 more tasks that you solve with a pivot table instead of formulas. They are listed with answers and the right field layout in the [**pivot table practice**](https://practiceexcelonline.com/learn/pivot-table-practice). It is good practice to solve the same task both ways. A pivot table is fastest when you want to see many totals at once. A formula is best when the number has to sit in a specific cell and update itself. If you get two different answers, one of the methods has a condition or a range that is off, and that is often where you learn the most. ## When an answer doesn't match These are the mistakes that most often give a wrong number on data like this: - **Ranges that don't line up.** In SUMIFS, every range must be the same size, or the formula returns #VALUE!. SUMIF gives no error, but if the ranges don't start on the same row, it adds up the wrong rows. - **A typo in the criterion.** "Est" instead of "East" returns 0 without an error message. Put the criterion in a cell and point to it, or copy the text from the data. - **A date typed as text.** ">=3/1/2025" can be read differently depending on your computer's settings. Use DATE. - **The wrong column in a lookup.** The column number in VLOOKUP counts from the first column of the range, not from column A of the sheet. - **Rounding too early.** Round only the final result. If you round each row first, the total can drift. - **Extra spaces.** Data copied from another system often has a trailing space, so "North " is not the same as "North". The data in these files is clean, but it is worth knowing about when you work with your own. ## Practice data and Excel tests Many employers test Excel with exactly this kind of task: a file with a few hundred rows of sales or employees and a handful of questions to answer within a time limit. The questions look like the ones here: a total for one region, a count with two conditions, a lookup and a share. What separates the fast from the slow is rarely the formulas. It is whether they know the data, check their answers and lock their ranges. Solve the tasks here against the clock and see how long it takes you. More on what gets tested in the guide to [**Excel for job interviews**](https://practiceexcelonline.com/learn/excel-for-job-interviews). ## Practice data in Google Sheets Both files work in Google Sheets. Upload the file to Google Drive and open it with Google Sheets. Every task can be solved with the same formulas. The filter buttons come along, and you make pivot tables under Insert. See the differences in [**Google Sheets vs. Excel**](https://practiceexcelonline.com/learn/google-sheets-vs-excel). ## In short Practice on data that looks like the real thing: hundreds of rows, several categories and dates. The sales file trains SUMIF, SUMIFS, COUNTIF, dates as conditions, averages, rounding and lookups. The employee file trains wildcards, joining text, the median and shares. Solve the task yourself, check the answer on this page, and find the mistake if the number doesn't match. After that, the sales data is ready for pivot tables. To practice one formula at a time on a small sheet, start with the exercises below. They check your answer right away and show a hint when the formula is wrong. The first exercise in each topic is free. ![Nicolaj Gajhede](https://practiceexcelonline.com/authors/nicolaj-gajhede.webp) **About the author** ## **Nicolaj Gajhede**, founder of PracticeExcel I'm a software developer, and I built PracticeExcel to help others get comfortable with Excel, and the best way to get there is to work through the formulas yourself. [Nicolaj Gajhede on LinkedIn](https://www.linkedin.com/in/nicolaj-gajhede/) [More about Nicolaj Gajhede](https://practiceexcelonline.com/about#nicolaj-gajhede) ## **Practice what this guide covers** Graded exercises in a real grid, in the order the guide uses them. - [**Total per region, ready to fill down**Summary tables →](https://practiceexcelonline.com/practice/summary-tables/summary-table-sumif) - [**SUMIFS with two conditions**SUMIFS →](https://practiceexcelonline.com/practice/sumifs/sumifs-two-conditions) - [**COUNTIFS with two conditions**COUNTIFS →](https://practiceexcelonline.com/practice/countifs/countifs-two-conditions) - [**Average one group with AVERAGEIF**AVERAGEIF and AVERAGEIFS →](https://practiceexcelonline.com/practice/averageif/averageif) - [**Look up a price with VLOOKUP**VLOOKUP →](https://practiceexcelonline.com/practice/vlookup/vlookup-exact-match) - [**Round a price to two decimals**ROUND, ROUNDUP and ROUNDDOWN →](https://practiceexcelonline.com/practice/round/round-two-decimals) ### **Function pages** - [**SUMIF**](https://practiceexcelonline.com/functions/sumif) - [**SUMIFS**](https://practiceexcelonline.com/functions/sumifs) - [**COUNTIF**](https://practiceexcelonline.com/functions/countif) - [**COUNTIFS**](https://practiceexcelonline.com/functions/countifs) - [**AVERAGEIF**](https://practiceexcelonline.com/functions/averageif) - [**VLOOKUP**](https://practiceexcelonline.com/functions/vlookup) - [**ROUND**](https://practiceexcelonline.com/functions/round) ## **Questions**
### Where can I find data to practice Excel? This page has two free files, a year of sales data with 240 orders and an employee list with 60 people. Each file has a sheet of tasks, and the answers are on this page so you can check your work.
### Which Excel functions can I practice with sales data? SUMIF and SUMIFS for totals by region, salesperson and month, COUNTIF and COUNTIFS to count orders, AVERAGE and AVERAGEIF for averages, VLOOKUP to find an order and ROUND for clean numbers. After that, the data is ready for pivot tables and charts.
### Are the files free? Yes. You can see the columns, the tasks and the answers on this page. You download the files themselves with a free PracticeExcel account, which also saves your progress in the exercises.
### Do the practice files work in Google Sheets? Yes. Upload the file to Google Drive and open it with Google Sheets. Every task can be solved with the same formulas, and the filter buttons come along.
### How do I check my answer? Type your answer in the Your answer column on the Tasks sheet, then click Show the answer under the task on this page. You get both the number and a formula that gives it, so you can see where you went wrong.
## **More guides** - [**Pivot table practice: 15 exercises with answers on real sales data**Practice pivot tables in Excel on 240 sales orders. 15 exercises from a first total to quarters, % of total and filters, with answers and the field layout.](https://practiceexcelonline.com/learn/pivot-table-practice) - [**Pivot tables explained, and the formulas that do the same job**What a pivot table computes, how to build one step by step, the problems that trip people up, and how to get the same summaries with SUMIF, COUNTIF and SUMIFS.](https://practiceexcelonline.com/learn/pivot-tables) - [**VLOOKUP vs XLOOKUP vs INDEX MATCH: which lookup to use**How VLOOKUP, XLOOKUP and INDEX with MATCH work, where each one breaks, and which to use in a test, an old workbook or a sheet you are building today.](https://practiceexcelonline.com/learn/vlookup-vs-xlookup-vs-index-match) - [**How to clean data in Excel with formulas**Fix messy exports with formulas. Remove extra spaces, fix capitals, split names and codes, join columns, find duplicates and turn text into real numbers.](https://practiceexcelonline.com/learn/clean-data-in-excel) - [**Dates in Excel: how they work and the formulas you need**Why Excel stores dates as numbers, how to add days and months, find month-ends and working days, work out ages, and fix dates that arrive as text.](https://practiceexcelonline.com/learn/excel-dates) ```json {"@context":"https://schema.org","@graph":[{"@id":"https://practiceexcelonline.com/#identity","@type":"Organization","name":"PracticeExcel","url":"https://practiceexcelonline.com/","logo":{"@id":"https://practiceexcelonline.com/#logo"}},{"@id":"https://practiceexcelonline.com/#website","@type":"WebSite","inLanguage":"en-US","name":"PracticeExcel","url":"https://practiceexcelonline.com/","alternateName":["Practice Excel Online","PracticeExcelOnline.com"],"publisher":{"@id":"https://practiceexcelonline.com/#identity"},"workTranslation":{"@id":"https://excelopgaver.dk/#website"}},{"@id":"https://practiceexcelonline.com/learn/excel-practice-data#webpage","dateModified":"2026-11-02","datePublished":"2026-11-02","description":"Two free Excel files to practice on: 240 sales orders and 60 employees. With 29 tasks on SUMIF, COUNTIF, lookups and dates, and answers you can check.","name":"Excel practice data: free datasets with tasks and answers","url":"https://practiceexcelonline.com/learn/excel-practice-data","@type":["WebPage","FAQPage"],"breadcrumb":{"@id":"https://practiceexcelonline.com/learn/excel-practice-data#breadcrumb"},"isPartOf":{"@id":"https://practiceexcelonline.com/#website"},"mainEntity":[{"@id":"https://practiceexcelonline.com/learn/excel-practice-data#/schema/question/1"},{"@id":"https://practiceexcelonline.com/learn/excel-practice-data#/schema/question/2"},{"@id":"https://practiceexcelonline.com/learn/excel-practice-data#/schema/question/3"},{"@id":"https://practiceexcelonline.com/learn/excel-practice-data#/schema/question/4"},{"@id":"https://practiceexcelonline.com/learn/excel-practice-data#/schema/question/5"}],"potentialAction":[{"@type":"ReadAction","target":["https://practiceexcelonline.com/learn/excel-practice-data"]}],"primaryImageOfPage":{"@id":"https://practiceexcelonline.com/#logo"}},{"@id":"https://practiceexcelonline.com/learn/excel-practice-data#breadcrumb","@type":"BreadcrumbList","itemListElement":[{"@type":"ListItem","name":"Home","item":"https://practiceexcelonline.com","position":1},{"@type":"ListItem","name":"Excel guides","item":"https://practiceexcelonline.com/learn","position":2},{"@type":"ListItem","name":"Excel practice data: free datasets with tasks and answers","position":3}]},{"@id":"https://practiceexcelonline.com/learn/excel-practice-data#article","@type":"Article","dateModified":"2026-11-02","datePublished":"2026-11-02","description":"Two free Excel files to practice on: 240 sales orders and 60 employees. With 29 tasks on SUMIF, COUNTIF, lookups and dates, and answers you can check.","headline":"Excel practice data: free datasets with tasks and answers","inLanguage":"en-US","thumbnailUrl":"https://practiceexcelonline.com/_og/d/c_Page%2Ctitle_~RXhjZWwgcHJhY3RpY2UgZGF0YTogZnJlZSBkYXRhc2V0cyB3aXRoIHRhc2tzIGFuZCBhbnN3ZXJz%2Cdescription_~VHdvIGZyZWUgRXhjZWwgZmlsZXMgdG8gcHJhY3RpY2Ugb246IDI0MCBzYWxlcyBvcmRlcnMgYW5kIDYwIGVtcGxveWVlcy4gV2l0aCAyOSB0YXNrcyBvbiBTVU1JRiwgQ09VTlRJRiwgbG9va3VwcyBhbmQgZGF0ZXMsIGFuZCBhbnN3ZXJzIHlvdSBjYW4gY2hlY2su%2Ceyebrow_Excel%2Bguides%2Csite_practiceexcel%2Cp_Ii9sZWFybi9leGNlbC1wcmFjdGljZS1kYXRhIg%2Cs_AJ6wQTgSc0B7RQzc.png","author":{"@id":"https://practiceexcelonline.com/#/schema/person/1"},"image":{"@id":"https://practiceexcelonline.com/#/schema/image/1"},"isPartOf":{"@id":"https://practiceexcelonline.com/learn/excel-practice-data#webpage"},"mainEntityOfPage":{"@id":"https://practiceexcelonline.com/learn/excel-practice-data#webpage"},"publisher":{"@id":"https://practiceexcelonline.com/#identity"}},{"@id":"https://practiceexcelonline.com/learn/excel-practice-data#/schema/question/1","@type":"Question","inLanguage":"en-US","name":"Where can I find data to practice Excel?","acceptedAnswer":{"@type":"Answer","text":"This page has two free files, a year of sales data with 240 orders and an employee list with 60 people. Each file has a sheet of tasks, and the answers are on this page so you can check your work."}},{"@id":"https://practiceexcelonline.com/learn/excel-practice-data#/schema/question/2","@type":"Question","inLanguage":"en-US","name":"Which Excel functions can I practice with sales data?","acceptedAnswer":{"@type":"Answer","text":"SUMIF and SUMIFS for totals by region, salesperson and month, COUNTIF and COUNTIFS to count orders, AVERAGE and AVERAGEIF for averages, VLOOKUP to find an order and ROUND for clean numbers. After that, the data is ready for pivot tables and charts."}},{"@id":"https://practiceexcelonline.com/learn/excel-practice-data#/schema/question/3","@type":"Question","inLanguage":"en-US","name":"Are the files free?","acceptedAnswer":{"@type":"Answer","text":"Yes. You can see the columns, the tasks and the answers on this page. You download the files themselves with a free PracticeExcel account, which also saves your progress in the exercises."}},{"@id":"https://practiceexcelonline.com/learn/excel-practice-data#/schema/question/4","@type":"Question","inLanguage":"en-US","name":"Do the practice files work in Google Sheets?","acceptedAnswer":{"@type":"Answer","text":"Yes. Upload the file to Google Drive and open it with Google Sheets. Every task can be solved with the same formulas, and the filter buttons come along."}},{"@id":"https://practiceexcelonline.com/learn/excel-practice-data#/schema/question/5","@type":"Question","inLanguage":"en-US","name":"How do I check my answer?","acceptedAnswer":{"@type":"Answer","text":"Type your answer in the Your answer column on the Tasks sheet, then click Show the answer under the task on this page. You get both the number and a formula that gives it, so you can see where you went wrong."}},{"@id":"https://practiceexcelonline.com/#/schema/person/1","@type":"Person","description":"I'm a software developer, and I built PracticeExcel to help others get comfortable with Excel, and the best way to get there is to work through the formulas yourself.","jobTitle":"founder of PracticeExcel","name":"Nicolaj Gajhede","url":"https://practiceexcelonline.com/about#nicolaj-gajhede","image":{"@id":"https://practiceexcelonline.com/#/schema/image/2"},"sameAs":["https://www.linkedin.com/in/nicolaj-gajhede/"]},{"@id":"https://practiceexcelonline.com/#logo","@type":"ImageObject","caption":"PracticeExcel","contentUrl":"https://practiceexcelonline.com/brand/practiceexcel/icon-512.png","inLanguage":"en-US","url":"https://practiceexcelonline.com/brand/practiceexcel/icon-512.png"},{"@id":"https://practiceexcelonline.com/#/schema/image/1","@type":"ImageObject","contentUrl":"https://practiceexcelonline.com/_og/d/c_Page%2Ctitle_~RXhjZWwgcHJhY3RpY2UgZGF0YTogZnJlZSBkYXRhc2V0cyB3aXRoIHRhc2tzIGFuZCBhbnN3ZXJz%2Cdescription_~VHdvIGZyZWUgRXhjZWwgZmlsZXMgdG8gcHJhY3RpY2Ugb246IDI0MCBzYWxlcyBvcmRlcnMgYW5kIDYwIGVtcGxveWVlcy4gV2l0aCAyOSB0YXNrcyBvbiBTVU1JRiwgQ09VTlRJRiwgbG9va3VwcyBhbmQgZGF0ZXMsIGFuZCBhbnN3ZXJzIHlvdSBjYW4gY2hlY2su%2Ceyebrow_Excel%2Bguides%2Csite_practiceexcel%2Cp_Ii9sZWFybi9leGNlbC1wcmFjdGljZS1kYXRhIg%2Cs_AJ6wQTgSc0B7RQzc.png","inLanguage":"en-US","url":"https://practiceexcelonline.com/_og/d/c_Page%2Ctitle_~RXhjZWwgcHJhY3RpY2UgZGF0YTogZnJlZSBkYXRhc2V0cyB3aXRoIHRhc2tzIGFuZCBhbnN3ZXJz%2Cdescription_~VHdvIGZyZWUgRXhjZWwgZmlsZXMgdG8gcHJhY3RpY2Ugb246IDI0MCBzYWxlcyBvcmRlcnMgYW5kIDYwIGVtcGxveWVlcy4gV2l0aCAyOSB0YXNrcyBvbiBTVU1JRiwgQ09VTlRJRiwgbG9va3VwcyBhbmQgZGF0ZXMsIGFuZCBhbnN3ZXJzIHlvdSBjYW4gY2hlY2su%2Ceyebrow_Excel%2Bguides%2Csite_practiceexcel%2Cp_Ii9sZWFybi9leGNlbC1wcmFjdGljZS1kYXRhIg%2Cs_AJ6wQTgSc0B7RQzc.png"},{"@id":"https://practiceexcelonline.com/#/schema/image/2","@type":"ImageObject","contentUrl":"https://practiceexcelonline.com/authors/nicolaj-gajhede.webp","inLanguage":"en-US","url":"https://practiceexcelonline.com/authors/nicolaj-gajhede.webp"}]} ``` ## Sitemap See the full [sitemap](https://practiceexcelonline.com/sitemap.md) for all pages.