NEW - Excel Cube Formula Reporting with Microsoft Analysis Services
This is a newly updated multi-media training kit focused on building cube formula reports and dashboards from Analysis Services Multidimensional cubes, Tabular models, or both. It complements the Excel training kit: PowerPivot Formula Reporting Made Easy.
Using Slicers in Excel Cube Formula Reports
Users of Excel 2010/2013 may be familiar with using Slicers to filter data in a PivotTable. But they can also significantly enhance the user experience with reports and dashboards built from Excel cube functions.
Getting tabular data from Analysis Services cubes using a PivotTable
Analysis Services cubes commonly have user-defined hierarchies, such as a date hierarchy. Getting a table of data at the right level of detail can be tricky. Large PivotTables can be slow to set up and manipulate. Learn more on how best to complete this task.
How Excel 2013 differs from Excel 2010 with regard to PowerPivot and Cube Formula reports
Excel 2013 is now publicly available. If you have the Microsoft Office 2013 Professional Plus version and you enable the PowerPivot add-in you can open and modify PowerPivot models from Excel 2010.
Two ways to create a PivotTable from an Excel range using Excel 2010
Learn how to build your PivotTable and get the benefits of Excel's OLAP Tools
One of Excel's best kept secrets
Some reports, such as financial reports, require a very specific layout that PivotTables don't allow. Find out how Excel Cube Functions make it easy to build these reports and stay live-linked to your database. Helps with dashboards too!
Locating words or phrases in a worksheet
This trick can be more useful than Find as it identifies all cells that include the words/phrases at the same time. Great for auditing descriptions in a list of transactions.
Business Modeling and Planning with PowerPivot
PowerPivot for Excel does not support write-back to a data model and as Personal BI it is not intended for shared usage. But it still offers some planning capabilities. This multi-part section describes how.
Cell Mate
Check out Cell Mate for a various wish-I'd-known-that-before video Excel tips, trickery, and shortcuts, many demonstrated with videos.
How to copy a cell down a column - not a drag.
This is a real time-saver when copying a cell down hundreds of rows.