Instructor for this course
more

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.***

Learning Objectives

  • 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: October 22, 2018

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

25 Reviews (201 ratings)Reviews

5
Member's Profile
Another excellent course from Mr. McDonald. One suggestion for improvement... In the final segment a "discount rate" variable was included. This variable was not clearly explained, yet had by far the greatest impact on the projected sales figure. It increased the sales projection almost three-fold, an impact of $971M on a base of $371M of sales. It would be helpful to either exclude this variable or spend a bit of time explaining why it can be valid given its overwhelming influence on the sales projection.
4
Member's Profile
Really like going through the hands on exercises. The in-depth explanations were helpful in understanding the different types of methods and the reasoning for preferring regression to other more simplified methods. Needed understanding of some of the use of terminology, but overall a great hands on treatment of the subject matter.
5
Member's Profile
The course was great. It gives me another avenue to use for forecasting. I usually us CAGRs but this is good insights into regression that could be used to forecast different financial variables. Eventhough the variables are a catch all, give light to different types of analysis that could be performed.
5
Member's Profile
The material was straight forward, and well explained. super helpful for anyone trying to build a forecasting model. I was not sure about where to start, but from watching the sales example, I am confident building a revenue forecast model for my internship
4
Anonymous Author
This course builds on prior materials and shows an example in excel. The second example was a little slow in delivery, but the first to analyze the thief was interesting and effective to show the power of regressions.
4
Anonymous Author
Once again a knowledge of the exam questions is dependent on the participants enrollment in other programs within this certification program. Useful information but not connection to final exam questions.
4
Anonymous Author
Good hands-on course to put into practice the teaching from other training in the program. Make sure to take the explanatory course before taking this hands-on course.
5
Anonymous Author
The course was very challenging, however, the instructor was very effective in presenting course materials. The time allotted for the course was sufficient as well.
3
Anonymous Author
It has been awhile since I took this type of course in college. Instructed suggested that you take other course first - it would be helpful.
5
Member's Profile
great course. it was very helpful in learning the theory behind financial forecasting. would prefer a few more hands on exercises.
5
Member's Profile
Thank you instructor for the grate material and topics explanations, it makes the course easy and motivate to continue study.
4
Anonymous Author
I really loved the employee embezzlement example. I never thought of using regression for that particular purpose.
5
Member's Profile
Good introduction to regressions in excel. Clean explanations of each field generated by the excel regression tool.
5
Anonymous Author
Michael was able to deliver the financial forecasting material in a way that was easy to understand and enjoyable.
5
Member's Profile
Really loved this course. Much thanks to Grant Thornton for making the video and the instructor available.
5
Anonymous Author
Excel examples were useful and I can see the relevance that can be used by lessons taught in this course.
4
Anonymous Author
This course was useful in allowing us to work alongside the instructor and see the steps in excel.
4
Anonymous Author
Course was informative and easy to navigate. I would recommend to a colleague.
5
Anonymous Author
Course was informative and easy to navigate. I would recommend to a colleague.
5
Member's Profile
Good course. Each step was well explained. I wood recommend this course.
4
Anonymous Author
needs much better supporting documentation and not just the glossary
4
Anonymous Author
Enjoyed the examples given - easy to follow and understand.
4
Anonymous Author
Very good module and hands on learning video and slides
5
Member's Profile
Everything about this course was absolutely fantastic.
4
Anonymous Author
The real life examples were helpful to walk through

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 Syllabus
INTRODUCTION AND OVERVIEW
  00:42Introduction to Forecasting in Excel (Hands-on module)
  13:55Forecasting in Excel Excercise 1
  12:08Forecasting in Excel Excercise 2
  11:28Forecasting in Excel Excercise 2 (Continued)
CONTINUOUS PLAY
  38:13Forecasting in Excel (Hands-on module)
SUPPORTING MATERIALS
  PDFForecasting in Excel (Hands-on module) Glossary/Index
  XLSWorkbook: Forecasting in Excel (Hands-on module) PART 1
  XLSWorkbook: Forecasting in Excel (Hands-on module) PART 2
  XLSCompleted Workbook: Forecasting in Excel (Hands-on module)
REVIEW AND TEST
  quizREVIEW QUESTIONS
 examFINAL EXAM