This 'hands on' course takes the theory from the course, "Using Regressions for Forecasting", and puts it into practice. The goal is to allow participants to follow along with the instructor and run regressions for forecasting in Excel.
***Please download and open all supporting materials before starting the course videos.***
Prerequisites
Viewers should be familiar with basic financial and accounting concepts. In addition, viewers should be familiar with Big Data and Business Intelligence, or review my existing courses on the topic. Familiarity with and access to Excel will be helpful.
Learning Objective
- Explore how to apply a regression to create a forecast
- Recognize how to interpret output from a regression
- Identify the limitations on regression-based forecasts
- Identify margin of error on regression-based forecasts
Last updated/reviewed: July 23, 2025
(0) Reviews
(225 rating)Lesson Questions and Answers0 Questions
There are no questions.
Answers to Frequently Asked Questions (FAQs)
Michael McDonald
President
INTRODUCTION AND OVERVIEW
- Introduction to Forecasting in Excel (Hands-on module) 00:41
- Forecasting in Excel Exercise 1 13:54
- Forecasting in Excel Exercise 2 12:08
- Forecasting in Excel Exercise 2 (Continued) 11:27
CONTINUOUS PLAY
SUPPORTING MATERIALS
- Forecasting in Excel (Hands-on module) Glossary/Index PDF
- Workbook: Forecasting in Excel (Hands-on module) PART 1 XLS
- Workbook: Forecasting in Excel (Hands-on module) PART 2 CRDOWNLOAD
- Completed Workbook: Forecasting in Excel (Hands-on module) XLS
REVIEW AND TEST
- REVIEW QUESTIONS quiz
- FINAL EXAM exam
Ask the instructor a question about this lesson