Lesson 1: Forecasting Data
Topic A: Determine Potential Outcomes Using Data Tables
- What-If Analysis
- Data Tables
- One-Variable Data Tables
- Two-Variable Data Tables
- The Data Table Dialog Box
- How to Create a Data Table
- Determining Potential Outcomes Using Data Tables
Topic B: Determine Potential Outcomes Using Scenarios
- Scenarios
- The Scenario Manager Dialog Box
- The Add Scenario Dialog Box
- The Scenario Values Dialog Box
- The Scenario Command
- How to Work with Scenarios
- Determining Potential Outcomes by Using Scenarios
Topic C: Use the Goal Seek Feature
- The Goal Seek Feature
- The Goal Seek Dialog Box
- Iterative Calculations
- How to Use the Goal Seek Feature
- Using the Goal Seek Feature
Topic D: Forecasting Data Trends
- The Forecast Sheet
- How to Create a Forecast Sheet
- Forecasting Data with the Forecast Sheet