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
Encapsulate Excel Data with Pivot Tables 2015 is intended for:
- Payroll Professionals
- Human Resource
- Auditors
- Employee Management Personnel
- Admin
- Managers
- Anyone that builds spreadsheets for use by others