Many Microsoft Excel users feel that pivot tables are somehow beyond their grasp, yet this is one of Excel's easiest and best features. In this course Excel expert David Ringstrom, CPA, shows you how to whip ugly raw data into a format ready for analysis with a pivot table. You'll quickly be dragging and dropping fields to instantly create reports from lists of data. For this session David offers four different handouts that are specific to Excel 2013, 2010, 2007, and 2003, respectively.
You learn how to:
- Quickly whip unwieldy data into the format required for pivot table analysis.
- Use a simple keyboard shortcut to post the same formula to multiple cells at once.
- See how the Table feature can vastly improve the integrity of pivot tables in Excel.
- Explore the basics of pivot table creation.
- See the nuances of subtotaling data within a pivot table.
- Dig deeper into the numbers by using the Report Filter command to create break-out tables.
- Incorporate calculations within, or alongside, pivot tables.
- Disable the GETPIVOTDATA function if you don't need it.
- See how pivot tables differ from worksheet formulas and the importance of the Refresh command.