Virtual Live Instructor
Free Training Manual
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
Use Exponential Smoothing for Forecasting
Customizing Your Forecast
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
What-If Use Scenarios
Changing Cells and the Result Cell
Consider Different Variables
Scenario Summary Reports
What-If Use Data Tables
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
By Changing Cell
Goal Seek vs 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 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
Please check the course description to find prerequisite information.
We offer live-instructor group training classes for your team.
Upskill your team from the comfort of your office or online.
Benefits of Group Training Include:
This was the class I needed.
The instructor Jeff took his time and made sure we understood each topic before moving to the next. He answered all of our questions, and I don't know about the rest of the students, but was very pleased with this experience.
I finally understand how to use Excel.
-Amanda T (Yale New Haven Hospital).
We were able to cover a lot of information in one day without getting overwhelmed.
-Maria R (Microsoft).
Instructor led training is a cost effective and convenient learning platform for busy professionals. Most courses are available at over 300 locations nationwide and Online.
The classes are taught via the RCI method by professionally certified instructors, and are usually limited to 12 or less students. Each student receives a training manual and practice problems, along with a free course retake. Click here to learn more about Instructor Led Training
Below is a list of upcoming Excel Instructor Led Class Dates:
We offer private Excel group training services for organizations looking to upskill their team members with a live-instructor.
Training options include:
Learn more about how Excel Private Group Training from Business Computer Skills can help your team.