Macquarie University - Excel Time Series Models for Business Forecasting
- Offered byCoursera
- Public/Government Institute
Excel Time Series Models for Business Forecasting at Coursera Overview
Duration | 11 hours |
Total fee | Free |
Mode of learning | Online |
Difficulty level | Intermediate |
Official Website | Explore Free Course  |
Credential | Certificate |
- Overview
- Highlights
- Course Details
- Curriculum
Excel Time Series Models for Business Forecasting at Coursera Highlights
- Reset deadlines in accordance to your schedule.
- Shareable Certificate Earn a Certificate upon completion
- 100% online Start instantly and learn at your own schedule.
Excel Time Series Models for Business Forecasting at Coursera Course details
- This course explores different time series business forecasting methods.
- The course covers a variety of business forecasting methods for different types of components present in time series data - level, trending, and seasonal.
- We will learn about the theoretical methods and apply these methods to business data using Microsoft Excel. These forecasting methods will be programmed into Microsoft Excel, displayed graphically, and we will optimise these models to produce accurate forecasts.
- We will compare different models and their forecasts to decide which model best suits our business' needs.
Excel Time Series Models for Business Forecasting at Coursera Curriculum
Welcome and Critical Information
Course introduction
Welcome to Excel Time Series Models for Business Forecasting
Course goals and weekly learning objectives
Important information about versions and regions
Time Series Models
Components of Time Series Data
Average Forecasts
Errors and Error Criterion
Read me before you start: Quizzes and Navigation
Download the Week 1 workbooks
Week 1 Toolbox
Week 1 Practice Challenge
Components of Time Series Data
Average Forecasts
Errors and Error Criterion
Level Time Series
Level Time Series
Naïve Forecasts
Moving Average Forecasts
Simple Exponential Smoothing
Solver for SES Forecasting
Download the Week 2 workbooks
Week 2 Toolbox
Naïve Forecasts
Moving Average Forecasts
Simple Exponential Smoothing
Solver for SES Forecasting
Assessment ? weeks 1 and 2
Trending Time Series
Trending Time Series
Trend-fitting
Holt's Exponential Smoothing
Solver for HES Forecasting
Download the Week 3 workbooks
Week 3 Toolbox
Week 3 Practice Challenge
Trend-fitting
Holt's Exponential Smoothing
Solver for HES Forecasting
Seasonal Time Series
Seasonal Time Series
Winters Exponential Smoothing ? Seeds
Winters Exponential Smoothing ? Forecasts
Solver for WES Forecasts
Download the Week 4 workbooks
Week 4 Toolbox
Winters Exponential Smoothing ? Seeds
Winters Exponential Smoothing ? Forecasts
Solver for WES Forecasts
Assessment ? weeks 3 and 4
Decomposition
Decomposition
Decomposition ? De-seasonalising
Decomposition ? De-trending and Forecasting
Autocorrelation Functions for Testing our Components
Download the Week 5 workbooks
Week 5 Toolbox
Decomposition ? De-seasonalising
Decomposition ? De-trending and Forecasting
Autocorrelation Functions for Testing our Components
Final assessment ? all course content
Other courses offered by Coursera
Student Forum
Anything you would want to ask experts?