PivotTable and how to create it?

https://aashancompedu.blogspot.com/2023/09/what-is-pivottable-and-how-to-create-it.html

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: 6- Click Right Button by Mouse or press menu button from Key Board then a drop down menu will appear then click on Pivot Table Options..

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.