August 15, 2018


In-Person

City of Pelham Pelham Civic Complex


8 CPE

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

August 15, 2018
In-Person
8 CPE

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

  • View Bio

    Instructor

    Mac
    McClelland

    View Bio

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

8 CPE
8
Other

Things to Know About This Course

Course Level

  • Advanced

Professional Area of Focus

  • Software

Prerequisites

Full understanding of intermediate to advanced PivotTables

Advanced Preparation

None

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

Provider

K2 Enterprises

This event has ended.