Here we’ll have two options we will select option no. What kind of report do you want to create?

There are four options we will select option no.

Where is the data that you want to analyze?

Here wizard will ask you two questions we need to answer, the same as follows.

We can see the Pivot table and Pivot Chart Wizard – Step 1 of 3 as shown below.Alt + D is the access key for MS Excel, and after that, by pressing P after that, we’ll enter the Pivot table and Pivot Chart Wizard.Ĭreating a Pivot Table with Multiple Sheets To create the master pivot table from these different worksheets, we need to enter into the Pivot table and Pivot Chart Wizard this function was disabled in earlier MS Office versions, but we can access the same by the shortcut keys Alt + D + P. Here the data shows the product sold by this shop in the respective years. We have data for 2015, 2016 & 2017 and ensure the given data have identical columns, categories, and sales counters. The above data are in a single workbook and multiple sheets we have given the name of the sheet respectively to the sales year.

They have this data on a yearly basis as shown in the image below, we are taking three years of data with only three columns which one is using to identify the particular sheet. You can download this Pivot Table with Multiple Sheets Excel Template here – Pivot Table with Multiple Sheets Excel Templateįor instance, let’s assume we have data from a shop selling computer parts, like Keyboard, Mouse, Hard disk, Monitor, etc.

Excel 2013 pivot table cheat sheet