power4XL Microsoft Excel Resource Center
Free Macros, Formulas, Functions, Tutorials, Downloads, Add-Ins & More!

Monte Carlo Simulation Tutorial

ShareThis

This tutorial shows how to use Microsoft Excel to develop Monte Carlo simulations without the use of add-ins or special software.

The possibilities are limitless, of course, so no tutorial will exhaust the topic.  However, the information presented here provides a solid fundamental understanding of the core concepts, and some advanced techniques for modeling more complex problems.

After completing the tutorial you should have a sufficient understanding of Monte Carlo concepts and Excel capabilities to begin building your own Monte Carlo simulations applied to a wide range of business problems.

You may also download Excel workbooks containing all the major examples presented here, in return for a small donation.

Next

 

Copyright notice:  This site and all content, including computer code and spreadsheet examples, are copyright 2006 by Fritz Dooley.  License is granted for individual users to download examples and to copy code directly into user's spreadsheets and Visual Basic for Applications files.  Users may not redistribute code in any way.  Providing hyperlinks to this web site is encouraged, but posting code and examples on other web sites is expressly forbidden.  "Microsoft" is a registered trademark of Microsoft Corporation.   Neither this web site nor Fritz Dooley is affiliated with Microsoft Corporation.