Excel Data for Pivot Table Practice

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.

Problem Overview of Excel Data for Pivot Table Practice

Now, using this data, you will have exercises to solve.

  • 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.


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!

Get FREE Advanced Excel Exercises with Solutions!

Rafiul Haq
Rafiul Haq

Rafiul Haq worked as an Excel and VBA Content Developer in Exceldemy for over two years and published almost 200 articles for the website. He is passionate about exploring new aspects of Excel and VBA. He received his Bachelor of Science in Mechanical and Production Engineering (MPE) from the Islamic University of Technology. Rafiul furthered his education by obtaining an MBA in Finance from the Institute of Business Administration (IBA) at the University of Dhaka. Apart from creating... Read Full Bio

  1. Thank you!! Rafiul Haq.

  2. 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.


  3. Great work exceldemy team! Really healped me a lot.

  4. Do you have any YouTube channel?

  5. Solve this in a video and upload on your youtube channel. Its a very helpful.

Leave a reply

Advanced Excel Exercises with Solutions PDF