August 15, 2018


City of Pelham Pelham Civic Complex

8 Total CPE Credits


K2's Excel Data Magic, Including Advanced PivotTables and Power Pivot

  • Instructor

    Lawrence McClelland

Learning Objectives

  • Upon completing this course, you should be able to:
  • Construct and manage links from external data sources into Excel for the automatic acquisition of data
  • Define, build, and manage Data Models and build PivotTables from these objects
  • Create PivotTables using Power Pivot, 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 Power Pivot-based PivotTables
  • Create compelling visualizations of the data in your Power Pivot-based PivotTables using PivotCharts and Power View

Major Topics

  • Creating links from external data sources - such as accounting and ERP systems - into Excel
  • Working with Excel's Data Model feature
  • Using Power Pivot to create summaries of data linked into Excel
  • Creating summarizations of Data Models using CUBE formulas
  • Transforming data summaries into interactive, compelling visualizations using PivotCharts and Power View

CPE Credits Available

Total CPE

Things to Know About This Course

Course Level

  • Advanced

Professional Area of Focus

  • Software


Full understanding of intermediate to advanced PivotTables

Advanced Preparation


Intended Audience

Business professionals using the Windows-based premium editions of Excel 2013 and Excel 2016 who are seeking to extend their knowledge of Excel as a reporting tool


K2 Enterprises

This event has ended.