Course Description:
This course introduces the tools and techniques you need to start building basic Monte Carlo simulations in native Excel, without any Visual Basic or special add-ins. If you have not yet purchased or enrolled in this course, please click here.
HOW TO GET STARTED:
Scroll down to see the course syllabus and information about your instructor. At the bottom of this page is the list of online modules for this course. Click on the name of the first module to get started, or simply press the “Start Course” button below. Required and optional materials can be downloaded from the “Materials” tab above. Please download the Basic Sims in Excel spreadsheet and follow along with the examples in the videos. Further instructions are included in the introduction video in the first module.
Course Syllabus
Objective
Learn how to build Monte Carlo simulations in Excel, utilizing probability distributions and pseudo-random number generators.
Prerequisites
None
Format
- CBT Modules: 4 (approx. 1 to 3 hr)
- Quizzes/assignments: 4/1
Materials Provided
Basic Sims in Excel worksheet (see Materials tab above)
Recommended Next Courses
Intermediate Simulations, Decisions Under Uncertainty, Statistical Measurement Methods: Basic
Jonathan Murphy is the Director of Product Management for Hubbard Decision Research (HDR). Under this role, Jonathan has become a skilled practitioner of Applied Information Economics, with expertise in applying methods such as Monte Carlo simulation, Bayesian analysis, modern portfolio theory, and many others. He has utilized his knowledge of applied mathematics, probability, and economics to solve a variety of decision and measurement problems for more than a dozen clients.
If you have questions about the course, please feel free to contact your instructor at jmurphy@hubbardresearch.com.
About the Office Hours
Use the form on the right to sign up for office hours. Upon submitting the form, you will receive a confirmation email and a calendar invitation.
- This time is reserved for students to come and ask questions about the course or related content and to interact with a live instructor.
- There are no prerequisites for attending this session besides being enrolled in the course.
- You can book multiple sessions while you are actively enrolled in the course, but please no more than one per week per course.
Note: This service is provided to supplement your online course material; it is not intended to replace any of the recorded content or review quizzes.
Need help? Have questions about the course or related content? Join your instructor for one-on-one office hours!
Please download the following spreadsheet to follow along in the course examples and to answer review questions.
Basic Sims in Excel (Participant version).xlsx
This is a paper written by Doug Hubbard about the pseudo random number generator we use. It is not required for the course but is provided for your reference.