<img height="1" width="1" style="display:none" src="https://www.facebook.com/tr?id=539359806247306&ev=PageView&noscript=1"/>

 

 Assignment

 

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

 

  1. Accounts Tax
  2. Excel
Ask Download

About the Author

CA Maninder Singh's photo - Expert in Practical Accounts, Taxation and Efiling
CA Maninder Singh
CA Maninder Singh is a Chartered Accountant for the past 6 years. He provides courses for Practical Accounts, Taxation and Efiling at teachoo.com.
Jail