K2's Powerful Reporting with Cube Formulas

K2's Powerful Reporting with Cube Formulas

  • $79.00


Course Description

The Excel Data Model (an OLAP cube) can be viewed as a multi-dimensional PivotTable. The intersections of the rows, columns, and other dimensions are summarized in the cube and can be extracted into a report using cube functions that specify the desired intersections. Hence, a PivotTable is not required to summarize and report data stored in the Excel Data Model. Excel has seven built-in cube functions for creating reports without using a PivotTable, while maintaining the ability to refresh a report as the underlying data changes. Don't miss this opportunity to learn how to use cube formulas to produce dynamic formal reports from the Excel Data Model.

Major Topics

  • Overview of the cube functions available in Excel
  • Understanding the Data Model and how to specify an intersection
  • Building cube formulas that can be copied down and across
  • Creating reports using implicit and explicit measures

Learning Objectives

Upon completing this course, you should be able to:

  • List the seven cube functions available in Excel
  • Use a PivotTable to create an implicit measure
  • Create explicit measures using PowerPivot or from the PivotTable Field List in Excel 2016
  • Describe the process of creating formal reports with cube functions
  • Employ mixed cell references in formulas to build complex reports quickly and easily

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: Good working knowledge of PivotTables and the Excel Data Model

Advance Preparation: None

PLEASE NOTE: Registration cutoff is 2 days prior to the start of the webinar