Implementing Advanced Pivot Table Techniques 2016 is a webinar that covers topics such as:
- 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
Implementing Advanced Pivot Table Techniques 2016 is intended for:
- CPAs
- Accountants
- Financial consultants
- CFOs
- Controllers