The Monte Carlo Simulations in Excel for Risky Investments
Duration: 60 Minutes
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.
- Random numbers generation.
- Rolling Dice using Excel.
- Simulation risk profiles of long-term capital investments.
- Practice problems and solutions.
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.
- Finance
- Statistics
- Risk managers
For more than 25 years Dr. Isaac Gottlieb has been teaching Excel workshops for MBA students in a number of universities, including, Columbia, NYU 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.
He mails Excel-Tip-Of-The-Month to over 35,000 recipients.
Dr. Gottlieb has earned his PhD and two Masters Degrees from Columbia University Department of Industrial Engineering and Operations Research.
His two recent books are:
Excel 2022 Pro 100 + PivotTables, Charts & Reports: Explore Excel 2022 with Graphs, Animations, Sparklines, Goal Seek, Histograms, Correlations, Dashboards. Nov 2022.
Management Science using Excel: Harnessing Excel's advanced features for business optimization. Aug 2023.
Upcoming Webinars
By Beverly Beuermann-King
Date: March 10, 2025
By Brenda Neckvatal
Date: March 11, 2025
By Bruce Lee
Date: March 11, 2025
By Catherine M. Rymsha
Date: March 11, 2025
By Edwin Waldbusser
Date: March 11, 2025
By Justin Muscolino
Date: March 12, 2025
By Charles H. Paul
Date: March 12, 2025
By Rachelle D Souza
Date: March 12, 2025
By Bob Oberstein
Date: March 13, 2025
By Cathy Horwitz
Date: March 13, 2025
By Marcia Zidle
Date: March 13, 2025
By Gary Heppner
Date: March 14, 2025
By Jonnie Keith
Date: March 14, 2025
By Jackie Kiadii
Date: March 17, 2025
By Paul J. Cline
Date: March 17, 2025
By David Nettleton
Date: March 18, 2025
By Margie Faulk
Date: March 18, 2025
By Edlyn McGarity
Date: March 18, 2025
By Bruce Lee
Date: March 18, 2025
By Melveen Stevenson
Date: March 19, 2025
By Susan Fahey Desmond
Date: March 19, 2025
By Rebecca Farabaugh
Date: March 19, 2025
By Dr. Susan Strauss
Date: March 20, 2025
By Carolyn Troiano
Date: March 20, 2025
By Nancy Amert
Date: March 20, 2025
By Meredith Crabtree
Date: March 21, 2025
By Pete Tosh
Date: March 21, 2025
By Edwin Waldbusser
Date: March 21, 2025
By Diane L. Dee
Date: March 24, 2025
By Meredith Crabtree
Recorded Session
By Bob Verchota
Recorded Session
By Margie Faulk
Recorded Session
By Diane L. Dee
Recorded Session
By Dr. Susan Strauss
Recorded Session
By Dr. Susan Strauss
Recorded Session
By Cathy Horwitz
Recorded Session
By Marcia Zidle
Recorded Session
By Mike Thomas
Recorded Session
By Mark Gorkin
Recorded Session
By Edwin Waldbusser
Recorded Session
By Charles H. Paul
Recorded Session
By Deb Schaffer
Recorded Session
By David Nettleton
Recorded Session
By Justin Muscolino
Recorded Session
By Charles H. Paul
Recorded Session
By Marcia Zidle
Recorded Session
By Richard E Cascarino
Recorded Session
By Dr. Susan Strauss
Recorded Session
By Edwin Waldbusser
Recorded Session
By William J. Rothwell
Recorded Session
By Dr. Susan Strauss
Recorded Session
By Pete Tosh
Recorded Session
By Meredith Crabtree
Recorded Session
By Beverly Beuermann-King
Recorded Session
By David Nettleton
Recorded Session
By Melveen Stevenson
Recorded Session
By Mark Gorkin
Recorded Session
By Bob McKenzie
Recorded Session
