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