Home > Excel Business Solutions > Excel Productivity > Training and Tutorials > Cube Functions Share

Cube Functions

Excel cube functions for training and tutorials


Excel Cube Functions

Rate this solution:
(3/5 from 1 vote)
Cube Functions screenshot
Cube Functions for Excel is a complete set of training material for developing powerful reports and dashboards from mulch-dimensional data in Excel 2007 and higher.

Cube Functions for Excel training material includes Excel workbook examples, sample database, PDF documentation and demonstration videos to utilize cube functions for analyzing data from Microsoft Analysis Services cubes, Power Pivot for Excel (2010), Oracle OLAP cubes and Teradata OLAP Connector sources.

Key features of Cube Functions for Excel include:

  • Build dynamic reports and dashboards using Excel cube functions.
  • Data and report presentation remain separated, drastically reducing the potential for errors.
  • Make reports more robust, easier to maintain and re-usable.
  • Add drop down lists to make report parameter selection easier for users.
  • Add functionality to check report results and highlight discrepancies.
  • Utilize Excel's built-in charting capabilities to create dynamic dashboards that convey at a glance the values, trend and status of key performance indices pulled from  centrally stored data sources.
  • Automate report printing using VBA routines.
  • Debug formulas, work with nested dimensions, manage member properties, work with multiple data sources and add additional data rows and columns to existing reports.
  • Convert legacy 'copy and paste' reports to cube function reports.
  • Use Power Pivot for Excel as a data source to aggregate millions of rows of data from multiple Microsoft and non-Microsoft sources. The enables the efficient creation of powerful business intelligence applications.
  • Set up reports so they are dynamic when published to Excel Services in SharePoint.

Get It

Price: USD 49.95
(Updated on 2015-10-30)

Related Excel Solutions for Cube Functions

Charting CoursesTraining and Tutorials  OLAP ReportingPresentation and Reporting  Database Report BuilderData Management  Report BuilderPresentation and Reporting  Functions and FormulasTraining and Tutorials  Video TrainingTraining and Tutorials  Database Reporting ToolsData Management  Business Intelligence TrainingTraining and Tutorials

Share your thoughts and opinion with other users: Create Review

Browse Main Excel Solution Categories

Business Finance Financial Markets Operations Management Excel Productivity

Additional Excel business solutions are categorized as and the . Further solutions proposed for specific user requirements can be either found in the Excel Help Forum or proposed as a project to the Excel freelance community.