Learn Excel Cube Formula Reporting with an Excelcraft Training Kit, now released in Second Editions

"Excelcraft training kits exposed the most powerful and hidden abilities of Excel while delivering best practice strategies, real world examples, and step-by-step guidance. I would highly recommend them."

DS – Financial Reporting Manager - Greenville, SC

If you use Excel to:

  • Connect to Microsoft Analysis Services databases (Multidimensional or Tabular)
  • Work with Data Models using Power Pivot, Power BI or in plain Excel

you can take advantage of one of Excel's best kept secrets! You may be frustrated by the limitations on moving part of you PivotTable somewhere else, or inserting rows or columns within it. For some of your management or financial reporting projects you need to be able to layout your reports or dashboards, and sections within them, in a specific way. But you want to retain the dynamic link to your cubes or data models. And PivotCharts have their uses but can be limiting in the control you have over presentation.

This is where Excel's Cube Formula Reports can help. Driven by Cube Functions that, like any Excel function, can be placed pretty much anywhere, they allow you to structure your reports and dashboards the way you want them. But they still retrieve data dynamically from your models or cubes (or both) according to the parameters that you supply to the functions (date, product, region, customer, business unit, department, metric and so on).

Excel makes it easy to get going with Cube Formula Reports, with the Convert to Formulas menu option, under the OLAP Tools drop-down, of the PivotTable Tools tab; use it to convert a PivotTable to formulas, usually easier than starting from scratch, and much easier than building GETPIVOTDATA functions

As easy as it is to Convert to Formulas you'll want to make your reports and dashboards more robust while easier to maintain and enhance. Here are two multimedia Training Kits, sold in over 25 countries, to help you do just that.

You will get up and running, developing reports quickly securing 80% of the benefits with 20% of the effort. In addition to topics specific to each of these Learning Guides you will learn about:

  • Making your reports more robust, easier to maintain, and re-usable
  • Adding drop-down lists and slicers for smoother report filter selection and dashboard navigation
  • Adding functionality to check key report numbers and display alerts if numbers don't tie
  • Automating report printing using VBA macros
  • Debugging formulas, working with nested dimensions, member attributes, multiple data sources, adding new data rows and columns to existing reports
  • Converting legacy "copy/paste/re-key" reports to cube formula reports
  • Setting up your reports so they remain dynamic when published to SharePoint
  • Leveraging Excel's functionality and your skills to enhance your reports and dashboards.

Find out more about how Excel Cube Functions help you build structured management or financial reports and dashboards quickly and easily.

© 2011-17 Excelcraft.com

Home            Terms of Use            Privacy            Cookies            Contact