The Monte Carlo Simulations in Excel for Risky Investments
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.
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.
LEARNING OBJECTIVES
- Random numbers generation.
- Rolling Dice using Excel.
- Simulation risk profiles of long-term capital investments.
- Practice problems and solutions.
WHO WILL BENEFIT?
- Finance
- Statistics
- Risk managers
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.
- Random numbers generation.
- Rolling Dice using Excel.
- Simulation risk profiles of long-term capital investments.
- Practice problems and solutions.
- Finance
- Statistics
- Risk managers
Speaker Profile
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 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 …
Upcoming Webinars
Power BI - Getting Started Building Reports and Dashboards
By:Mike Thomas
Sept. 16, 2025
10:00 AM PDT | 01:00 PM EDT
Leverage AI & ChatGPT for Talent Acquisition: Best Practice…
By:Marcia Zidle
Sept. 17, 2025
12:00 PM PDT | 03:00 PM EDT
Gossip-Free: Leadership Techniques to Quell Office Chatter
By:Beverly Beuermann-King
Sept. 17, 2025
10:00 AM PDT | 01:00 PM EDT
Female to Female Hostility @Workplace: All you Need to Know
By:Dr. Susan Strauss
Sept. 18, 2025
10:00 AM PDT | 01:00 PM EDT
Harassment, Bullying, Gossip, Confrontational and Disruptiv…
By:Bruce Lee
Sept. 19, 2025
10:00 AM PDT | 01:00 PM EDT
Leadership: Strategic Planning and Decision Making
By:Rebecca Staton-Reinstein
Sept. 22, 2025
12:00 PM PDT | 03:00 PM EDT
4-Hour Virtual Seminar on Transformational Leadership - The…
By:Paul J. Cline
Sept. 23, 2025
10:00 AM PDT | 01:00 PM EDT
Workplace Investigations 101: How to Conduct your Investiga…
By:Dr. Susan Strauss
Sept. 24, 2025
12:00 PM PDT | 03:00 PM EDT
Copilot and HR: An Introduction for HR Professionals
By:Deb Schaffer
Sept. 24, 2025
12:00 PM PDT | 03:00 PM EDT
Managing Toxic Employees: Strategies For Leaders To Effecti…
By:Beverly Beuermann-King
Sept. 24, 2025
12:00 PM PDT | 03:00 PM EDT
Negotiating Skills For Professional Results - Winning Strat…
By:Bruce Lee
Sept. 24, 2025
10:00 AM PDT | 01:00 PM EDT
Managing Complex Projects - Project Management
By:Audrey Halpern
Sept. 24, 2025
10:00 AM PDT | 01:00 PM EDT
2-Hour Virtual Seminar on the 6 Most Common Problems in FDA…
By:David Nettleton
Sept. 24, 2025
10:00 AM PDT | 01:00 PM EDT
Ultimate Persuasion Strategies! - Secret Influence Tools & …
By:Paul J. Cline
Sept. 25, 2025
10:00 AM PDT | 01:00 PM EDT
Excel Power Skills: Master Functions, Formulas, and Macros …
By:Cathy Horwitz
Sept. 25, 2025
12:00 PM PDT | 03:00 PM EDT
Utilizing HR Metrics to Illustrate & Improve Human Resource…
By:Pete Tosh
Sept. 29, 2025
12:00 PM PDT | 03:00 PM EDT
Using High-Performance Coaching for Managers to Address Per…
By:William J. Rothwell
Sept. 29, 2025
10:00 AM PDT | 01:00 PM EDT
Do's and Don'ts of Giving Effective Feedback for Performanc…
By:Audrey Halpern
Sept. 29, 2025
12:00 PM PDT | 03:00 PM EDT
2-Hour Virtual Seminar on How to Conduct an Internal Harass…
By:Dr. Susan Strauss
Sept. 29, 2025
10:00 AM PDT | 01:00 PM EDT
Excel - Pivot Tables - The Key To Modern Data Analysis and …
By:Mike Thomas
Sept. 29, 2025
10:00 AM PDT | 01:00 PM EDT
Do's and Don'ts of Documenting Employee Behaviour, Performa…
By:Diane L. Dee
Sept. 30, 2025
10:00 AM PDT | 01:00 PM EDT
Understanding Artificial Intelligence (AI) & using Chat GPT
By:Justin Muscolino
Sept. 30, 2025
12:00 PM PDT | 03:00 PM EDT
The Importance of the first 5 seconds when presenting
By:Terry Winship
Oct. 7, 2025
12:00 PM PDT | 03:00 PM EDT
Project Management for administrative professionals
By:Rebecca Staton-Reinstein
Oct. 7, 2025
12:00 PM PDT | 03:00 PM EDT
Employee Handbooks: 2025 Critical Issues
By:Ronald L. Adler
Oct. 15, 2025
10:00 AM PDT | 01:00 PM EDT