Check sibling questions




Use of Pivot table to Generate Reports - Pivot Table


Download and try


How to Do

Doing it manually or by using links will take a lot of time

Hence,we can use Pivot table


How to Use Pivot table

Select Table (including heading but not total)

Insert-->Pivot table--Ok


For Q1

Right Click Department---Add to Columns

Right Click Expense---Add to Rows

Right Click Amounr-Add to Rows

Extra item if important-Add to Report Filters


Davneet Singh's photo - Teacher, Engineer, Marketer

Made by

Davneet Singh

Davneet Singh is a graduate from Indian Institute of Technology, Kanpur. He has been teaching from the past 12 years. He provides courses for Maths and Science at Teachoo.