Macquarie University
Excel Time Series Models for Business Forecasting
Macquarie University

Excel Time Series Models for Business Forecasting

This course is part of Excel Skills for Business Forecasting Specialization

Taught in English

Some content may not be translated

11,768 already enrolled

Included with Coursera Plus

Course

Gain insight into a topic and learn the fundamentals

4.9

(193 reviews)

Intermediate level
Some related experience required
11 hours (approximately)
Flexible schedule
Learn at your own pace

Details to know

Shareable certificate

Add to your LinkedIn profile

Assessments

19 quizzes

Course

Gain insight into a topic and learn the fundamentals

4.9

(193 reviews)

Intermediate level
Some related experience required
11 hours (approximately)
Flexible schedule
Learn at your own pace

See how employees at top companies are mastering in-demand skills

Placeholder

Build your subject-matter expertise

This course is part of the Excel Skills for Business Forecasting Specialization
When you enroll in this course, you'll also be enrolled in this Specialization.
  • Learn new concepts from industry experts
  • Gain a foundational understanding of a subject or tool
  • Develop job-relevant skills with hands-on projects
  • Earn a shareable career certificate
Placeholder
Placeholder

Earn a career certificate

Add this credential to your LinkedIn profile, resume, or CV

Share it on social media and in your performance review

Placeholder

There are 6 modules in this course

Business Forecasting is part of any and every organisation. Organisations need to forecast so that they can plan for the organisation’s needs. Business forecasts are the inputs to every organisation’s planning – without business forecasts we cannot plan for our resources, our production, our supply chains – and ultimately our costs, revenues and profits. The current state of the world makes business forecasting even more fundamental to the operation of institutions. In this course we focus on Excel Skills for Business Forecasting using Time Series Models. We will be looking at how your business can utilise time series data sets to understand the different components underlying this data, and then apply the relevant model depending on these components. We will look at a range of business forecasting methods, and sometimes, more than one method may be needed! The models we look at are: Naïve Forecasting, Moving Averages, Trend-fitting, Simple Exponential Smoothing, Holt’s Exponential Smoothing, Winters Exponential Smoothing, and Decomposition. This course then continues in our second course in this specialisation which looks at Regression Models, and our third course in this specialisation which looks at Judgmental Forecasting. #EveryoneSayWow

What's included

2 videos3 readings1 discussion prompt

In this module, we explore the context and purpose of business forecasting and the three types of business forecasting — time series, regression, and judgmental. This course focuses on time series models. We will learn about time series models, as well as the component of time series data. We will then look at a preliminary forecasting method — Average Forecasts. Once we have a forecast, we need a tool to judge the accuracy of the forecasts — which are the forecasts and the error criterion calculated from these.

What's included

4 videos4 readings3 quizzes

In this module, we explore different time series forecasting methods available for data that is level.

What's included

5 videos2 readings5 quizzes

In this module, we explore different time series forecasting methods available for data that is trending.

What's included

4 videos3 readings3 quizzes

In this module, we explore a time series forecasting method (Winters Exponential Smoothing) available for data that is seasonal.

What's included

4 videos2 readings4 quizzes

In this module, we explore a time series forecasting method (Decomposition) available for data that is seasonal.

What's included

4 videos2 readings4 quizzes

Instructor

Instructor ratings
4.9 (76 ratings)
Dr Prashan S. M. Karunaratne
Macquarie University
28 Courses1,277,508 learners

Offered by

Recommended if you're interested in Business Strategy

Why people choose Coursera for their career

Felipe M.
Learner since 2018
"To be able to take courses at my own pace and rhythm has been an amazing experience. I can learn whenever it fits my schedule and mood."
Jennifer J.
Learner since 2020
"I directly applied the concepts and skills I learned from my courses to an exciting new project at work."
Larry W.
Learner since 2021
"When I need courses on topics that my university doesn't offer, Coursera is one of the best places to go."
Chaitanya A.
"Learning isn't just about being better at your job: it's so much more than that. Coursera allows me to learn without limits."

Learner reviews

Showing 3 of 193

4.9

193 reviews

  • 5 stars

    89.11%

  • 4 stars

    8.80%

  • 3 stars

    1.03%

  • 2 stars

    0.51%

  • 1 star

    0.51%

TH
5

Reviewed on Jul 6, 2021

JW
5

Reviewed on Sep 18, 2021

CM
5

Reviewed on Nov 21, 2022

New to Business Strategy? Start here.

Placeholder

Open new doors with Coursera Plus

Unlimited access to 7,000+ world-class courses, hands-on projects, and job-ready certificate programs - all included in your subscription

Advance your career with an online degree

Earn a degree from world-class universities - 100% online

Join over 3,400 global companies that choose Coursera for Business

Upskill your employees to excel in the digital economy

Frequently asked questions