Pivot table in excel

PIVOT TABLE

Pivot table in excel is  the most powerful and very useful feature of Microsoft Excel .It is a great tool for sorting and summarizing the data in a spreadsheet. It be used to summarize, analyze, explore and present your data in a meaningful way .


I have seen many people are not using Pivot table as they think that it is a very tough  tool to learn & use .Even i thought the same some years back .


Instead of analyzing countless spreadsheet records, a pivot table can aggregate your information and show a new perspective in a few clicks.


Example :
Given below are ID card details of some of my batch mates .The information provided in the ID card are:-
  • Name 
  • Age 
  • Branch
  • Blood group




Using Pivot table we can resolve so many queries we have regarding the information given in the table 
  • How many students have got the same blood group and their names
  • How many are in the   same age 
  • Which are the different branches etc etc etc....
How to make Pivot Table

Goto Insert Tab-Pivot Table 


Click on  Pivot Table 


Then Select the Range of Cells 







Please select New Work Sheet 

We will Move to a new Sheet Like This 


So Pivot Table Is Ready .Now We are going to Resolve our Queries

1.How Many Students Have Got The Same Blood Group And Their Name 

You Have to Drag and Drop the concerned  Field (Blood-group & Name ) Into Raw Label  




II) How many Are In The  Same Age 



III) Different Branches ,Names & Age 















Another Presentation for the same will be 



This is Just the starting of Pivot Table .We can do filtering Additional formatting etc in our Pivot table ,That we will discuss in the next Section 

Note :You can easily change the pivot table summary formulas. Right click on pivot table and select “ summarize data by” option




No comments:

Post a Comment