Excel PivotTable Concepts

If you've never made use of Excel Pivot Tables, prepare to be blown away! This hands-on class will lead you to sharpen your reporting skills with the most powerful and under-utilized tools in the Excel arsenal-Pivot Tables and Pivot Charts! You will learn how to use Excel to retrieve database records and other external information as a basis for your reports. Learn to achieve speed with effective handling of large volumes of data and provide flexible reports that can be changed at-will, and format your reports for clarity and professionalism. This class takes a ground-up approach - no prior knowledge of Pivot Tables is required. Bring your own laptop to participate!

  • Retrieving data from external sources 
  • Data layout best practices 
  • Anatomy of a Pivot Table 
  • Using the gallery for style 
  • PivotTable calculations 
  • Drill-down capabilities 
  • Using PivotTables as reporting packages
Session Information
Session Date:
July 21, 2017
OnDemand Reg 7_21_2017 pt 1
OnDemand Reg 7_21_2017 pt 2
OnDemand Reg 7_21_2017 pt 3
OnDemand Reg 7_21_2017 pt 4
Individual topic purchase: Selected
Georgia Society of CPAs
General: 8.00
Subscription
You must be logged in to use your Free CPE Token.
To continue, you need to log in to Peach New Media. If you have any questions about your account please contact us at 1-866-702-3278.
Email Address:
Password:
Products
On-Demand
GSCPA Member Price:$309.00
Non-Member Price:$409.00