Implementing Advanced Pivot Table Techniques 2016

Key Topics

• Compiling unwieldy data into the format required for pivot table analysis quickly and easily
• Avoiding frustration by understanding the nuances of pivot table formatting
• Drilling down into numbers with a double-click or preventing other users from being able to do so
• Discovering how pivot tables differ from worksheet formulas and learning the importance of the Refresh command
• Filtering data faster by way of the Slicer feature in Excel 2010 and later
• Embedding frequently used lists, such as employees, departments, or key customers, into Excel`s interface for use with any spreadsheet
• Understanding how the Table feature can vastly improve the integrity of pivot tables
• Learning how the Table feature allows you to transform filtering tasks
• Understanding the nuances associated with subtotaling data within a pivot table
• Controlling multiple pivot tables and charts instantly with the Slicer feature
• Using a simple keyboard shortcut to post the same formula to multiple cells at once
• Summarizing information from Access databases and other sources
• Understanding how to use the Report Filter command to create breakout tables and dig deeper into the number

Who should Attend

• CPAs
• Accountants
• Financial consultants
• CFOs
• Controllers