Cart 0
K2's Powerful Data Analysis with PowerPivot - On Demand (2 hours)

K2's Powerful Data Analysis with PowerPivot - On Demand (2 hours)

Course Description

PowerPivot provides unparalleled options for analyzing data and preparing summary reports in Excel. With PowerPivot, available in Microsoft Office Professional Plus or the standalone version of Excel, your PivotTable reports become even more powerful. PowerPivot can connect directly to a large number of common external data sources or can be used in conjunction with Power Query for superior data import and transformation capability. DAX functions allow users to create sophisticated calculations, both columns and measures, and the relational functionality of PowerPivot provides all the tools necessary for creating an intermediary database from multiple data sources. Put PowerPivot to use immediately by participating in this very practical session, which is sure to help you improve your analytical and reporting processes.

Major Topics

  • Creating basic PivotTables with the Excel Data Model and PowerPivot
  • Using external data sources with PowerPivot
  • Converting PivotTables into individual formulas that can be refreshed from the data source
  • Relating multiple tables with PowerPivot
  • Creating calculated columns and calculated fields using DAX functions in PowerPivot
  • Adding key performance indicators to PivotTable reports

Learning Objectives

Upon completing this course, you should be able to:

  • Differentiate between ordinary PivotTables and those created with PowerPivot
  • Describe the advantages of working with PowerPivot
  • Explain, at a high-level, the procedure for building a PivotTable using PowerPivot
  • Define Data Models, Data Analysis Expressions, and Key Performance Indicators
  • Create reports from data summarized using PowerPivot

Who Should Attend: Accountants and finance professionals who want to streamline and improve their data analysis and reporting processes

Course Level: Advanced

CPE Credits: 2 Hours Computer Software and Applications  

Prerequisites: Users of Excel 2013/2016 or Office 365 that have a good working knowledge of Excel and PivotTables

Advance Preparation: None

Instructional Delivery Method: QAS on-demand learning, including review and final exam questions. To earn credit, participants must pass the final exam with a score of 70% or better within one year of registering for this course. Participants may attempt take the final exam up to 10 times.