|
所在平台: Coursera专项课程 |
课程主页: https://www.coursera.org/specializations/excel-skills-for-business-forecasting
课程评论：没有评论
课程名称：商业预测的Excel技能 课程概述： 本课程旨在培养学员在商业预测方面所需的技能，包括财务数据分析、预测、微软Excel、商业分析、时间序列模型、商业预测和回归模型等。该专业课程由三个课程组成：时间序列模型、回归模型和判断性预测。 第一门课程《时间序列模型》将探讨如何利用时间序列数据集分析其不同成分，并根据这些成分应用相关模型来满足业务预测需求。 第二门课程《回归模型》则着重于建立包含时间序列数据和截面数据的因果模型。通过控制输入，因果模型能够帮助我们深入理解业务及制定战略。 在第三门课程《判断性商业预测》中，我们将研究在定量预测方法受到限制时，如何生成更深入的业务洞察。我们将探讨一些结构化的方法论来制定判断性商业预测，并学习Excel在这些判断中的应用。最后，通过案例研究将所有预测方法结合起来，让学员有机会生成预测，并作为组织规划的输入。 应用学习项目： 课程中，学员将使用与实际商业中遇到的数据集相似的数据，运用定量和定性预测技术生成商业预测。学员将创建图表以可视化数据和预测，计算模型误差，并运用优化技术最小化误差，选择最佳模型参数。同时，结合不同模型和专家判断，以处理不确定性。 证书：完成课程后将获得可分享的证书，课程完全在线，学习时间灵活，建议每周学习2小时，整体课程大约需时4个月完成。该课程要求学员对Excel用户界面有基本了解并能够进行基本公式的创建。 链接： - [时间序列模型](https://www.coursera.org/learn/excel-business-forecasting-time-series) - [回归模型](https://www.coursera.org/learn/excel-business-forecasting-regression) - [判断性预测](https://www.coursera.org/learn/judgmental-business-forecasting-in-excel)
Course Link: https://www.coursera.org/learn/excel-business-forecasting-time-series
Name:Excel Time Series Models for Business Forecasting
Description:Offered by Macquarie University. This course explores different time series business forecasting methods. The course covers a variety of ... Enroll for free.
Course Link: https://www.coursera.org/learn/excel-business-forecasting-regression
Name:Excel Regression Models for Business Forecasting
Description:Offered by Macquarie University. This course allows learners to explore Regression Models in order to utilise these models for business ... Enroll for free.
Course Link: https://www.coursera.org/learn/judgmental-business-forecasting-in-excel
Name:Judgmental Business Forecasting in Excel
Description:Offered by Macquarie University. In this course, we extend your business forecasting expertise from the first two courses of our Business ... Enroll for free.
Skills you will gain
Financial Data Analysis
Forecasting
Microsoft Excel
Business Analytics
Time Series Models
Business Forecasting
regression models
About this Specialization
4,463
recent views
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.
Applied Learning Project
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.
Shareable Certificate
Shareable Certificate
Earn a Certificate upon completion
100% online courses
100% online courses
Start instantly and learn at your own schedule.
Flexible Schedule
Flexible Schedule
Set and maintain flexible deadlines.
Intermediate Level
Intermediate Level
You should have familiarity with the Excel user interface, moving around an Excel workbook, and creating basic formulas.
Hours to complete
Approximately 4 months to complete
Suggested pace of 2 hours/week
Available languages
English
Subtitles: English
Shareable Certificate
Shareable Certificate
Earn a Certificate upon completion
100% online courses
100% online courses
Start instantly and learn at your own schedule.
Flexible Schedule
Flexible Schedule
Set and maintain flexible deadlines.
Intermediate Level
Intermediate Level
You should have familiarity with the Excel user interface, moving around an Excel workbook, and creating basic formulas.
Hours to complete
Approximately 4 months to complete
Suggested pace of 2 hours/week
Available languages
English
Subtitles: English
