Instructor for this course
more

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: November 11, 2019

Included In Certifications

This course is included in the following Certification Programs:

15 CoursesCDAP (Certified Data Analyst Professional)

  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

32 Reviews (226 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.
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.
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.
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.
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
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
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 .

1 QuestionCourse Questions and Answers

User picture
Course Syllabus
Introduction
  0:25Introduction to Regressions in Excel
Regressions in Excel
  6:09Regressions in Excel - Part 1
  6:06Regressions in Excel - Part 2
  8:52Regressions in Excel - Part 3
Getting Hands-on with Regressions in Excel
  00:23Introduction to Regressions in Excel (Hands-on module)
  11:57Regressions in Excel (Hands-on module) Module 1
  10:45Regressions in Excel (Hands-on module) Module 2
  14:22Regressions in Excel (Hands-on module) Module 3
  12:18Regressions in Excel (Hands-on module) Module 4
  10:26Regressions in Excel (Hands-on module) Module 4 Continued and Conclusion
CONTINUOUS PLAY
  1:21:43Regressions in Excel (Hands-on module)
SUPPORTING MATERIALS
  PDFRegressions in Excel (Hands-on module) Glossary/Index
  XLSXRegressions in Excel Financial Data
  XLSWorkbook: Regressions in Excel (Hands-on module)
  XLSCompleted Workbook: Regressions in Excel (Hands-on module)
REVIEW AND TEST
  quizREVIEW QUESTIONS
 examFINAL EXAM