Encapsulate Excel Data with Pivot Tables 2015

Key Topics

• 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

Who should Attend

• Payroll Professionals
• Human Resource
• Auditors
• Employee Management Personnel
• Admin
• Managers
• Anyone that builds spreadsheets for use by others