Learning Resources
 

The pivot table

The pivot table
Use a PivotTable report when you want to compare related totals, especially when you have a long list of figures to summarize and you want to compare several facts about each figure. Use PivotTable reports when you want Microsoft Excel to do the sorting, subtotalling, and totalling for you.

Following steps are to be taken for creating a pivot table -

  • Open the workbook where you want to create the PivotTable report.  
  • On the Data menu, click PivotTable and PivotChart Report.
  • In step 1 of the PivotTable and PivotChart Wizard, follow the instructions, and click PivotTable under What kind of report do you want to create?
  • Follow the instructions in step 2 of the wizard.
  • In step 3 of the wizard, determine whether you need to click Layout.
  • Click Ok to generate the pivot table report or chart