- Financial Data Analysis
- Forecasting
- Microsoft Excel
- Business Analytics
- Time Series Models
- Business Forecasting
- regression models
Excel Skills for Business Forecasting 專項課程
Generate Insights with Business Forecasting
2,817 人已註冊
提供方
您將獲得的技能
關於此 專項課程
4,966 次近期查看
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.
In the first course on 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 to forecast for your business' needs.
We then continue in our second course in this specialisation which looks at Regression Models, building causal models for both time series data as well as cross-sectional data. Causal models allow us to develop further business insights and strategy by controlling the inputs to generate the output we desire.
In the third and final course, we explore the role of Judgmental Forecasting, when more quantitative forecasting methods have limitations, and we need to generate further business insights. We will be exploring some structured methodologies to create judgmental business forecasts and explore how Excel can assist us in these judgments. We will bring all these forecasting methods together in a final case study, giving you the opportunity to generate forecasts, which are the inputs to any organisation's planning.
應用的學習項目
Working with datasets similar to those typically found in a business, you will use quantitative and qualitative forecasting techniques to generate business forecasts. Create charts to visualise data and forecasts. Calculate model errors and use optimisation techniques to minimise these errors and choose the best model parameters. Combine different models and expert judgment to incorporate uncertainty.
可分享的證書
完成後獲得證書
100% 在線課程
立即開始，按照自己的計劃學習。
靈活的計劃
設置並保持靈活的截止日期。
中級
You should have familiarity with the Excel user interface, moving around an Excel workbook, and creating basic formulas.
完成課程大約需要 4 個月
建議進度：2 小時/週
英語（English）
字幕：英語（English）
可分享的證書
完成後獲得證書
100% 在線課程
立即開始，按照自己的計劃學習。
靈活的計劃
設置並保持靈活的截止日期。
中級
You should have familiarity with the Excel user interface, moving around an Excel workbook, and creating basic formulas.
完成課程大約需要 4 個月
建議進度：2 小時/週
英語（English）
字幕：英語（English）
專項課程的運作方式
加入課程
Coursera 專項課程是幫助您掌握一門技能的一系列課程。若要開始學習，請直接註冊專項課程，或預覽專項課程並選擇您要首先開始學習的課程。當您訂閱專項課程的部分課程時，您將自動訂閱整個專項課程。您可以只完成一門課程，您可以隨時暫停學習或結束訂閱。訪問您的學生面板，跟踪您的課程註冊情況和進度。
實踐項目
每個專項課程都包括實踐項目。您需要成功完成這個（些）項目才能完成專項課程並獲得證書。如果專項課程中包括單獨的實踐項目課程，則需要在開始之前完成其他所有課程。
獲得證書
在結束每門課程並完成實踐項目之後，您會獲得一個證書，您可以向您的潛在雇主展示該證書並在您的職業社交網絡中分享。
此專項課程包含 3 門課程
Excel Time Series Models for Business Forecasting
92 個評分
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 Regression Models for Business Forecasting
42 個評分
This course allows learners to explore Regression Models in order to utilise these models for business forecasting. Unlike Time Series Models, Regression Models are causal models, where we identify certain variables in our business that influence other variables. Regressions model this causality, and then we can use these models in order to forecast, and then plan for our business' needs. We will explore simple regression models, multiple regression models, dummy variable regressions, seasonal variable regressions, as well as autoregressions. Each of these are different forms of regression models, tailored to unique business scenarios, in order to forecast and generate business intelligence for organisations.
Judgmental Business Forecasting in Excel
27 個評分
In this course, we extend your business forecasting expertise from the first two courses of our Business Forecasting Specialisation on Time Series Models and Regression Models. We will explore the role of judgmental forecasting, when more quantitative forecasting methods have limitations, and we need to generate further business insights. We will be exploring some structured methodologies to create judgmental business forecasts using Business Indicators, Subjective Assessment Methods, and Exploratory Methods. For each of these methods, we will look at how we can use Excel to help us in achieving these judgmental forecasts and how Excel can help us visualising our forecast findings. Being judgmental forecasting methods, we will also look at the role of biases in Business Forecasting,
提供方
麦考瑞大学
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.
常見問題
退款政策是如何规定的？
我可以只注册一门课程吗？
有助学金吗？
我可以免费学习课程吗？
此课程是 100% 在线学习吗？是否需要现场参加课程？
完成专项课程后我会获得大学学分吗？
完成专项课程需要多长时间？
What background knowledge is necessary?
Do I need to take the courses in a specific order?
What will I be able to do upon completing the Specialization?
還有其他問題嗎？請訪問 學生幫助中心。
