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.
提供方
課程信息
26,370 次近期查看
可靈活調整截止日期
根據您的日程表重置截止日期。
可分享的證書
完成後獲得證書
100% 在線
立即開始，按照自己的計劃學習。
第 1 門課程（共 3 門）
中級
完成時間大約為11 小時
英語（English）
字幕：英語（English）
您將獲得的技能
- Microsoft Excel
- Time Series Models
- Business Forecasting
可靈活調整截止日期
根據您的日程表重置截止日期。
可分享的證書
完成後獲得證書
100% 在線
立即開始，按照自己的計劃學習。
第 1 門課程（共 3 門）
中級
完成時間大約為11 小時
英語（English）
字幕：英語（English）
提供方
麦考瑞大学
Macquarie is ranked among the top one per cent of universities in the world, and with a 5-star QS rating, we are recognised for producing graduates who are among the most sought-after professionals in the world. Since our foundation 54 years ago, we have aspired to be a different type of university: one focused on fostering collaboration between students, academics, industry and society.
授課大綱 - 您將從這門課程中學到什麼
完成時間為 1 小時
Welcome and Critical Information
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
完成時間為 1 小時
2 個視頻 （總計 2 分鐘）, 3 個閱讀材料
完成時間為 2 小時
Time Series Models
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.
完成時間為 2 小時
4 個視頻 （總計 43 分鐘）, 4 個閱讀材料, 3 個測驗
完成時間為 2 小時
Level Time Series
In this module, we explore different time series forecasting methods available for data that is level.
完成時間為 2 小時
5 個視頻 （總計 45 分鐘）, 2 個閱讀材料, 5 個測驗
完成時間為 2 小時
Trending Time Series
In this module, we explore different time series forecasting methods available for data that is trending.
完成時間為 2 小時
4 個視頻 （總計 38 分鐘）, 3 個閱讀材料, 3 個測驗
完成時間為 2 小時
Seasonal Time Series
In this module, we explore a time series forecasting method (Winters Exponential Smoothing) available for data that is seasonal.
完成時間為 2 小時
4 個視頻 （總計 35 分鐘）, 2 個閱讀材料, 4 個測驗
審閱
- 5 stars91.91%
- 4 stars6.06%
- 3 stars2.02%
來自EXCEL TIME SERIES MODELS FOR BUSINESS FORECASTING的熱門評論
由 LG 提供2021年9月20日
I was able to immediately apply the forecasting models to my existing data. Highly recommend this course.!!
由 VA 提供2021年7月25日
The course content is just superb, and the way the faculty is teaching the course is just fantastic. I did not find any course on time series forecasting having such kind of conceptual clarity.
由 TH 提供2021年7月6日
I love the structure of the course with practical videos.
由 H 提供2022年3月17日
Great presentation with excellent course content for practical experience.
關於 Excel Skills for Business Forecasting 專項課程
The current state of the world makes business forecasting even more fundamental to the operation of institutions. In this Specialization we focus on Excel Skills for Business Forecasting in three courses — Time Series Models, Regression Models, and Judgmental Forecasting.
常見問題
我什么时候能够访问课程视频和作业？
我订阅此专项课程后会得到什么？
有助学金吗？
還有其他問題嗎？請訪問 學生幫助中心。
