Course Overview

Module Introduction

How to Use this Course

Course Information

The Risks and Benefits of Data Forecasting

Module Introduction

Applications of Data Forecasting

Lesson Introduction

Uses of Data Forecasting

Interpreting Data Forecasts

Self Test

Data Forecasting for Business Needs

Lesson Introduction

Forecasting for Growth

Forecasting for Planning

Self Test

Recognizing the Positive and Negative Aspects of Data Forecasting

Lesson Introduction

Benefits of Data Forecasting

Risks of Data Forecasting

Self Test

Module Summary

Creating Formula-Based Forecasts

Module Introduction

Three Formula-Based Forecasting Resources

Lesson Introduction

Data Forecasting Techniques

Identifying the Tools to Create Data Forecasts

Self Test

Lab A: Building a Forecast Formula

Lesson Introduction

Scenario

Exercises

Lab Review

Lab B: Creating Forecasts Based on Scenarios

Lesson Introduction

Scenario

Exercises

Lab Review

Lab C: Establishing Targets by Using Goal Seek

Lesson Introduction

Scenario

Exercises

Lab Review

Tips for Formula-Based Forecasts

Lesson Introduction

Best Practices to Create Forecasts

Using Forecasting Tips in Excel

Self Test

Module Summary

Forecasting By Using Moving Averages

Module Introduction

Measuring Organizational Performance Using Moving Averages

Lesson Introduction

Defining a Moving Average

Describing the Limitations of Using Moving Averages

Self Test

Using Moving Averages for Decision Making

Lesson Introduction

Forecasting Income and Resource Usage

Facilitating Business Forecasting Using Moving Averages

Self Test

Lab A: Calculating and Charting a Moving Average

Lesson Introduction

Scenario

Exercises

Lab Review

Lab B: Creating an Interactive Chart

Lesson Introduction

Scenario

Exercises

Lab Review

Refining Moving Average Analysis

Lesson Introduction

Forecasting and Trend Analysis Using Microsoft Office Excel 2003

Techniques for Refining a Moving Average Analysis

Self Test

Module Summary

Maximizing Profit Potential

Module Introduction

Net Present Value and Internal Rate of Return

Lesson Introduction

Determining Net Present Value

Determining Internal Rate of Return

Self Test

Lab A: Calculating Net Present Value

Lesson Introduction

Scenario

Exercises

Lab Review

Lab B: Calculating Internal Rate of Return

Lesson Introduction

Scenario

Exercises

Lab Review

Introducing Solver

Lesson Introduction

Handling Circular References

Using Solver to Find Solutions

Using the SUMPRODUCT Formula to Summarize Data

Best Practices for Defining Problems in Solver

Self Test

Lab C: Determining Optimal Project Mixes

Lesson Introduction

Scenario

Exercises