Webinar: Powerful Reporting with Cube Formulas
WK323 | Partner Virtual Events | Advanced | Scheduled
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.
|Number of Credits||Type of Credits|
Good working knowledge of PivotTables and the Excel Data Model
HighlightsOverview of the cube functions available in ExcelUnderstanding 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
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
This webinar is provided by K2 Enterprises. After registering for the course, you will receive an email from K2 with instructions for logging in to the webinar and obtaining your eMaterials.
- Member (Early Bird)
- Non-Member (Early Bird)