Tuesday, 28 February 2017

Pivot Tables


Pivot Tables are one of the most useful tool in excel, and most excel experts says that
this tool is the magic tool for quickly prepare report from huge data  set within a few   second.  

This is so useful and powerful tool that within a few second we can make report according to our need. We will learn here in details about Pivot Table beginning part. Below are the screenshot of the data set from which we will prepare the report.
               




Now create a pivot table from this huge data set “first click on any cell within the data  range” and then  Go to Insert tab àPivot Table drop down àPivotTable \ PivotChart



Click on Pivot Table and following image will appear




In the above image:-

First arrow shows “Select a table or range” i.e. it will show the whole range of the data set from start to end.

Second arrow shows “New worksheet” and press OK. Then it will create a Pivot Table on a new sheet and if you want a Pivot Table on the “Existing worksheet” then you have to give a cell reference in the “Location” box in where you want to create a Pivot Table. 

So it depends on the data set if the data set is huge and lengthy then “New Worksheet” is the good option but if the data set is not hug then “Existing Worksheet” is the good option, I prefer a “New Worksheet”.

       After click on the OK button following image will appear




Start picking the heading from all heading box above and start dropping in the box given 

below (1,2,3,4) according to your need. Like in the below given example, but when you 
will play with, you will understand in a better way.



By the same way we can place Category by Suppliers and so on and then see the magic.

And at the last when we will cross or close the PivotTable Field list box the Pivot Table will be look like below given image:-



        This is the first complete Pivot Table report. 

        This is the simple pivot table tutorial and in the next tutorial we will learn  Pivot                 Table in details.


Narendra

No comments:

Post a Comment

Featured post

Pivot Tables