Tuesday, 18 December 2012

Use of Pivot Table in MS-Excel

Use of Pivot Table in MS-Excel

 
Pivot table is one of the most important and useful feature of MS Excel. Normally pivot table is used for Zonal sale analysis or such kind of other analysis where you have to analyze the thing category wise. Let’s have an example, where we are assuming that 24 Managers of an electronic company are posted at 24 different cities of India. And we have selected these cities according to four zones i.e. North, East, South and West.


 
 


First step to prepare Pivot table is to select data from A1 to I25
Next step is to click on Insert --> Pivot Table --> Pivot Table
 
 
The following dialog box will appear on the screen:

 


If you have not selected the range from A1 to A25 then you can select the range by clicking the red-arrow. Just press OK to get Pivot table on new worksheet. The Pivot table will appear on new worksheet :


 


On the right side of excel screen there is field list. Now Just by clicking on Zone and Total we can get the total zone wise sales.

 
 

By this way we can click on Manager-Total, State-TV, Zone-WM etc. This way Pivot table give us freedom to revolve our different analysis around few clicks.

No comments:

Post a comment