- 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
提供:
習得するスキル
この専門講座について
応用学習プロジェクト
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.
You should have familiarity with the Excel user interface, moving around an Excel workbook, and creating basic formulas.
You should have familiarity with the Excel user interface, moving around an Excel workbook, and creating basic formulas.
専門講座の仕組み
コースを受講しましょう。
Courseraの専門講座は、一連のコース群であり、技術を身に付ける手助けとなります。開始するには、専門講座に直接登録するか、コースを確認して受講したいコースを選択してください。専門講座の一部であるコースにサブスクライブすると、自動的にすべての専門講座にサブスクライブされます。1つのコースを修了するだけでも結構です。いつでも、学習を一時停止したり、サブスクリプションを終了することができます。コースの登録状況や進捗を追跡するには、受講生のダッシュボードにアクセスしてください。
実践型プロジェクト
すべての専門講座には、実践型プロジェクトが含まれています。専門講座を完了して修了証を獲得するには、成功裏にプロジェクトを終了させる必要があります。専門講座に実践型プロジェクトに関する別のコースが含まれている場合、専門講座を開始するには、それら他のコースをそれぞれ終了させる必要があります。
修了証を取得
すべてのコースを終了し、実践型プロジェクトを完了すると、修了証を獲得します。この修了証は、今後採用企業やあなたの職業ネットワークと共有できます。

この専門講座には3コースあります。
Excel Time Series Models for Business Forecasting
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
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
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 University)
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つのコースだけに登録することは可能ですか?
学資援助はありますか?
無料でコースを受講できますか?
このコースは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?
さらに質問がある場合は、受講者ヘルプセンターにアクセスしてください。