Name: Introduction to Crystal Ball
Course Code: ORHY70226
Duration: 1
Scheduled Dates for ORHY70226
This one-day course deals with the spreadsheet risk analysis using Crystal Ball Standard Edition. This course equips the participants with the basics of Monte Carlo simulation, tornado analysis, and steps to develop Crystal Ball models. Participants can learn to gain insights from simulation results and the best ways to present the findings to peers, management, or clients.
This course covers general audience with lot of example models and exercises that cover a wide variety of applications in finance, engineering, project management, and more. It also acts as an excellent refresher course and helps the participants to learn about the latest analytical tools and features.
Learn To:
- Acquire basic skills required to use Crystal Ball
- Communicate the concepts of risk to others
- Understand the benefits of spreadsheet risk analysis
- Use the necessary risk and decision analysis techniques at your organization
Target Audience
End Users
Key Topics
- Introduction to Monte Carlo simulation
- - What it is and how it works
- - Steps in model development
- - Current environment of spreadsheets
- - Deterministic modeling vs. Stochastic modeling
- Probability Distributions and Statistics
- - Basic Distributions
- - Basic Statistics
- Getting Started with Crystal Ball
- - Launching Crystal Ball
- - Terminology
- - Navigation
- Setting up a Simulation Model
- - Defining Assumptions
- - Correlating Assumptions
- - Defining Forecasts
- - Editing Crystal Ball data
- - Correlation analysis
- Analysis and Presentation of Results
- - Sensitivity Chart
- - Overlay Chart
- - Trend Chart
- - Report Generation
- - Saving Results
- Simulation Control
- - Trials
- - Sampling
- - Speed
- - Options
- - Statistics
- Basic Crystal Ball Tools
- - Tornado Charts
- - Batch Fit
- - Correlation Matrix
Objectives
- Understand about spreadsheet risk analysis and its benefits
- Learn basic skills required to use Crystal Ball and its features
- Use the appropriate risk and decision analysis techniques at you organization
Required Skills/Experience
- An introductory understanding of Excel
- Competence with Windows operating systems
Fee: $750.00
Course Schedule:
Back to Course Description
Austin
Charlotte
Columbia
Hunt Valley
Lansing
Madison
Milwaukee
Minneapolis
Oak Brook
Oklahoma City
Phoenix
Raleigh
San Antonio
Schaumburg
Tulsa
Washington DC
