Creating Simulations in Excel Training Package: Basic + Intermediate (CBT and Live Workshops)

$595.00

Simulations have been shown to measurably improve estimates, but many decision models currently lack this critical element. Learn how to build and improve on basic simulations in native Microsoft Excel that can lead to better decisions in any field with this two-part package consisting of Basic Simulations in Excel and Intermediate Simulations in Excel.

How to Sign Up:

  1. Select a date in the drop-down menu for the 90-minute Live Workshop below and add to cart for Basic and Intermediate. Then, fill out your order information when you go to check out.
  2. You will receive a link to begin the CBT module one week prior to the respective live workshop. Please have worked through the module (takes approximately 1.5 hours) before your Live Workshop.  If you can’t attend part or all of the live workshop, you will be given a recording of the workshop as well as an opportunity to attend a future workshop for this course instead.
Clear
SKU: N/A Categories: ,

What's the chance that a project will lose money or be cancelled? What's the most likely return on investment for a given investment? How likely is a particular risk or set of risks to happen - and how severe could their impacts be?

Running simulations has been shown to measurably improve estimates in uncertain decisions, but how can you run a simulation without complicated software requiring advanced training?

This package consists of two webinars: Creating Simulations in Excel: Basic and Creating Simulations in Excel: Intermediate

Creating Simulations in Excel: Basic teaches participants how to build a powerful tool - a Monte Carlo simulation that calculates thousands of scenarios - using only Microsoft Excel, with no additional training or software required.  Not even coding in Visual Basic for Excel, user-defined functions or new Excel add-ons are needed. We only need native Excel using features that are already installed.

You'll learn how to use these features to:

  • learn the advantages of using a MC simulation;

  • represent uncertainty for a wide variety of variables using existing functions in Excel;

  • use a flexible new pseudo-random number generator (PRNG) that generates large sets of random numbers for better auditable flexibility and standardization than current methods;

  • use key features of Excel to run thousands of scenarios in a streamlined and compact manner; and

  • chart the output of the simulation in useful graphs to provide actionable insight for decision-makers.

Participants will also gain access to Excel templates that contain probability distributions, the PRNG, and other pre-built tools to get you started.

After attending Creating Simulations in Excel: Basic, you’ll have the ability to create an Excel simulation to help you answer critical questions like the ones above - and more.

The next course, Creating Simulations in Excel: Intermediate, will continue the discussion with some intermediate topics that will improve the performance and versatility of your decision models. Using only features of native Excel, you will learn how to:

  • Use more advanced probability distributions, such as the lognormal, beta, and power law distributions.
  • Compute information value when you have a model with several variables.
  • Adjust your cash flows based on a stated risk tolerance.

Participants will also gain access to Excel templates that expand upon the templates from the previous course with additional features.

After attending Creating Simulations in Excel: Intermediate, you’ll have the ability to build an improve upon an Excel simulation to help you answer the critical questions every successful decision requires.

Why You Need Simulations In Your Decision Models

What keeps every decision from being a great one is the fact that for every decision, there exists a range of uncertain future results, some of which will be a quantified loss. To calculate risk, we need a way to calculate thousands of the possible scenarios and outcomes that could happen to find out which are most likely.

Enter the Monte Carlo simulation. Born out of the Manhattan Project, the Monte Carlo simulation uses randomly-calculated values to run thousands of scenarios and calculate the most likely outcomes. Studies have shown how the use of a Monte Carlo simulation tool can measurably improve forecasts in everything from NASA unmanned space probe mission risk to the financial performance of oil exploration firms.

Simply put, the the Monte Carlo simulation is one of the best quantitative analysis tools we have available - and adopting it to make better decisions is one of the best decisions one can make.

Scheduling and Deliverables

CBT Modules: Each participant will receive an email with the information to complete the CBT format modules.

Please note: All CBT modules are delivered via LearnDash in a hubbardresearch.com User account. You'll be given an option to create a User account upon check out by clicking the box. If you do not create an account at that time (or do not already have one), one will be created for you. You'll be sent the Username and Login.

Live Workshops: Separate emails will be sent 1 day prior to each live session containing the Webex invite. Just click on the link to join the Webex on the scheduled day.

Following any live workshop, each participant will receive another email with:

    1. A recording link to the live presentations
    2. Continued access to the self-paced online training
    3. The slide deck used in the presentation
    4. Any spreadsheet tools used in the training

Schedule a Private Webinar for Your Organization

We offer private webinar sessions for an organization with special discounted group rates. Contact us for more information and to schedule your next training session.








Additional information

Creating Simulations in Excel: Basic

1.5 hours CBT and Wednesday, July 15 7:00 pm – 8:30 pm CDT (UTC-5) Live Workshop, 1.5 hours CBT and Tuesday, August 11 9:00 am – 10:30 am CDT (UTC-5) Live Workshop, 1.5 hours CBT and Thursday, September 10 1:00 pm – 2:30 pm CDT (UTC-5) Live Workshop

Creating Simulations in Excel: Intermediate

1.5 hours CBT and Wednesday, July 29 7:00 pm – 8:30 pm CDT (UTC-5), 1.5 hours CBT and Wednesday, August 26 9:00 am – 10:30 am CDT (UTC-5), 1.5 hours CBT and Thursday, September 24 1:00 pm – 2:30 pm CDT (UTC-5)

What’s the chance that a project will lose money or be cancelled? What’s the most likely return on investment for a given investment? How likely is a particular risk or set of risks to happen – and how severe could their impacts be?

Running simulations has been shown to measurably improve estimates in uncertain decisions, but how can you run a simulation without complicated software requiring advanced training?

This package consists of two webinars: Basic Simulations in Excel and Intermediate Simulations in Excel.

Basic Simulations in Excel teaches participants how to build a powerful tool – a Monte Carlo simulation that calculates thousands of scenarios – using only Microsoft Excel, with no additional training or software required.  Not even coding in Visual Basic for Excel, user-defined functions or new Excel add-ons are needed. We only need native Excel using features that are already installed.

You’ll learn how to use these features to:

  • learn the advantages of using a MC simulation;

  • represent uncertainty for a wide variety of variables using existing functions in Excel;

  • use a flexible new pseudo-random number generator (PRNG) that generates large sets of random numbers for better auditable flexibility and standardization than current methods;

  • use key features of Excel to run thousands of scenarios in a streamlined and compact manner; and

  • chart the output of the simulation in useful graphs to provide actionable insight for decision-makers.

Participants will also gain access to Excel templates that contain probability distributions, the PRNG, and other pre-built tools to get you started.

After attending Basic Simulations in Excel, you’ll have the ability to create an Excel simulation to help you answer critical questions like the ones above – and more.

The next course, Intermediate Simulations in Excel, will continue the discussion with some intermediate topics that will improve the performance and versatility of your decision models. Using only features of native Excel, you will learn how to:

  • Use more advanced probability distributions, such as the lognormal, beta, and power law distributions.
  • Compute information value when you have a model with several variables.
  • Adjust your cash flows based on a stated risk tolerance.

Participants will also gain access to Excel templates that expand upon the templates from the previous course with additional features.

After attending Basic and Intermediate Simulations in Excel, you’ll have the ability to build an improve upon an Excel simulation to help you answer the critical questions every successful decision requires.

Why You Need Simulations In Your Decision Models

What keeps every decision from being a great one is the fact that for every decision, there exists a range of uncertain future results, some of which will be a quantified loss. To calculate risk, we need a way to calculate thousands of the possible scenarios and outcomes that could happen to find out which are most likely.

Enter the Monte Carlo simulation. Born out of the Manhattan Project, the Monte Carlo simulation uses randomly-calculated values to run thousands of scenarios and calculate the most likely outcomes. Studies have shown how the use of a Monte Carlo simulation tool can measurably improve forecasts in everything from NASA unmanned space probe mission risk to the financial performance of oil exploration firms.

Simply put, the the Monte Carlo simulation is one of the best quantitative analysis tools we have available – and adopting it to make better decisions is one of the best decisions one can make.

Scheduling and Deliverables

Each participant will receive an email with a link to the Webex approximately 1-2 days before the live session. No pre-registration is required; simply click on the link at the appropriate time to join the session.

Following the session, each participant will receive:

  1. A recording of the presentation
  2. The slide deck used in the presentation
  3. Excel templates for the concepts covered in the training

Schedule a Private Webinar for Your Organization

We offer private webinar sessions for an organization with special discounted group rates. Contact us for more information and to schedule your next training session.

Keep Shopping

To continue to shop click here.

 

Billing details

Additional information

Your order

Product
Quantity
Total
Cart Subtotal $0.00
Order Total $0.00
  • Pay via PayPal; you can pay with your credit card if you don’t have a PayPal account.

Your personal data will be used to process your order, support your experience throughout this website, and for other purposes described in our privacy policy.

Subscribe To Our Newsletter

Subscribe to get the latest news, insights, courses, discounts, downloads, and more - all delivered straight to your inbox. 

You are now subscribed to Hubbard Decision Research.