How to Use Pivot Table in Excel
Pivot Tables is one of the Excel's most powerful features. A Pivot Table allows you to extract the significance from a large, detailed data set
Insert a Pivot Table
To insert a pivot table, Below the following steps.
1. First Arrange the Data Field in Cell
Below Following Example
A
Description Value
Book 251
Dictionary 25
Pencil 245
Pen 21
Eraser 10
Text Book 12
Sharpener 4
2 Next Select the Selected Data
3 Go to Insert Menu
4 Click on Pivot Table Dialog box
5 Below Screenshot Create Pivot Table Click OK
Screenshot Image Link 1
Pivot Table Will be Created
Go to Pivot Table Sheet
in Pivot Table Filed Tools
Choose Field to add to Report Option
Click on Description & Value Field
Now Description Drag to ROWS Field
Then Value Drag to VALUES Field
That's it Pivot Table is Created
Here the Below Pivot Table Completed Screenshot
Screenshot Image Link 1
Insert a Pivot Table
To insert a pivot table, Below the following steps.
1. First Arrange the Data Field in Cell
Below Following Example
A
Description Value
Book 251
Dictionary 25
Pencil 245
Pen 21
Eraser 10
Text Book 12
Sharpener 4
2 Next Select the Selected Data
3 Go to Insert Menu
4 Click on Pivot Table Dialog box
5 Below Screenshot Create Pivot Table Click OK
Screenshot Image Link 1
Pivot Table Will be Created
Go to Pivot Table Sheet
in Pivot Table Filed Tools
Choose Field to add to Report Option
Click on Description & Value Field
Now Description Drag to ROWS Field
Then Value Drag to VALUES Field
That's it Pivot Table is Created
Here the Below Pivot Table Completed Screenshot
Screenshot Image Link 1