Purchase any Event and get
20% Off
CODE: TWENTY20
T&C applicable, please referFAQ
Validity : 16th Dec'24 to 26th Dec'24
The Monte Carlo Simulations in Excel for Risky Investments
- Random numbers generation.
- Rolling Dice using Excel.
- Simulation risk profiles of long-term capital investments.
- Practice problems and solutions.
Overview of the webinar
This workshop is about understanding what is behind the Monte Carlo Simulation. First, you will find out who is using simulations and for what purposes (risk analysis, operations, investments.) The next part is about having fun applying simulations - rolling dice on a spreadsheet. Once you understand how it is done, we can go into a couple of projects. One project is when we simulate a four years budget for 200 times (800 years.) The workshop will have other examples of Monte Carlo simulations.
Who should attend?
- Finance
- Statistics
- Risk managers
Why should you attend?
Excel users that would like to learn how to use risk simulations. User should have elementary understanding of statistics and intermediate Excel skills. This workshop was taught by the presenter in the executive MBA programs, where the attendees did not have a statistical background.
- Learn how to generate random numbers.
- Practice using the random number generation for different distributions (Uniform, Normal, Discrete and more.
- Learn how to apply simulations.
Faculty - Dr.Isaac Gottlieb
For more than 25 years Dr. Isaac Gottlieb has been teaching Excel workshops for MBA students in a number of universities, including, Columbia, NYU, Rutgers and others in the US and other countries. In addition, he taught courses of Management Science and Statistics for Managers (always) using Excel. Over 100,000 students have attended his workshops and courses over the past 25 years.
He received the Microsoft MVP – Most Valuable Professional – award for the years 2014-6. “A Microsoft Most Valuable Professional (MVP) is an award for individuals who have exhibited exceptional technical expertise and a talent for sharing knowledge within their technical community.” (From Microsoft’s site.)
Isaac Gottlieb has taught how to use Excel—and how to apply it effectively to various business disciplines—to thousands corporate professionals from leading multinational companies as well as small private business corporations. Among them are Johnson & Johnson, Merck, Pfizer, Procter & Gamble, Caterpillar, Vornado, El-Al Airlines, Microsoft, Intel, Boeing, NCR, Chrysler, Sealed Air, JPMorgan, Morgan Stanley, 3M, H-P, and the New York City Economic Development Corporation.