K2's Powerful Reporting with Cube Formulas - On Demand (2 hours)

K2's Powerful Reporting with Cube Formulas - On Demand (2 hours)

  • $89.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 and newer
  • 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

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.