Description

Encapsulate Excel Data with Pivot Tables 2015 is a webinar that covers topics such as:

Dig deeper into the numbers by using the Report Filter command to create break-out tables. This empowers you to easily share reports with team members by breaking their data out to separate worksheets
Avoid frustration by understanding the nuances of pivot table formatting. Pivot tables are best thought of as having one foot in worksheet cells and one cell out
Discover the new Recommended Pivot Tables feature in Excel 2013, which gives even someone that’s never seen a pivot table a jump start on summarizing data
Disable the GETPIVOTDATA function if you don`t need it for your analysis. This function can make simple ad hoc calculations involving pivot table data more difficult than necessary
Incorporate calculations within, or alongside, pivot tables
Drill down into numbers with a double-click--or prevent users from being able to do so
Quickly whip unwieldy data into the format required for pivot table analysis. Your pivot tables are only as good as the underlying data
Learn the basics of pivot table creation, as well as differences in the user interface between Excel 2003, 2007, 2010, and 2013
See how the Table feature can vastly improve the integrity of Pivot Tables in Excel. Users generally base pivot tables on a static range of cells, which can lead to data integrity issues when additional information is added to the source list later
See how pivot tables differ from worksheet formulas and the importance of the Refresh command
Use a simple keyboard shortcut to post the same formula to multiple cells at once. This can help you quickly fill in gaps in a spreadsheet as you prepare a list for analysis with a pivot table
See the nuances of subtotalling data within a pivot table, as well as techniques for grouping and ungrouping data based on date ranges and other criteria