Monday 13 June 2011

Excel 2010 Magic Trick 795: Pivot Table: Transactional Payroll Data Into Employee Reports PivotTable

Title:
Excel 2010 Magic Trick 795: Pivot Table: Transactional Payroll Data Into Employee Reports PivotTable


Video:


Description:Download file: people.highline.edu 1. See how to use a PivotTable to take transactional payroll data and then create individual employee reports. 2. Learn how to use the Report Filter 3. Learn how to use the Show Report Filter Pages feature to create reports quickly. 4. Learn how to select multiple sheet and "Drill Through" to create the same formula on each sheet.

Published:
14/Jun/2011

No comments:

Post a Comment