Excel Data for Pivot Table Practice

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.

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

Reply

Answer to exercise 3 is wrong. Sales and Running total of Sales have the same values. Otherwise nice exercise

Reply

Dear Qasim, Thanks for your suggestions we have updated our Exercise 3 you can check it now. Regards
ExcelDemy