This course gives participants the tools to be able to run regressions Excel and make forecasts based on those regressions. Starting from scratch, participants get direct practice in gathering business data from publicly traded companies.
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
- Discover how to gather business data from online sources at no cost
- Discover how to combine datasets into an easy to use format
- Discover how to run regressions based on the data
- Recognize how to interpret the regressions
- Explore how to form forecasts forecasts based on regressions
- Discover how to determine the margin of error around any regression forecast
- Explore how to run scenario analysis and produce output statistics that indicate how confident users of a regression forecast should be.
Last updated/reviewed: July 10, 2025
(0) Reviews
(272 rating)Lesson Questions and Answers0 Questions
Progress
INTRODUCTION
Regressions in Excel
- Regressions in Excel - Part 1 6:09
- Regressions in Excel - Part 2 6:06
- Regressions in Excel - Part 3 8:52
Getting Hands-on with Regressions in Excel
- Introduction to Regressions in Excel (Hands-on module) 00:56
- Regressions in Excel (Hands-on module) Module 1 11:56
- Regressions in Excel (Hands-on module) Module 2 10:45
- Regressions in Excel (Hands-on module) Module 3 14:21
- Regressions in Excel (Hands-on module) Module 4 12:17
- Regressions in Excel (Hands-on module) Module 4 Continued and Conclusion 10:26
CONTINUOUS PLAY
SUPPORTING MATERIALS
- Regressions in Excel (Hands-on module) Glossary/Index PDF
- Regressions in Excel Financial Data XLSX
- Workbook: Regressions in Excel (Hands-on module) XLS
- Completed Workbook: Regressions in Excel (Hands-on module) XLS
REVIEW AND TEST
- REVIEW QUESTIONS quiz
- FINAL EXAM exam
Regressions in Excel (Hands-on module)
Certified Public Accountant
Online
No advanced preparation or prerequisites are required for this course.

NASBA Sponsor Number: 109504
State of New York Sponsor Number: 002746
State of Texas Sponsor Number: 009890
Chartered Accountant (IES8 CPD)
Online
Certified Management Accountant
Online
No advanced preparation or prerequisites are required for this course.
Certified Fraud Examiner
Online
No advanced preparation or prerequisites are required for this course.
Certified Government Financial Manager
Online
No advanced preparation or prerequisites are required for this course.
Certified Internal Auditor
Online
No advanced preparation or prerequisites are required for this course.

Recognized CPE provider, authorized by the Institute of Internal Auditors for use in the Certified Internal Auditor (CIA) CPE program.
Certification in Risk Management Assurance
Online
No advanced preparation or prerequisites are required for this course.

Recognized CPE provider, authorized by the Institute of Internal Auditors for use in the Certified Risk Management Assurance (CRMA) CPE program.
Ask the instructor a question about this lesson