Welcome to ONLC Training Centers


Excel Forecasting and What-If Analysis Course Outline

 (1 day)
Version 2016

Overview
Excel has many built-in features and add-ons that will make it easier to develop complex models that incorporate What-If Analysis (using either Scenarios, Solver, or Data Tables). In addition, forecasts and trend lines can be easily projected and customized using Excel’s Forecast functions. Finally, the Excel Data Model is reviewed. This advanced feature allow you to access huge data sets within Excel.

Target Student
The course is for individuals who are responsible for creating forecasts and doing what-if analysis with Excel.

Special Note to New Hampshire Residents
This course has not yet been approved by the State's Department of Education. Please contact us to get an update as to when the class should be available in New Hampshire.

Prerequisites
Introduction to Excel class or equivalent skills and a general understanding of the issues related to forecasting and what-if analysis.

*** Version Note ***
While this class is being taught using the 2016 version of the Excel software, almost all topics will be applicable to users of Excel 2013. As a result, this class will be beneficial to users of either Excel 2016 or Excel 2013.

Course Outline

Using the Quick Analysis Tool
Formatting
Charts
Tables
Sparklines

One-Click Forecasting
Using Exponential Smoothing for Forecasting
Trendlines
Seasonality Patterns
Confidence Intervals

Customizing Your Forecast
Forecast Start
Confidence Interval
Seasonality Patterns
Timeline Range
Values Range
Missing Points

Forecasting Functions
Exponential Smoothing
Seasonality
Predicting with Linear Forecast
Using the Confidence Interval Function
Using the Statistics Function to get statistics related to the Forecast

Introduction to What-If Analysis
Overview

What-If Using Scenarios
Creating Scenarios
Changing Cells and the Result Cell
Scenario Manager
Consider Different Variables
Merging Scenarios
Scenario Summary Reports

What-If Using Data Tables
Overview
One-variable Data Tables
Two-Variable Data Tables
Data Table Calculations
Prepare Forecasts and Advanced Business Models

What-If Using Goal Seek
Goal Seek to get to a Desired Result
Set Cell
To Value
By Changing Cell
Goal Seek vs Solver

Solver
Define and Solve a Problem Using Solver
Example of a Solver Evaluation
Define and Solve a Problem
Step through Solver Trial Solutions
Change How Solver Finds Solutions
Save or Load a Problem Model
Solving Methods used by Solver

Solver Examples
Solver for Capital Budgeting
Solver for Financial Planning
Solver to determine Optimal Product Mix
Perform What-If Analysis with the Solver Tool

Large Files and the Excel Data Model
What is the Data Model
Getting External Data
Create and Use Linked Tables
Add existing, unrelated data to a Data Model

Demonstration of Power Pivot

View outline in Word

WEXF16

Attend hands-on, instructor-led Excel Forecasting and What-If Analysis training classes at ONLC's more than 300 locations. Not near one of our locations? Attend these same live classes from your home/office PC via our Remote Classroom Instruction (RCI) technology.

For additional training options, check out our list of Courses and select the one that's right for you.

Microsoft Gold Partner
Class Dates
(click date for class times)
(click Enroll for locations)

Fee:  $395

Savings options:

 CEA Apps Saver
 Office 5 for 4
Need a price quote?

Follow the link to our self-service price quote form to generate an email with a price quote.

Email Alert

Receive an email when this class is available as "Ready to Run" or "Early Notice" status.

Attend from your office or home

If you have high-speed internet and two computers you can likely take this class from your office or home.

Need a class for a group?

We can deliver this class for a private group at your location. Follow the link to request more information.

Attend computer classes from ONLC Training Centers Request a copy via mail

GENERAL INFO

Class Format
Class Policies
Student Reviews

Bookmark and Share


HAVE QUESTIONS?
First Name

Last Name

Company

Phone

Email

Location

Question/Comment



ONLC TRAINING CENTERS
800-288-8221
www.onlc.com