When you enroll in this course, you'll also be enrolled in this Specialization.
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
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,
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
Show info about module content
2 videos•Total 3 minutes
Excel Skills for Business Forecasting Introduction•1 minute
Course introduction•2 minutes
4 readings•Total 40 minutes
Welcome to Judgmental Business Forecasting in Excel•10 minutes
Course goals and weekly learning objectives•10 minutes
Important information about versions and regions•10 minutes
Quizzes and Navigation•10 minutes
1 discussion prompt•Total 15 minutes
Set your goals and be successful•15 minutes
Business Indicators
Module 2•2 hours to complete
Module details
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
Show info about module content
3 videos•Total 22 minutes
Business Indicators•9 minutes
Leading Indicators•7 minutes
Composite Leading Indicators•6 minutes
2 readings•Total 15 minutes
Download the Week 1 workbook•5 minutes
Week 1 Toolbox - Business Indicators•10 minutes
4 assignments•Total 80 minutes
Week 1 Assessment•30 minutes
Business Indicators•20 minutes
Leading Indicators•15 minutes
Composite Leading Indicators•15 minutes
Subjective Assessment Methods
Module 3•3 hours to complete
Module details
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
Show info about module content
3 videos•Total 18 minutes
Subjective Assessment Methods•6 minutes
The Sales Force Composite Method & the Jury of Executive Opinion•7 minutes
The Sales Force Composite Method & the Jury of Executive Opinion•10 minutes
Subjective Probability Assessments•15 minutes
1 peer review•Total 40 minutes
Subjective Assessment Methods•40 minutes
Exploratory Methods
Module 4•3 hours to complete
Module details
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
Show info about module content
3 videos•Total 19 minutes
Exploratory Methods•6 minutes
The Delphi Method•7 minutes
Scenario Analysis•7 minutes
2 readings•Total 15 minutes
Download the Week 3 workbook•5 minutes
Week 3 Toolbox - Exploratory Methods•10 minutes
4 assignments•Total 85 minutes
Week 3 Assessment•45 minutes
Exploratory Methods•15 minutes
The Delphi Method•10 minutes
Scenario Analysis•15 minutes
1 peer review•Total 40 minutes
Exploratory Methods•40 minutes
Biases & Bringing All of Business Forecasting Together
Module 5•2 hours to complete
Module details
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
Show info about module content
1 video•Total 8 minutes
Biases•8 minutes
4 readings•Total 40 minutes
The answers to the questions in the video•10 minutes
Biases - Visualisation and Check List•10 minutes
Week 4 Toolbox - Biases in Judgmental Forecasting•10 minutes
Case Study•10 minutes
2 assignments•Total 70 minutes
Week 4 Assessment•60 minutes
Biases•10 minutes
Earn a career certificate
Add this credential to your LinkedIn profile, resume, or CV. Share it on social media and in your performance review.
Instructor
Instructor ratings
Instructor ratings
We asked all learners to give feedback on our instructors based on the quality of their teaching style.
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.
"To be able to take courses at my own pace and rhythm has been an amazing experience. I can learn whenever it fits my schedule and mood."
Jennifer J.
Learner since 2020
"I directly applied the concepts and skills I learned from my courses to an exciting new project at work."
Larry W.
Learner since 2021
"When I need courses on topics that my university doesn't offer, Coursera is one of the best places to go."
Chaitanya A.
"Learning isn't just about being better at your job: it's so much more than that. Coursera allows me to learn without limits."
Learner reviews
4.5
63 reviews
5 stars
69.84%
4 stars
19.04%
3 stars
4.76%
2 stars
3.17%
1 star
3.17%
Showing 3 of 63
S
SP
5·
Reviewed on Nov 5, 2024
This course gives me the right tools to deal with people for an analyst or WFM staff.
M
MO
4·
Reviewed on Jun 30, 2025
I enjoyed the course. The flow of thoughts was structured to make a novice grasp the concepts.
C
CF
4·
Reviewed on Feb 8, 2025
Decent course. The material here is not as practical as the other two courses in this specialization. It is still worth spending the time to complete it though.
When will I have access to the lectures and assignments?
To access the course materials, assignments and to earn a Certificate, you will need to purchase the Certificate experience when you enroll in a course. You can try a Free Trial instead, or apply for Financial Aid. The course may offer 'Full Course, No Certificate' instead. This option lets you see all course materials, submit required assessments, and get a final grade. This also means that you will not be able to purchase a Certificate experience.
What will I get if I subscribe to this Specialization?
When you enroll in the course, you get access to all of the courses in the Specialization, and you earn a certificate when you complete the work. Your electronic Certificate will be added to your Accomplishments page - from there, you can print your Certificate or add it to your LinkedIn profile.
Is financial aid available?
Yes. In select learning programs, you can apply for financial aid or a scholarship if you can’t afford the enrollment fee. If fin aid or scholarship is available for your learning program selection, you’ll find a link to apply on the description page.