November 22, 2022


Webinar


2 Total CPE Credits

product-artwork-1763561

K2's Data Analysis Using Power Pivot

  • Instructor

    Thomas Stephens

Learning Objectives

  • Differentiate between ordinary PivotTables and those created with Power Pivot
  • Identify the advantages of working with Power Pivot
  • Explain the procedure for building a PivotTable using Power Pivot
  • Define Data Models, Data Analysis Expressions, and Key Performance Indicators

Major Topics

  • Connecting to external data sources
  • Relating multiple tables to create Data Models
  • Summarizing and analyzing data
  • Using DAX to create user-defined calculations

CPE Credits Available

2
Total CPE
2
Accounting

Things to Know About This Course

Course Level

  • Advanced

Prerequisites

Fundamental knowledge of computer operations and Microsoft Office Excel, including creating PivotTables

Advanced Preparation

None

Intended Audience

Accountants and business professionals who are seeking to improve financial analysis processes by taking advantage of the Power Pivot feature found in Windows-based versions of Excel

Provider

ACPEN

This event has ended.