2010/08/19

2009/03/02

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....

2009/01/19

2008/10/14

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

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/14

Who said Excel takes lot of time / steps do something? Here is a list of 15 incredibly fun things you can do to your spreadsheets and each takes no more than 5 seconds to do.

2008/10/07

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....

2008/10/03

How to create an OLAP cube for use with Excel Pivot Tables.

2008/08/13

List of Excel Tips and Techniques

2010/09/04

The reality is that management by targets was always going to run into trouble. Wherever there are targets, there are a series of unintended consequences, many of which hit our headlines on a daily basis. From a systems thinking perspective, targets are actually tools and have long been in the frame for damaging improvement, preventing learning and sowing disorder. Here’s why....

2010/09/04

KeyWack is a game for people with babies and small children who like to sit at their parent’s computer and bang the keyboard. KeyWack prevents babies from accidentally opening most programs or documents, and makes banging even more fun by drawing shapes and playing random sounds as the keys are whacked. You can also click with the mouse to place a shape at a particular location....

2010/09/04

(Supposedly) an article from the 50's that describes how a good housewife should behave