August 29, 2017


In-Person

Alabama Society of CPAs
1041 Longfield Ct, Montgomery, Montgomery County, Alabama 36117-8056


4 Total CPE Credits

product-artwork-659822

K2's Advanced PivotTables, Including PowerPivot

  • Instructor

    Lawrence McClelland

Learning Objectives

  • Upon completing this course, you should be able to:
  • Define Data Models and build PivotTables from these objects
  • Create PivotTables using PowerPivot, including PivotTables that summarize data from multiple data sources
  • Utilize Data Analysis Expressions and other tools to add calculations to PivotTables
  • Add features such as Key Performance Indicators, Dimensions, and Hierarchies to PivotTables

Major Topics

  • Create advanced PivotTables from Excel Data Models
  • Utilize PowerPivot to manipulate Data Models and add KPIs, hierarchies, and dimensions to your PivotTables
  • Add sophisticated calculations to your PivotTables using Data Analysis Expressions functions and other techniques

CPE Credits Available

4
Total CPE
4
Computer Science

Alabama Society of CPAs

1041 Longfield Ct, Montgomery, Montgomery County, Alabama 36117-8056

Get Directions

Things to Know About This Course

Course Level

  • Advanced

Prerequisites

Full understanding of intermediate to advanced PivotTables

Advanced Preparation

None

Intended Audience

Business professionals using premium editions of Excel 2013 and Excel 2016 who are seeking to extend their knowledge of PivotTables

Provider

K2 Enterprises

This event has ended.