Excel Data for Pivot Table Practice

Get FREE Advanced Excel Exercises with Solutions!

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.


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!

What is ExcelDemy?

ExcelDemy Learn Excel & Excel Solutions Center provides free Excel tutorials, free support , online Excel training and Excel consultancy services for Excel professionals and businesses. Feel free to contact us with your Excel problems.

Rafiul Haq
Rafiul Haq

Greetings! I am Rafiul, an experienced professional with an engineering degree and an MBA in finance. Data analysis is my passion, and I find Excel to be an invaluable tool in this domain. My goal is to simplify complex concepts by providing comprehensive and user-friendly guides on Excel and finance topics, aiming to enhance people's productivity and understanding at ExcelDemy.

8 Comments
  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.

      Regards
      ExcelDemy

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

  4. Do you have any YouTube channel?

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo