A pivot table is a summary of your data, packaged in a chart that lets you report on and explore trends based on your information. Pivot tables are particularly useful if you have long rows or columns that hold values you need to track the sums of and easily compare to one another.
How to Use Pivot Tables
First we need data for doing pivot table.
Insert a Pivot Table
To insert a pivot table, execute the following steps.
1. Click any single cell inside the data set.
2. On the Insert tab, in the Tables group, click PivotTable.
The following dialog box appears. Excel automatically selects the data for you.
Excel will ask you Choose where you want to PivotTable report to be placed.
1. New Worksheet
2. Existing Worksheet
Default it Select on New Worksheet
Click Ok
Select column name which you want to show in report.
1) Emp_Name
2) Emp_Dept
3) EMP_Salary
After Select columns you see the result
Data is not arrange in a proper manner so we need to arrange rows as per our requirements.
Drage Emp_Dept to top of Emp_Name
Now it show perfect result which we want.
1) Total expenses of every department
2) Department wise staff details
This is a simple example of Pivot Table.
New Jyoti Institute of Technology and Management
