Advance Excel (Pivot Table)

INTRODUCTION OF PIVOT TABLE

A pivot table is an important tool of Microsoft Excel and it is used to organized data in a simple and standard format.

Normally pivot table supports the following tasks.

1. Sorting: Sort the data in ascending and descending order.

2. Filtering: Filter the data to get the desired result.

3. Hide and unhide the data.

EXAMPLE - 1
1. Open the Microsoft Excel.

2. Insert the following data items in excel.

3. Select the data and click on "Pivot table" from Insert menu.

Note: Cell address automatically assigns in "Table Range" because we triggered pivot table after select the data.

4. Now insert Emp._name in "Row Labels", Salary in "Values" and Dept. in "Report Filter"

EXAMPLE - 2

1. Open the Microsoft Excel.

2. Insert the following data in excel sheet.

3. Now suppose, we want to calculate total sales of Salesman A, Salesman B, and Salesman C.

4. So, select the data and insert in the pivot table.

4. The above pivot table view showing in "Row Labels" format and we can convert it in "Column Labels" format by just moving "Month" field under "Column Labels"

HOME