Monthly Subscription Starting at AED 99 + VAT

Excel Time Series Models for Business Forecasting
  • Level Professional
  • Duration 11 hours
  • Course by Macquarie University
  • Offered by

About

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.

Modules

About the course

    • 2 Videos
    • 3 Readings
    • 1 Discussion
Show info about module content

1 Discussions

  • Set your goals and be successful

2 Videos

  • Excel Skills for Business Forecasting Introduction
  • Course introduction

3 Readings

  • Welcome to Excel Time Series Models for Business Forecasting
  • Course goals and weekly learning objectives
  • Important information about versions and regions

Introduction

    • 1 Videos
Show info about module content

1 Videos

  • Time Series Models

Practice Videos

    • 3 Videos
    • 2 Readings
    • 3 Assignment
Show info about module content

3 Assignment

  • Components of Time Series Data
  • Average Forecasts
  • Errors and Error Criterion

3 Videos

  • Components of Time Series Data
  • Average Forecasts
  • Errors and Error Criterion

2 Readings

  • Read me before you start: Quizzes and Navigation
  • Download the Week 1 workbooks

Toolbox

    • 1 Readings
Show info about module content

1 Readings

  • Week 1 Toolbox

Practice Challenge

    • 1 Readings
Show info about module content

1 Readings

  • Week 1 Practice Challenge

Introduction

    • 1 Videos
Show info about module content

1 Videos

  • Level Time Series

Practice Videos

    • 4 Videos
    • 1 Readings
    • 4 Assignment
Show info about module content

4 Assignment

  • Naïve Forecasts
  • Moving Average Forecasts
  • Simple Exponential Smoothing
  • Solver for SES Forecasting

4 Videos

  • Naïve Forecasts
  • Moving Average Forecasts
  • Simple Exponential Smoothing
  • Solver for SES Forecasting

1 Readings

  • Download the Week 2 workbooks

Toolbox

    • 1 Readings
Show info about module content

1 Readings

  • Week 2 Toolbox

Assessment

    • 1 Assignment
Show info about module content

1 Assignment

  • Assessment — weeks 1 and 2

Introduction

    • 1 Videos
Show info about module content

1 Videos

  • Trending Time Series

Practice Videos

    • 3 Videos
    • 1 Readings
    • 3 Assignment
Show info about module content

3 Assignment

  • Trend-fitting
  • Holt's Exponential Smoothing
  • Solver for HES Forecasting

3 Videos

  • Trend-fitting
  • Holt's Exponential Smoothing
  • Solver for HES Forecasting

1 Readings

  • Download the Week 3 workbooks

Toolbox

    • 1 Readings
Show info about module content

1 Readings

  • Week 3 Toolbox

Practice Challenge

    • 1 Readings
Show info about module content

1 Readings

  • Week 3 Practice Challenge

Introduction

    • 1 Videos
Show info about module content

1 Videos

  • Seasonal Time Series

Practice Videos

    • 3 Videos
    • 1 Readings
    • 3 Assignment
Show info about module content

3 Assignment

  • Winters Exponential Smoothing — Seeds
  • Winters Exponential Smoothing — Forecasts
  • Solver for WES Forecasts

3 Videos

  • Winters Exponential Smoothing — Seeds
  • Winters Exponential Smoothing — Forecasts
  • Solver for WES Forecasts

1 Readings

  • Download the Week 4 workbooks

Toolbox

    • 1 Readings
Show info about module content

1 Readings

  • Week 4 Toolbox

Assessment

    • 1 Assignment
Show info about module content

1 Assignment

  • Assessment — weeks 3 and 4

Introduction

    • 1 Videos
Show info about module content

1 Videos

  • Decomposition

Practice Videos

    • 3 Videos
    • 1 Readings
    • 3 Assignment
Show info about module content

3 Assignment

  • Decomposition — De-seasonalising
  • Decomposition — De-trending and Forecasting
  • Autocorrelation Functions for Testing our Components

3 Videos

  • Decomposition — De-seasonalising
  • Decomposition — De-trending and Forecasting
  • Autocorrelation Functions for Testing our Components

1 Readings

  • Download the Week 5 workbooks

Toolbox

    • 1 Readings
Show info about module content

1 Readings

  • Week 5 Toolbox

Assessment

    • 1 Assignment
Show info about module content

1 Assignment

  • Final assessment — all course content

Auto Summary

Enhance your business acumen with the "Excel Time Series Models for Business Forecasting" course, tailored for professionals in the Business & Management domain. This comprehensive program, offered by Coursera, delves into various time series forecasting methods essential for accurate business predictions. Over 660 minutes of engaging content, you'll master techniques to handle different time series data components, such as level, trend, and seasonal variations. Under the expert guidance of seasoned instructors, you'll not only learn the theoretical foundations but also gain hands-on experience by applying these methods using Microsoft Excel. The course emphasizes practical applications, including programming forecasting models, visualizing data graphically, and optimizing models for precise forecasts. Furthermore, you'll compare different models to identify the most suitable one for your business needs. Available through flexible subscription plans like Starter and Professional, this course is ideal for business professionals seeking to enhance their forecasting skills and make data-driven decisions. Join now to transform your approach to business forecasting and stay ahead in a competitive market.

Dr Prashan S. M. Karunaratne
Instructor

Dr Prashan S. M. Karunaratne