K2's Excel PivotTables for Accountants - Part II

K2's Excel PivotTables for Accountants - Part II

  • $129.00

Course Description

This webinar is a continuation of Excel PivotTables for Accountants – Part I. It extends and builds upon the foundation of PivotTable topics covered in that course and includes in-depth coverage of using advanced data summary functions and creating calculated items and fields.

Major Topics

  • Making calculations in PivotTables using calculated fields, calculated items, and field settings
  • Enterprise-class PivotTables, including using PowerPivot to build complex PivotTables
  • Analyzing data with PivotTables using advanced techniques
  • PivotTable tips and tricks

Learning Objectives

Upon completing this course, you should be able to:

  • Create PivotTables and PivotCharts and add advanced elements to PivotTables, such as calculated fields and calculated items
  • Describe three methods for making calculations in PivotTables
  • Create enterprise-class PivotTables from large and complex data sets, using tools such as On Line Analytic Processing and PowerPivot
  • Utilize advanced sorting and filtering techniques, PivotCharts, and GETPIVOTDATA to analyze PivotTable data
  • Describe how to apply specific PivotTable techniques such as Show Report Filter Pages and VLOOKUPs to solve specific issues associated with PivotTables

    Who Should Attend: Accounting  and financial professionals who want to use the power of Excel PivotTables to analyze and summarize data

    Course Level: Advanced

    CPE Credits: 4 Hours Computer Software and Applications  

    Prerequisites: Excel PivotTables for Accountants – Part I or equivalent level of knowledge

    Advance Preparation: None

    PLEASE NOTE: Registration cutoff is 2 days prior to the start of the webinar.