
K2's Powerful Reporting with Cube Formulas - On Demand (2 hours)
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.