Learn about one of Excel's best kept secrets. If you use:
You love the slice, dice, pivot and drill of PivotTables but you are frustrated that you can't insert rows or columns and put stuff exactly where you want. You want to build reports that are dynamically linked to but separated from your data, the way it should be. The solution to your problem is Cube Formula Reports. Still part of Excel, they use CUBE functions that can be positioned anywhere in a worksheet, like any other Excel functions. Data and presentation (your Excel report) remain separated, drastically reducing the potential for spreadsheet hell; report users that access a central database all retrieve the same version of the truth. Building Dynamic Reports and Dashboards with Excel Cube Functions is a self-paced multi-media training course that is your express chairlift up the cube function learning curve. The course media provide instruction to suit your learning style and comprise :
Order Building Dynamic Reports and Dashboards with Excel Cube Functions now. (Download is large and may take several minutes).
MONEY-BACK GUARANTEE: If, within one year of your purchase of this course, you are not completely satisfied with it Excelcraft will refund the amount you paid in full.
Platform Windows XP
Operating Systems Windows XP,Windows Vista,Windows 7
System Requirements Microsoft Excel 2007, 2010 or higher. PC with 1 GB RAM, 500 MB free disk space. Adobe Reader.
Date added 4 Oct 2011
Last Updated 1 Apr 2012
Tags Excel,cube function,PivotTables,Analysis Services,PowerPivot,reporting,dashboard, OLAP,cubevalue,cubemember,cube formula reports