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
Continue.........
Page 2 >Page 3 >Page 4 >Page 5 >Page 6 >Page 7 >Page 8 >Page 9 >Page 10 >Page 11
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
Continue.........
Page 2 >Page 3 >Page 4 >Page 5 >Page 6 >Page 7 >Page 8 >Page 9 >Page 10 >Page 11