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: June 23, 2018

    Included In Certifications

    This course is included in the following Expert Certifications:

    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

    2 Reviews (21 ratings)Reviews

    4
    Anonymous Author
    Very good module and hands on learning video and slides
    5
    Member's Profile
    Everything about this course was absolutely fantastic.

    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