What is a PivotTable and how to create it?

PivotTable : A Pivot Table is a easiest way to create summarised data from a large amount of data and it is MS Excel Tool,  You can create a table in attractive manner to . IT is specially used to analyse Numeric data.    

Steps to create a Pivot Table:

Step:1 - Select a cell which data you use to create Pivot Table.

Step:2- Click on Insert Menu.

Step:3- Choose one option within in two - New Work Sheet (to create Pivot Table on                 new Work Sheet.)            

Step:4- Click on Ok Button. You will see a new sheet to create Pivot Table.

Step:5- Drag the fields and drop in given Boxes as you require.

Step: 7- Then you will see another Dialog Box, and Click on Display Tab then Tick on Classical Pivot Table Layout. 

Step: 8- Then you will see a Pivot Table Created but that is not in Proper Format. 

So Right Click by Mouse or pressing Menu button by keyboard with selecting first Table heading then a Dialog Box will appear then click on Non Radio Button, then repeat Non process for other Colum Headings also.   

Step: 9- Your Pivot Table will Create.