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
Strategies For Job Seekers: Best Practices For A Strategic …
By:Dr. B. Lynn Ware
Oct. 20, 2025
12:00 PM PDT | 03:00 PM EDT
Dealing With Difficult People: At Work & In Life
By:Paul J. Cline
Oct. 20, 2025
10:00 AM PDT | 01:00 PM EDT
I-9 Audits: Strengthening Your Immigration Compliance Strat…
By:Diane L. Dee
Oct. 20, 2025
10:00 AM PDT | 01:00 PM EDT
Maximizing Productivity with ChatGPT: AI Solutions for HR, …
By:Erica Chisolm & Vanessa Hardiman
Oct. 20, 2025
12:00 PM PDT | 03:00 PM EDT
The Perfect Storm Coming to Healthcare: Value Based Care Me…
By:Dr. Bill Trombetta
Oct. 21, 2025
10:00 AM PDT | 01:00 PM EDT
Excel - Reporting Simplified - Learn Pivot Tables from Scra…
By:Mike Thomas
Oct. 21, 2025
10:00 AM PDT | 01:00 PM EDT
Turning Workplace Conflict into Positive Connection
By:Dannette Hoenisch
Oct. 22, 2025
10:00 AM PDT | 01:00 PM EDT
Retention Starts Here: Stop Losing Your Critical Talent and…
By:Marcia Zidle
Oct. 22, 2025
10:00 AM PDT | 01:00 PM EDT
Project Management for Non-Project Managers - How to commun…
By: Charles H. Paul
Oct. 22, 2025
12:00 PM PDT | 03:00 PM EDT
The Business Case for LGBTQIA+ Inclusion in the Workplace: …
By:Dr. Susan Strauss
Oct. 23, 2025
10:00 AM PDT | 01:00 PM EDT
AI and Human Resources: The Great Opportunity!
By:Don Phin
Oct. 23, 2025
10:00 AM PDT | 01:00 PM EDT
Conquer Toxic People - Learn To Protect Yourself And Get Yo…
By:Michael Healey
Oct. 24, 2025
10:00 AM PDT | 01:00 PM EDT
AI-Powered Change Leadership Operationalizing AI: Practical…
By:Nancy Amert
Oct. 24, 2025
12:00 PM PDT | 03:00 PM EDT
Cyber Security Incident Response Team Training Program
By:Ms. Michael Redmond
Oct. 28, 2025
10:00 AM PDT | 01:00 PM EDT
Excel Power Skills: Master Functions, Formulas, and Macros …
By:Cathy Horwitz
Oct. 29, 2025
10:00 AM PDT | 01:00 PM EDT
Transforming Anger And Conflict Into Collaborative Problem …
By:Mark Gorkin
Oct. 29, 2025
10:00 AM PDT | 01:00 PM EDT
The Courage to Speak: Overcoming Fear and Owning the Room
By:Terry Winship
Oct. 30, 2025
10:00 AM PDT | 01:00 PM EDT
6-Hour Virtual Seminar on Learning the Highlights of Excel …
By:Cathy Horwitz
Oct. 31, 2025
12:00 PM PDT | 03:00 PM EDT
Finance & Accounting 101 Simplified
By:Richard E Cascarino
Oct. 31, 2025
10:00 AM PDT | 01:00 PM EDT
6-Hour Virtual Boot Camp on Microsoft Power BI
By:Jackie Kiadii
Oct. 31, 2025
10:00 AM PDT | 01:00 PM EDT
Developing an Agile Workforce with Emotional Intelligence (…
By:Dr. B. Lynn Ware
Nov. 3, 2025
12:00 PM PDT | 03:00 PM EDT
Compliance Under Fire: Navigating I9 Immigration Raids & …
By:Diane L. Dee
Nov. 3, 2025
10:00 AM PDT | 01:00 PM EDT
FDA Regulation of Artificial Intelligence/ Machine Learning
By:Edwin Waldbusser
Nov. 3, 2025
10:00 AM PDT | 01:00 PM EDT
Empowering Conflict Resolution: Letting Go to Gain Control
By:Aimee Bernstein
Nov. 3, 2025
10:00 AM PDT | 01:00 PM EDT
Human Error Reduction Techniques for Floor Supervisors
By:Ginette M. Collazo
Nov. 4, 2025
10:00 AM PDT | 01:00 PM EDT
How to Give Corrective Feedback: The C.A.R.E. Model - Elimi…
By:Bruce Lee
Nov. 4, 2025
10:00 AM PDT | 01:00 PM EDT
Secrets Of Psychology - Why People Do The Things They Do
By:Paul J. Cline
Nov. 5, 2025
10:00 AM PDT | 01:00 PM EDT
How To Conduct An Internal Harassment And Bullying Investig…
By:Dr. Susan Strauss
Nov. 5, 2025
10:00 AM PDT | 01:00 PM EDT
Leadership: Strategic Planning and Decision Making
By:Rebecca Staton-Reinstein
Nov. 5, 2025
10:00 AM PDT | 01:00 PM EDT
Marketing to Medicare or Medicaid Beneficiaries - What You …
By: William Mack Copeland
Nov. 6, 2025
12:00 PM PDT | 03:00 PM EDT
Polish your Presence on Linkedin - The Powerful Profile
By:Hulya Kurt
Nov. 6, 2025
10:00 AM PDT | 01:00 PM EDT
Utilizing A Proven Process When Conducting Sensitive, Inter…
By:Pete Tosh
Nov. 7, 2025
10:00 AM PDT | 01:00 PM EDT
Bootcamp for New Managers and Supervisors: Develop These Es…
By:Marcia Zidle
Nov. 7, 2025
10:00 AM PDT | 01:00 PM EDT
Leveraging Artificial Intelligence in HR
By:Erica Chisolm & Vanessa Hardiman
Nov. 7, 2025
12:00 PM PDT | 03:00 PM EDT