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 30 minutes prior to the start of the webinar.