In this article, you will get an Excel data file for pivot table practice. There will also be seven practice tasks. If you have intermediate level knowledge of Excel, you can easily solve all problems. However, the beginner can also solve a few of the problems. To solve the problems, one needs to be familiar with inserting pivot tables, using slicers, utilizing calculated fields, inserting pivot pie charts, building a data model, and grouping by year. If you have Excel 2010 or later, you can solve these exercises without any compatibility issues.
Download Practice Workbook
You can download the Excel file from the following link.
Problem Overview
There are seven columns and 714 rows in our dataset. This represents sales data for a company from 2019 to 2022. The “Amount” column refers to the sales amount for the particular date.
Now, using this data, you will have exercises to solve.
- Exercise 01 Inserting Pivot Table: Your task is to bring up the pivot table. Then remove the grand total and edit the pivot table. Additionally, you can hide the Gridlines from the table.
- The following animated image shows how to hide the grand total value.
- Exercise 02 Grouping Data by Year: The second task is to group the sales amount by the year. Additionally, you can try to group the data by weeks and months.
- Exercise 03 Finding Running Total by Date: Your objective is to find the running total by date using the data.
- Exercise 04 Inserting a Pie Chart: You will create a pie chart from the data in this problem.
- Exercise 05 Adding Slicers to Pivot Table: In the fifth problem, you will need to insert a slicer to the pivot table.
- Exercise 06 Using Calculated Field: You will need to find the sales tax which is 5% of the total sales using the calculated field. Remember, to import the pivot table as a data model.
The following image shows the first three solutions.
Conclusion
Thank you for reading this article about the data for pivot table practice in Excel. We hope that with this practice data for the pivot table, you can test your Excel skills. You can find more articles similar to this on the ExcelDemy website. If you have any questions or suggestions, feel free to comment below. However, remember that our website implements comment moderation. Therefore, your comment may not be instantly visible. So, have a little bit of patience, and we will solve your query as soon as possible. Keep excelling!
Thank you!! Rafiul Haq.
Dear Minhajul,
You are most welcome.
Regards
ExcelDemy
Answer to exercise 3 is wrong. Sales and Running total of Sales have the same values. Otherwise nice exercise
Dear Qasim,
Thanks for your suggestions we have updated our Exercise 3 you can check it now.
Regards
ExcelDemy
Great work exceldemy team! Really healped me a lot.
Dear Foysal,
You are most welcome.
Regards
ExcelDemy
Do you have any YouTube channel?
Dear Ashab,
We do have a YouTube channel named ExcelDemy
Regards
ExcelDemy