excel pivot table tutorial pdf free download

Then in the popping dialog, check the option you need under Choose where you want the PivotTable report to be placed section.Ĩ. Select the whole new table, and click Insert > PivotTable > PivotTable.ħ. Then create a new pivot table based on this new table. Now a new pivot table is created, and double click last cell at the right down corner of new Pivot table, then a new table is created in a new worksheet. Click Next to go to the last step of the Wizard, check the option you need under Where do you want to put the PivotTable report section. Select your base data, then click Add to add the data range to the All ranges list. Click Next to go to the next dialog to check I will create the page fields option, and click the Next.ģ. Note: You can also add the PivotTabe and PivoChart Wizard command into the Quick Access Toolbar, and click to open the dialog.Ģ. Press Alt + D + P shortcut keys to open PivotTable and PivotChart Wizard dialog, then, check Multiple consolidation ranges option under Where is the data that you want to analyze section and PivotTable option under What kind of report do you want to create section. To reverse the pivot table, you need to open PivotTable and PivotChart Wizard dialog first and create a new pivot table in Excel.ġ. Reverse pivot table with PivotTable and PivotChart Wizard

(7 steps)Reverse pivot table with Kutools for Excel’s Transpose Table Dimensions (11 steps)Reverse pivot table with PivotTable and PivotChart Wizard Now I will tell you the quick ways to reverse a pivot table in Excel. Have you ever wanted to reverse or transpose the pivot table in Excel just like the below screenshots shown.

Excel pivot table tutorial pdf free download