|
Gain the skills necessary to make you a more confident, efficient, and
professional decision-maker.
This practical, two-day software training course is just what you need to learn spreadsheet risk analysis with Crystal Ball Professional Edition.
Day one will begin by teaching you the basics of Monte Carlo simulation, tornado analysis, how to develop Crystal Ball models, how to gain insights from simulation results, and the best ways to present your findings to peers, management, or clients.
Day two will show you how to develop advanced Crystal Ball models through the entire analytical toolset of Crystal Ball Professional Edition. Extend your understanding of Crystal Ball to include optimization, time-series forecasting and more. The first part of the day is focused on how to make optimal decisions using Crystal Ball and OptQuest, and the remainder covers time-series forecasting, advanced assumptions, forecast options, precision controls, and model building tips and tricks.
 We have designed the pace and material of this course for a general audience, with example models and exercises that cover a wide variety of applications in finance, engineering, project management, and more. Attendees receive manuals, sample exercises, and resource materials.
"Lots of examples and 'hands-on' training."
-- Mary Lee Rigamonti, Financial Analyst, Kinetic Concepts, Inc. |
Day one of this course will:
- Teach you the basic skills required to make the most of Crystal Ball
- Show you how to communicate the concept of risk to others
- Give you a better understanding of the benefits of spreadsheet risk analysis
- Dramatically shorten the software learning curve
- Provide you with handy tips, shortcuts, and modeling techniques
- Allow you to meet and network with other professionals
- Help you bring the necessary risk and decision analysis techniques back to your organization
Day two of this course will:
- Teach you the tools of Crystal Ball Professional
- Help you to make optimal decisions despite uncertain conditions
- Show you how to communicate the concept of risk to others
- Extend your ability to build and analyze spreadsheet risk models
- Provide you with handy tips, shortcuts, and modeling techniques
- Allow you to meet and network with other professionals
- Help you bring the necessary risk and decision analysis techniques back to your organization
Continuing Professional Education (CPE) Credit |
Introductory & Advanced Crystal Ball is a group live software training course worth sixteen CPE credit hours (a credit hour is 50 minutes of training per hour). Decisioneering, Inc. is registered with the National Association of State Boards of Accountancy (NASBA) as a sponsor of continuing professional education on the National Registry of CPE Sponsors.
Program Level: Introductory & Advanced Crystal Ball - Overview
State boards of accountancy have final authority on the acceptance of individual courses for CPE credit. Complaints regarding registered sponsors may be addressed to the National Registry of CPE Sponsors, 150 Fourth Avenue North, Suite 700, Nashville, TN, 37219-2417.
www.nasba.org
> Click here for more information on our CPE Credits
Advanced preparation includes:
- An introductory understanding of Excel
- Competence with Windows operating systems (NT 4.0 or later).
The US / Canada course fee is $1490. Courses outside North America must be ordered through our UK and Germany offices and are subject to local VAT. The course fee includes lunch and coffee breaks, handouts, manuals, and CDs with example files. You must pay the course fee prior to attending the course.
> Click here for general course policies (includes refund and cancellation information)
Register for a class today!
Standard Agenda - Day One |
Time: 8:30 a.m. to 4:30 p.m. (Actual start times vary by location. Please check your confirmation letter for actual start time) Lunch provided by Decisioneering.
Morning
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
Lunch (provided by Decisioneering)
Afternoon
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
Class Exercises
Standard Agenda - Day Two |
Time: 8:30 a.m. to 4:30 p.m. (Actual start times vary by location. Please check your confirmation letter for actual start time) Lunch provided by Decisioneering.
Morning
Advanced Assumption Options
- Using alternate parameters
- Using a formula as a parameter
- Truncating assumption distributions
- Using a function as a distribution
- Customizing the distribution gallery
- Publishing and subscribing to distributions
Advanced Forecast Options
- Fit a distribution to a forecast
- Forecast filtering
- Auto extract forecast data
- Adding marker lines to forecast statistics
Advanced Simulation Control
- Precision control
- User defined macros
- 2D simulation
- Bootstrapping
Lunch (provided by Decisioneering)
Afternoon
OptQuest
- What is optimization?
- How OptQuest works
- Optimization applications
- Running OptQuest
- OptQuest results
- Efficient frontier
Predictor
- Time series forecasting
- Linear regression
A Taste of Real Options
Class Exercises |
> Order training online today!
