Toll Free - 877-442-3915

Account | Self-Paced Login

Account | Self-Paced Login | 877-442-3915

Improve your skills while working at home
Online Training options available for all of our courses
Live-Instructor - Online Group Training - On-Demand


Excel Forecasting and What-If Analysis Training Course

Excel Forecasting and What-If Analysis Training Course


Course Description:  The Excel Forecasting and What-If Analysis course will train students on how to use tools in Excel (such as Solver, Scenarios, forecasting functions and Data Tables) to build forecasts and complex What-If analysis on their data sets.

Upon completion of the course, users will be able to:

  • Use the Quick Analysis Tool
  • One-Click Forecasting
  • Customizing a Forecast
  • Forecasting Functions
  • What-If Using Scenarios
  • Use Goal Seek
  • Use Solver
  • Work with large files
  • Understand the Excel Data Model

Training Dates
(Click on the course name below to view course details and full list of class dates)

Excel Forecasting and What-If Analysis
Locations: Available Nationwide and Online
Class Date(s): 6/19/2020 - 6/19/2020
Course Fee : $395


Excel Forecasting and What-If Analysis
Locations: Available Nationwide and Online
Class Date(s): 7/17/2020 - 7/17/2020
Course Fee : $395


Excel Forecasting and What-If Analysis
Locations: Available Nationwide and Online
Class Date(s): 8/14/2020 - 8/14/2020
Course Fee : $395


Course Syllabus

Use the Quick Analysis Tool
Formatting
Charts
Tables
Sparklines

One-Click Forecasting
Use 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
Use the Confidence Interval Function
Use the Statistics Function to get statistics related to the Forecast

Introduction to What-If Analysis
Overview

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

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

What-If Use 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

Onsite excel Training
Small Group Package (up to 6 students)
  • A Professional Instructor will come to your office and train your students
  • Up to 6 students can attend the class for the flat rate course price of $1800/day
  • Additional students can be added for $125/person/day
  • Each student receives a Course Manual with Practice Files (Materials will be shipped before the class date)
  • Course is scheduled based on dates you provide (Subject to instructor availability)
  • We usually require about 2-weeks lead time to arrange a training session
  • Training is completed in a convenient 1-day session (Start at 9am and Finish at 4:30pm)
  • Two 15 minute breaks and one hour long break for lunch

Total Cost for 6 students: $1800/day (Flat Rate)

Medium Group Package (up to 12 students)
  • A Professional Instructor will come to your office and train your students
  • Up to 12 students can attend the class for the flat rate course price of $2500/day (over 31% off our Individual Training rates)
  • Additional students can be added for $100/person/day
  • Each student receives a Course Manual with Practice Files (Materials will be shipped before the class date)
  • Course is scheduled based on dates you provide (Subject to instructor availability)
  • We usually require about 2-weeks lead time to arrange a training session
  • Training is completed in a convenient 1-day session (Start at 9am and Finish at 4:30pm)
  • Two 15 minute breaks and one hour long break for lunch

Total Cost for 12 students: $2500/day (Flat Rate)

Large Group Package (up to 18 students)
  • A Professional Instructor will come to your office and train your students
  • Up to 18 students can attend the class for the flat rate course price of $3100 (over 43% off our Individual Training rates)
  • Additional students can be added for $75/person/day
  • Each student receives a Course Manual with Practice Files (Materials will be shipped before the class date)
  • Course is scheduled based on dates you provide (Subject to instructor availability)
  • We usually require about 2-weeks lead time to arrange a training session
  • Training is completed in a convenient 1-day session (Start at 9am and Finish at 4:30pm)
  • Two 15 minute breaks and one hour long break for lunch

Total Cost for 18 students: $3100/day (Flat Rate)




Online Self-Paced Training Value Package Only $149

"The Instructor made class truly interesting and put everything into real world terms."
- Meredith T(Jersey City, NJ)


Business Computer Skills Microsoft Partner

Business Computer Skills BBB Profile