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.