Monte Carlo Simulation Tutorial with Excel

Video collection of data analysis tutorials with Monte Carlo Simulation using pure Excel and it's built-in Data Table feature. Monte Carlo simulation allows the analysis of complex systems that deal with uncertainty. The techniques demonstrated are native to Excel, no add-ins are used.

Monte Carlo Simulation is generally used to evaluate uncertainty or risk in real-life decision making where data is used to develop probability distributions on which to base uncertainty. Monte Carlo is particularly well-suited to model finance and investment decisions in both long and short term time horizons.

The spreadsheets used in these videos:

Download Asset

Portfolio Simulation

XLSX — Excel Workbook

Download File

Download Asset

Stock Price Simulation

XLSX — Excel Workbook

Download File

You may also be interested in a Monte Carlo Simulation tutorial in Python.

Porfolio Simulation

Stock Price Simulation