Excel Data for Pivot Table Practice

To solve these problems, you need 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 the Practice Workbook

Problem Overview

There are seven columns and 714 rows in our dataset, which represents sales data for a company from 2019 to 2022. The “Amount” column refers to the sales amount for the particular date.

Here’s a list of exercises:

• Exercise 01 – Inserting a Pivot Table: Make a pivot table, then remove the grand total and edit the pivot table. Then, hide the Gridlines from the table.
• The following animated image shows how to hide the grand total value.

• Exercise 02 – Grouping Data by Year: Group the sales amount by the year. Additionally, you can try to group the data by weeks and months.
• Exercise 03 – Finding a Running Total by Date: Find the running total by date using the data.
• Exercise 04 – Inserting a Pie Chart: Create a pie chart from the data in this problem.
• Exercise 05 – Adding Slicers to the Pivot Table: Insert a slicer to the pivot table.
• Exercise 06 – Using a 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.