9 articles in this selection
|
|
| 2009/03/02 Monte Carlo Simulation: Random Number Generation
Our example of Monte Carlo simulation in Excel will be a simplified sales forecast model. Each step of the analysis will be described in detail. The Scenario: Company XYZ wants to know how profitable it will be to market their new gadget, realizing there are many uncertainties associated with market size, expenses, and revenue. The Method: Use a Monte Carlo Simulation to estimate profit and evaluate risk....
| |
|
|
|
|
| 2008/10/14 Excel Core Knowledge Wiki
We put together this wiki to create a training resource for data analysts using Excel. Together with your input, we'd like to develop a short list of the most important Excel skills for data analysis and gather teaching materials for each of these skills....
| |
|
|
| 2008/10/14 Microsoft Excel: Revolutionary 3D Game Engine?
In this article I will demonstrate Excel's arithmetical facilities, the embedded rendering subsystems (there are two of them!) and the revolutionary approach which might just cause a paradigm shift. I hope you will discover that Excel effectively and efficiently incorporates practicality, tons of features, the multi-platform portability and the high performance with the unique and futuristic 3D engine features....
| |
|
|
|
|
| 2008/10/07 Building an Excel Dashboard with Sparklines to Provide Web Analytics ...
Dashboard Spy reader Andreas Lipphardt of microcharts.net has been working on some nice excel dashboards that monitor website traffic and use sparklines to provide analysis. He kindly documented some of his excel dashboarding processes and has provided you Dashboard Spy readers with the main content of this post....
| |
|
|
|
|
|
|