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,
Judgmental Business Forecasting in Excel
This course is part of Excel Skills for Business Forecasting Specialization
Instructor: Dr Prashan S. M. Karunaratne
Sponsored by Coursera Learning Team
3,455 already enrolled
(55 reviews)
Recommended experience
Skills you'll gain
Details to know
Add to your LinkedIn profile
14 assignments
See how employees at top companies are mastering in-demand skills
Build your subject-matter expertise
- Learn new concepts from industry experts
- Gain a foundational understanding of a subject or tool
- Develop job-relevant skills with hands-on projects
- Earn a shareable career certificate
Earn a career certificate
Add this credential to your LinkedIn profile, resume, or CV
Share it on social media and in your performance review
There are 5 modules in this course
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,
What's included
2 videos4 readings1 discussion prompt
In this topic, we will explore the role that Business Indicators can play in creating business forecasts, in particular to make judgments on the cyclical component, via predicting turns in the business cycle. We will then look at how Excel can help us execute these insights into business forecasts.
What's included
3 videos2 readings4 assignments
In this topic, we will be exploring 3 different Subjective Assessment Methods for judgmental forecasting. These are structured methodologies to follow when creating judgmental forecasts. We will be looking at the Sales Force Composite Method, the Jury of Executive Opinion, and Subjective Probability Assessments. We will then look at how Excel can assist in executing these methodologies.
What's included
3 videos2 readings4 assignments1 peer review
In this topic, we will be exploring 2 different Exploratory Methods for judgmental forecasting. These are structured methodologies to follow when creating judgmental forecasts. We will be looking at the Delphi Method and Scenario Analysis. We will then look at how Excel can assist in executing these methodologies.
What's included
3 videos2 readings4 assignments1 peer review
In this topic, we will reflect on the biases that can occur when conducting business forecasts. Then, we will be bringing all the topics together in a case study based assessment, where you will need to apply the principles of judgment to decide the forecasting method used, and utilise judgmental forecasting.
What's included
1 video4 readings2 assignments
Instructor
Offered by
Why people choose Coursera for their career
Learner reviews
55 reviews
- 5 stars
70.90%
- 4 stars
16.36%
- 3 stars
5.45%
- 2 stars
3.63%
- 1 star
3.63%
Showing 3 of 55
Reviewed on Nov 5, 2024
This course gives me the right tools to deal with people for an analyst or WFM staff.
Recommended if you're interested in Business
University of Illinois Urbana-Champaign
University of Pennsylvania
Rice University
Unilever
Open new doors with Coursera Plus
Unlimited access to 10,000+ world-class courses, hands-on projects, and job-ready certificate programs - all included in your subscription
Advance your career with an online degree
Earn a degree from world-class universities - 100% online
Join over 3,400 global companies that choose Coursera for Business
Upskill your employees to excel in the digital economy