Products

Make robust Excel reports and dashboards quickly and easily using Cube Functions. An Excelcraft Training Kit will show you how.

Excel Cube Formula Reporting with the Data Model (2nd Edition)
Excel Cube Formula Reporting with the Data Model (2nd Edition)
Excel Cube Formula Reporting with Microsoft Analysis Serrvices (2nd Edition)
Excel Cube Formula Reporting with Microsoft Analysis Services
 (2nd Edition)

If you use Excel to:
  • Work with Data Models using Power Pivot, Power BI or in plain Excel
  • Connect to Microsoft Analysis Services databases (Multidimensional or Tabular)
you can take advantage of one of Excel's best kept secrets!
"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 – Principal BI Consultant – Greenville, SC, USA

“I love the clear and concise way everything is laid out!”
CJ – Principal BI Consultant – Cheshire, UK
You may be frustrated by the limitations on moving a part of you PivotTable somewhere else, or inserting rows or columns within it.
PivotTable warning

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.
Balance sheet example
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).
CUBEVALUE driven by report parameters

Excel makes it easy to get going with Cube Formula Reports, with the Convert to Formulas menu option. Use it to convert a PivotTable to cube formulas, usually easier than starting from scratch, and much less stressful than building GETPIVOTDATA functions off various PivotTables squirreled away in your workbook.
Convert to Formulas

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. An Excelcraft Training Kit will show you how to do just that and in addition, you will learn to:
  •     Make your reports re-usable and save development time
  •     Add drop-down lists, slicers, and timelines for smoother report filter selection and dashboard navigation
  •     Add functionality to check key report numbers and display alerts if numbers don't tie
  •     Automate report printing using a simple VBA macro
  •     Quickly add new data rows and columns to existing reports
  •     Convert legacy "copy/paste/re-key" reports to Cube Formula Reports
  •     Set up your reports so they remain dynamic when published to SharePoint
  •     Leverage Excel's functionality and your existing skills to enhance your reports and dashboards
  •     Debug formulas, work with nested dimensions, member attributes, multiple data sources, and more

Find out more about the specifics of each Training Kit:
 Excel Cube Formula Reporting with the Data Model (2nd Edition)
 Excel Cube Formula Reporting with Microsoft Analysis Services (2nd Edition)
Share by: