Rating
Rating: 0.0 out of 0 votes
Related Titles
- FinExcelSoft FinStat Excel Templates
- FinExcelSoft NPV & IRR Excel templates
- FinExcelSoft Securities Excel templates
- FinExcelSoft FinStat
- FES 10 years FinForecast
- FinExcelSoft FinStat Templates for 3,...
- FinExcelSoft Correlation & Regression...
- FinExcelSoft Amortization Excel Templ...
- FinExcelSoft Annuities Excel Templates
- FES EA Inventory Manager
Excel Cube Formula Reporting with Microsoft Analysis Services
Learn about one of Excel's best kept secrets. If you use Excel 2010 or 2013 to analyze data from:- PowerPivot models using the free PowerPivot add-in
- Microsoft Analysis Services cubes
If you use Microsoft Excel to analyze data from:
- Microsoft Analysis Services Multidimensional
- Microsoft Analysis Services Tabular
- Oracle OLAP (using Simba Technologies' MDX Provider for Oracle OLAP)
- Teradata OLAP Connector
- Learning Guide (PDF over 90 pages)
- 40 short, digestible videos
- 7 annotated workbook examples that you can re-use
- Sample database in local cube files
- Make your reports more robust, easier to maintain, and re-usable
- Add drop-down lists to make report parameter selection easy for users
- Add functionality to check key report numbers and display alerts if numbers don't tie
- Use Excel's built-in graphic capabilities to create dynamic dashboards that convey at a glance the values, trend and status of your KPIs, pulled from your centrally-stored data
- Automate report printing using VBA macros
- Debug formulas, work with nested dimensions, member properties, multiple data sources, add additional data rows and columns to existing reports
- Tips to convert legacy "copy/paste/re-key" reports to cube formula reports
- Set up your reports so they remain dynamic when published to Excel Services in SharePoint
- Generally leverage Excel's functionality and your skills to enhance your reports and dashboards and the report reader's experience
Price: $79.95 USD Category: Spreadsheets Screenshot: Added: Oct 27th 2013 Publisher: Ambridge Ventures Limited Homepage: http://www.excelcraft.com