Excel Forecasting and What-If Analysis Course Outline
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.
The course is for individuals who are responsible for creating forecasts and doing what-if analysis with Excel.
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.
Using the Forecast Sheet
Using Forecast Functions
Using the Quick Analysis Tool
Using What-If Analysis
Working with Scenarios
Creating Data Tables
Using Goal Seek
Adding the Solver Add-in
Define a Problem Using Solver
Solving a Problem
Solver for Capital Budgeting
Solver for Financial Planning
Solver to determine Optimal Product Mix
Perform What-If Analysis with the Solver Tool
Using the Power Query Editor
Using the Excel Data Model
Viewing a Data Model
Using the Model
Creating Calculated Columns
View outline in Word
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.