Welcome to NJITM Education

njitm blog Pivot Table in Advance Excel - NJITM

Pivot Table in Advance Excel

  • 14 September 2020
Pivot Table in Advance Excel

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


our latest news

English Speaking Course

Start Talking in English in Just 45 Days.


For Inquiry Click Here.

Digital Marketing Course

Become a Digital Marketing Expert with us.


For Inquiry Click Here.

Get Affiliation Franchise

Connect  with us to Upgrade your Institute.

For Inquiry Click Here.