How to create a Pivot Table report

[Computer_Freak]

Hi friends,

Many people would be thinking to create a Pivot table Report but don't know how to create it.Don't worry i have found a very simple solution for you, follow the below steps for that.

1. Open the workbook where you want to create the PivotTable report.
   
2. On the Data menu, click PivotTable and PivotChart Report.
   
3. 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?
   
4. Follow the instructions in step 2 of the wizard.
   
5. In step 3 of the wizard, click Finish.
   
6. On the PivotTable toolbar, drag field buttons to the labeled areas on the PivotTable diagram.
   
7. If you want to rearrange the fields, drag them from one area to another. To remove a field, drag it outside the PivotTable report.

[Computer_Freak]

There is one more way of doing it by follow the below steps:-

1. Select any cell in the source data, and press Ctrl+Shift+*
   
2. Press Ctrl+F3, and then type the defined Name for the source data.
   
3. From the Data menu, select PivotTable and PivotChart Report.
   
4. In Step 1 of 3, select Microsoft Excel list or database, and then click Next.
   
   
   • In Step 2 of 3, in the Range box, press F3 to open the Paste Name dialog box, and paste the Name of the source data as defined in step 2.
   
   
5. Click on Next.
   
6. In Step 3 of 3, click Layout (in Excel 97 and go to step 8).
   
7. Click on finish in Step 2 of 3 and then create the PivotTable report by dragging the fields from the Pivot Table Field List dialog box to the PivotTable report.
   
8. In the Layout dialog box, drag the Data Fields to the white Data area, and drag all other fields to the white Page area and then click OK.
   
9. In Step 3 of 3, click Finish. The PivotTable report is created.
   
10. Now Drag Data to the right of the PivotTable report to change the layout from horizontal to vertical.
    
11. The PivotTable report is now ready to be used.