Details

Speaker(s):  Bill Jelen 

Duration: 120 minutes

Track: Analyze & Interpret

In this session we will take a deep dive to look at the settings in Excel pivot tables, subtotals, and data consolidation. The sample data sets will be typical invoice registers, sales reports and customer lists. 
Attendees will learn how to use pivot tables to quickly create year-over-year analyses and how to apply an AutoFilter to a pivot table in order to filter on a single column or to generate a true top 10 report. Learn how to roll up daily dates in a pivot table by week, or into 13-monthly periods. Learn how to consolidate data of different shapes using the Consolidate command. Learn how to produce a high-to-low report of sales by customer using the Subtotal command. Learn when to take your flat data through Power Pivot to create asynchronous reports. Learn how to leverage GetPivotData to create beautifully formatted reports instead of hating Excel’s insistence on using it.