One of Excel's best kept secrets ...
is Excel Cube Functions. Click here
for an overview.
Business Modeling and Planning with Power Pivot
How you can add assumptions and modeling capabilities to you Power Pivot Data Model. Read more >
Excel and Power Pivot for accountants and finance managers
Articles and links to articles describing how accountants, finance managers and finance professionals might leverage Power Pivot as a robust platform to handle a variety of financial reporting and analysis needs. Read more >
Excel reports that combine data from Power Pivot and Power BI
Let's say that you have some budget data in an Excel Data Model. In Power BI (PBI) the corresponding actual historical data has been published by your finance department. You want to conduct some performance analysis between the two data sets. Read more >
Slicing and dicing text values in a PivotTable
Want to retrieve text (as opposed to numeric) values into a PivotTable to slice-dice-pivot the text? Read more >
Comparing Actual and Budget with a Scenario table
In certain circumstances you may find it useful to set up Actual and Budget data (perhaps multiple flavors of Budget) in your Data Model using a Scenario table. Doing so reduces the number of time calculation measures that you need to create (MTD, QTD, YTD etc). This video
shows how you might do this.
Calculation based on blank CUBEVALUE result returns #VALUE!
If an Excel CUBEVALUE function returns a blank and is used in a subsequent calculation you may get a #VALUE!
error. This video
shows one way to address the problem.