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
This course is part of Excel Skills for Business Forecasting Specialization
Instructor: Dr Prashan S. M. Karunaratne
Sponsored by BrightStar Care
14,411 already enrolled
(219 reviews)
Skills you'll gain
Details to know
Add to your LinkedIn profile
19 assignments
See how employees at top companies are mastering in-demand skills
Build your subject-matter expertise
- 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
Earn a career certificate
Add this credential to your LinkedIn profile, resume, or CV
Share it on social media and in your performance review
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 assignments
In this module, we explore different time series forecasting methods available for data that is level.
What's included
5 videos2 readings5 assignments
In this module, we explore different time series forecasting methods available for data that is trending.
What's included
4 videos3 readings3 assignments
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 assignments
In this module, we explore a time series forecasting method (Decomposition) available for data that is seasonal.
What's included
4 videos2 readings4 assignments
Instructor
Offered by
Why people choose Coursera for their career
Learner reviews
219 reviews
- 5 stars
89.49%
- 4 stars
8.67%
- 3 stars
0.91%
- 2 stars
0.45%
- 1 star
0.45%
Showing 3 of 219
Reviewed on Aug 15, 2021
I thought it was a good course although the professor kept saying "Everybody say wow" in practically every video and sometimes more than once and it was annoying
Reviewed on Sep 18, 2021
Excellent tutor. Clear concise and great examples to work along to. Thank you
Reviewed on Nov 21, 2022
Great Skills thought. Thank you Prashan, for making your lessons easy to understand
Recommended if you're interested in Business
Macquarie University
Macquarie University
Macquarie University
Emory University
Open new doors with Coursera Plus
Unlimited access to 10,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