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.

***Please download and open all supporting materials before starting the course videos.***

Learning Objectives
  • 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: August 21, 2023

Included In Certifications

This course is included in the following Certification Programs:

15 CoursesData Analytics Professional (DAP) Certification

  1. The Fundamentals of Business Intelligence (BI): What it Does and Why it's so Essential
  2. How is Industry Using Big Data? – A Case Study Reading
  3. Business Intelligence - Data Collection and Cleaning
  4. Business Intelligence - Structuring Data for Analysis
  5. Business Intelligence - Fundamentals of Data Analysis
  6. Business Intelligence - Using Big Data Analytics
  7. Doing Data Analytics In Excel (Hands-on module)
  8. Regressions in Excel (Hands-on module)
  9. Financial Forecasting
  10. Advanced Analytics – Omitted Variables
  11. Advanced Analytics – Fixed Effects
  12. Case Study in Data Analytics
  13. Using Regressions for Forecasting
  14. Financial Forecasting in Excel (Hands-on module)
  15. Blockchain for Business
39 Reviews (266 ratings)

Reviews

4
Member's Profile
Course had lots of great examples. Great pace. I am used to having notes with the course. This hands on approach was great. To obtain greater understanding of what the instructor wanted us to take away it would be great to have notes that would emphasize the key things he wanted us to note about using regression analysis. While taking the exam I encountered some things that were not apparent from hearing the lecture. I will have to do my research to further on those topics.

5
Member's Profile
Mr McDonald moves at a fast pace; however, there are many individual skills apart from regressions I became more familiar with through this course. Specifically, I now understand IF statements and Is Number statements better.

2
Anonymous Author
The questions in this module's test were bordering on incoherent. It would be preferable if the questions tested our knowledge instead of our ability to decipher cryptically worded questions with grammatical errors.

4
Anonymous Author
Being able to work through regressions in excel was helpful, however I think it would have been beneficial to have an overview course on the different regression statistics and how they can be interpreted.

5
Anonymous Author
Regression in excel is very helpful to analyze dummy data. I would like to recommend this course to anyone who is working on analyzing data. By learning this skill is helpful to increase work efficiency.

5
Member's Profile
Very good classes, the professor is excellent, and is neccesary to go deeper in the statistical knoledge and try several exercices, is a very interest campus the data analitics.

4
Anonymous Author
Material was helpful in showing how to use regressions in excel. Some of the step by step instructions on button clicks and formulas made understanding the material easier.

5
Anonymous Author
The hands on module for regression analysis was great in clarifying the regression analysis methodology and the different elements affecting the results of the analysis.

4
Anonymous Author
Overall, the course was a little hefty with the amount of data examples going on. However, it was very nice to do a hands on module and follow along with the instructor.

3
Anonymous Author
There is no supporting slide deck and the verbiage is clearly geared towards an economics background not necessarily a math or statistics background in general

4
Member's Profile
Overall a good course but some of the examples were performed in excel too quickly to replicate. Also, the exam questions did not relate well to the content.

4
Anonymous Author
The test questions were unclear and included spelling and grammatical errors. However, I thought it was nice to have hands-on lesson with multiple examples.

4
Anonymous Author
The statistical knowledge included in this course is beneficial to increase personal knowledge of items that can increase business analytics

4
Anonymous Author
this course was great to do hands on regression but there is no training on how to do the regression graph. However I still learnt a lot!

3
Member's Profile
The hands-on part of this module was effective, but the final exam had some grammatical errors that made it more esoteric than necessary.

4
Anonymous Author
I really like the hands on part of this course! You must take the previous course in order to really get the material.

4
Anonymous Author
This course provided good insights and hands on experience for working with and understanding regression analysis.

5
Anonymous Author
I appreciated how the instructor took his time in explaining definitions and how to manipulate the data.

5
Anonymous Author
Michael was able to make a large volume of regression material easy to understand and enjoyable.

4
Anonymous Author
This course did a very good job of going in depth with its explanations of regression analysis.

5
Anonymous Author
Great course. Practical knowledge is contained in this course and is ready to put in use.

3
Member's Profile
I learned a lot, but the test questions were out in left field and there are no slides.

4
Anonymous Author
this one, although hands on, was dry and difficult to hold my attention the entire time

4
Anonymous Author
Concise review of the logic of statistical analysis. Practical insight on how to.

5
Member's Profile
Excellent course. I learned a great deal. Thanks for explaining in such detail.

4
Anonymous Author
Great hands on experience and example of how to do regression statistics in Excel

3
Anonymous Author
The interaction of this course is what made it more interesting to learn about.

5
Anonymous Author
Great course. wish there was more time to learn. had hard time following along.

5
Anonymous Author
Course was informative and easy to navigate. I would recommend to a colleague.

5
Anonymous Author
Great final course to take that sums up data and analytics. good examples

5
Anonymous Author
Great information available in this course, will recommend to others.

5
Member's Profile
Very good refresher. It has been years since I looked at statistics.

4
Member's Profile
Final exam didn't really address to points emphasized in the program.

4
Anonymous Author
really good overview of regression and how excel can be used for it

5
Anonymous Author
Great course providing wealth of information on regression.

5
Member's Profile
Very good class, informative materials and well presented

5
Member's Profile
Everything about this course was absolutely fantastic.

5
Anonymous Author
Good course. Would recommend. Great content and info.

4
Anonymous Author
going through the excel example I find very helpful

Prerequisites
Course Complexity: Intermediate

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.

Education Provider Information
Company: Illumeo, Inc., 75 East Santa Clara St., Suite 1215, San Jose, CA 95113
Contact: For more information regarding this course, including complaint and cancellation policies, please contact our offices at (408) 400- 3993 or send an e-mail to .
Course Questions and Answers1 Question
User picture
Instructor for this course
Course Syllabus
Introduction
  Introduction to Regressions in Excel0:25
Regressions in Excel
  Regressions in Excel - Part 16:09
  Regressions in Excel - Part 26:06
  Regressions in Excel - Part 38: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 111:56
  Regressions in Excel (Hands-on module) Module 210:45
  Regressions in Excel (Hands-on module) Module 314:21
  Regressions in Excel (Hands-on module) Module 412:17
  Regressions in Excel (Hands-on module) Module 4 Continued and Conclusion10:26
CONTINUOUS PLAY
  Regressions in Excel (Hands-on module) 1:22:17
SUPPORTING MATERIALS
  Regressions in Excel (Hands-on module) Glossary/IndexPDF
  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 QUESTIONSquiz
 FINAL EXAMexam