How to Insert pivot Table In Excel sheet 2007

How to Insert pivot Table In Excel

Here you can find step by step Process to insert pivot table in Excel Sheet:

Follow the steps one by one to insert :

Step 1 : select the data range that you need to insert pivot table
step 2 : click insert menu go to the left corner end where you can see the pivot table option and pivot chart option menu.
Step 3 : select pivot Table option
Step 4 :  A pop Up menu appears on the screen
Step 5 : select that create a table a in new sheet if u want to see your table in next sheet or else select create a table in an existing sheet.
Step 6 : Click Ok
Step 7 : Finish you can see the Pivot table on your screen

Tip:Press Alt then N then V then T ( Alt+N+V+T) gives you pivot table directly

screen shots ;

Step 1: select data for whcih u need pivot table

Step 2 : go to insert menu select pivot table

Step 3 : then a pop up appear, make sure that ensured data range is correct then click ok.

Step 4 : drag and frop colums that you want as heading in drop data item here dialouge box.

step 5 : here you go.

 

 

 

 

 

 

 

 

 

Still Confuse in Mind ?

Post your doubts in comment column we will give you solution.