Implementing Advanced Pivot Table Techniques 2016

  • 24 May 2016
  • Webinar

Description

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

Past Events

Important

Please, check "Implementing Advanced Pivot Table Techniques" official website for possible changes, before making any traveling arrangements

Event Categories

Business: Finance
Government & Global Issues: Law & Regulations

Other Events with Similar Categories

Other Events with Similar Location or Organizer

Featured Conferences & Exhibitions