Let's Talk about .. Excel 2007-Pivot Table

Pivot Table is a powerful summation tool that is used to analyse. It's very essential thing but easy to create and use. I will show you how easy to create it is

1. I create the excel table as the example as shown in this figure.


2. Then, I select the cell that I want to create the Pivot Table for example, G2.


3. Go to Insert tab->PivotTable->PivotTable.


4. The CreatePivotTable window appears, then you select all the cells of your information that you want to create the Pivot Table. Then, the Range shows in the textbox. Moreover, you can select the Table if you're already name your table.
   
5. Click OK.
   
6. The PivotTable Field List appears in the right zone. You can drag the fields into the below bottom which are Report Filter, Column Labels, Row Labels, Values. You can manage your Pivot Table to make it useful for your analysis. I managed my Pivot Table as shown in the following figure.


7. Then, I got my Pivot Table.