Creating Simulations in Excel: Basic (CBT and Live Workshop)
Simulations have been shown to measurably improve estimates, but many decision models currently lack this critical element. Learn how to create simulations in native Microsoft Excel that can lead to better decisions in any field. This course includes self-paced Computer-Based Training (CBT) with online review questions as well as a live workshop. Participants will be given useful spreadsheet templates to apply to practical hands-on coursework.
To sign up, simply select a date in the drop-down menu for the 90-minute Live Workshop below and add to cart. Then, fill out your order information when you go to check out.
You will receive the information to begin the CBT module one week prior to the 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.
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 webinar 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.
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 1 week prior to the Live Workshop webinar date containing the information to access a personalized Computer Based Training module and an Excel file. Just click on the link to enter the HDR website to begin your training.
Participants will receive another email one day before the scheduled Live Workshop with a Webex invite for that Workshop.
Following the presentation, each participant will receive another email with a recording link to the presentation.
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.
To continue to shop click here.
|Live Creating Simulations in Excel: Basic Webinar Dates (Please complete CBT prior to live webinar)||
Wednesday, July 15 7:00 pm – 8:30 pm CDT (UTC-5), Tuesday, August 11 9:00 am – 10:30 am CDT (UTC-5), Thursday, September 10 1:00 pm – 2:30 pm CDT (UTC-5)