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:
You may also be interested in a Monte Carlo Simulation tutorial in Python.