Course title: Familiarization with ModelRisk Standard

Duration: 2 days

Course overview

This course provides an in-depth review of the tools and functions of the Standard version of Vose Software’s ModelRisk risk analysis add-in to Excel.

Who should attend

Users of the Standard version of ModelRisk who wish to get the most from the software.

Course content

Day 1

• The ModelRisk ribbon / toolbar
• Inserting a distribution into Excel
• Choosing the right distribution
• Shifting and truncating distributions
• Alternative parameterization of distributions
• Naming inputs and outputs
• Deleting inputs and outputs
• Input and output arrays
• How ModelRisk warns of invalid parameters
• The View Function tool
• The Find tool
• Running a simulation and reviewing the results
• Example exercises

Day 2

• The ModelRisk Results window in detail
• Performing and interpreting sensitivity analysis
• Customizing graphical simulation results
• Exporting graphical results to other documents
• Saving simulation results and sharing with non-ModelRisk users
• Correlating random variables (bivariate and multivariate copulas)
• Running multiple simulations
• Using VBA macros with simulation runs
• Simulation reporting functions (VoseSimMean, VoseSimCofV, etc)
• Special functions: VoseParameters, VoseDescription, VoseCurrentSample, VoseCurrentSim
• More example exercises
• Wrap up

Training material

All lecture notes are provided as PowerPoint files. A CD of these files is provided to each participant. Printed handouts are also provided. The CD also contains all model files produced for the course. Any extra models developed during the course are downloadable from a private page on this web site dedicated to the course.

Prerequisites

It is essential that all participants are familiar with Microsoft Excel and Microsoft Windows.

Teaching philosophy

All of Vose Software's courses aim to help the participants understand (rather than 'learn') risk analysis, which can only be achieved through a relaxed, informal and interactive environment, through plenty of examples and hands-on exercises where participants apply and adapt what they have learned.

Contact us

If you are interested in this course, feel free to fill in the contact form and one of our staff members will get in touch with you within 2 business days!