Course Overview
This course will enable you to forecast for trending and seasonal data in Excel. The Methods to be covered will be Holt's Method, Holt Winter's Method, Desasonalizing & Multiple Regression on Seasonal Data. The course provides the opportunity to use and evaluate current software. *Note: Thank you for your interest in a BCIT – Free Online Learning course. You are about to register for the course. If you are new to BCIT, you will first need to create a BCIT ID. Then, log in with your ID and password to register. Once registered, log in to learn.bcit.ca with your BCIT email address and password to access your online course. If you are new to BCIT, it may take up to 24 hours for your course access to become active. Because these are not credited courses, and you are not paying a fee, there may be student resources you come across that you are not entitled to access. This would include Student Aid and other financial assistance. Enjoy your learning and we’re happy to support your lifelong learning journey.
Prerequisite(s)
- A working knowledge of Microsoft Excel, a rudimentary knowledge of math and a rudimentary knowledge of stats (not necessary but recommended).
Credits
0.0
Domestic fees
$0.00
International fees are typically 3.4 times the domestic tuition. Exact cost will be calculated upon completion of registration.
Learning Outcomes
Upon successful completion of this course, the student will be able to:
- Identify the 4 components of time series data
- Identify seasonality in data
- Learn how to perform Holt's Method for Trend
- Learn how to perform Holt Winter's Method
- Learn how to deseasonalize data
- Learn how to create dummy variables
- Use multiple regression & dummy variables to perform forecasts on seasonal data
Effective as of Spring/Summer 2021
Course Offerings
Fall 2026
Below is one offering of MOOC 0130 for the Fall 2026 term.
CRN 48601
Dates
Start any time Loading
- CRN 48601
- $0.00 Domestic fees
Continuous Entry, Distance or Online
This is an online learning course. Start any time. You have 52 weeks from the date you register to complete this course.
Duration
52 weeks
Instructor
TBD
Course outline
Course outline TBD — see Learning Outcomes in the interim.
Confirmation
Required
To proceed with registration and add this course to the cart, please confirm:
Status
Winter 2027
Below is one offering of MOOC 0130 for the Winter 2027 term.
CRN 89437
Dates
Start any time Loading
- CRN 89437
- $0.00 Domestic fees
Continuous Entry, Distance or Online
This is an online learning course. Start any time. You have 52 weeks from the date you register to complete this course.
Duration
52 weeks
Instructor
TBD
Course outline
Course outline TBD — see Learning Outcomes in the interim.
Confirmation
Required
To proceed with registration and add this course to the cart, please confirm:
Status
Programs and courses are subject to change without notice. Find out more about BCIT course cancellations.