- 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
제공자:
귀하가 습득할 기술
이 전문 분야 정보
최근 조회 3,586회
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시간
영어
자막: 영어
공유 가능한 수료증
완료 시 수료증 획득
100% 온라인 강좌
지금 바로 시작해 나만의 일정에 따라 학습을 진행하세요.
유연한 일정
유연한 마감을 설정하고 유지 관리합니다.
중급 단계
You should have familiarity with the Excel user interface, moving around an Excel workbook, and creating basic formulas.
완료하는 데 약 4개월이 걸립니다
권장 학습 속도: 주 2시간
영어
자막: 영어
특화 과정 이용 방법
강좌 수강
Coursera 특화 과정은 한 가지 기술을 완벽하게 습득하는 데 도움이 되는 일련의 강좌입니다. 시작하려면 특화 과정에 직접 등록하거나 강좌를 둘러보고 원하는 강좌를 선택하세요. 특화 과정에 속하는 강좌에 등록하면 해당 특화 과정 전체에 자동으로 등록됩니다. 단 하나의 강좌만 수료할 수도 있으며, 학습을 일시 중지하거나 언제든 구독을 종료할 수 있습니다. 학습자 대시보드를 방문하여 강좌 등록 상태와 진도를 추적해 보세요.
실습 프로젝트
모든 특화 과정에는 실습 프로젝트가 포함되어 있습니다. 특화 과정을 완료하고 수료증을 받으려면 프로젝트를 성공적으로 마쳐야 합니다. 특화 과정에 별도의 실습 프로젝트 강좌가 포함되어 있는 경우, 다른 모든 강좌를 완료해야 프로젝트 강좌를 시작할 수 있습니다.
수료증 취득
모든 강좌를 마치고 실습 프로젝트를 완료하면 취업할 때나 전문가 네트워크에 진입할 때 제시할 수 있는 수료증을 취득할 수 있습니다.
이 전문 분야에는 3개의 강좌가 있습니다.
Excel Time Series Models for Business Forecasting
57개의 평가
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
19개의 평가
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
15개의 평가
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?
궁금한 점이 더 있으신가요? 학습자 도움말 센터를 방문해 보세요.
