Coursera Learning Team
Leadership Academy
Leadership Academy
Coursera logo
Log In
Coursera
Leadership Academy
Macquarie University
Judgmental Business Forecasting in Excel
  • About
  • Outcomes
  • Modules
  • Testimonials
  • Reviews
  • Recommendations
  1. Business
  2. Business Strategy
Macquarie University

Judgmental Business Forecasting in Excel

This course is part of Excel Skills for Business Forecasting Specialization

Assoc Prof Prashan S. M. Karunaratne

Instructor: Assoc Prof Prashan S. M. Karunaratne

Access provided by Coursera Learning Team

3,694 already enrolled

5 modules
Gain insight into a topic and learn the fundamentals.
4.5

(59 reviews)

Intermediate level

Recommended experience

Recommended experience

Intermediate level

You should be familiar with using Excel for quantitative business forecasting.

10 hours to complete
3 weeks at 3 hours a week
Flexible schedule
Learn at your own pace

5 modules
Gain insight into a topic and learn the fundamentals.
4.5

(59 reviews)

Intermediate level

Recommended experience

Recommended experience

Intermediate level

You should be familiar with using Excel for quantitative business forecasting.

10 hours to complete
3 weeks at 3 hours a week
Flexible schedule
Learn at your own pace
  • About
  • Outcomes
  • Modules
  • Testimonials
  • Reviews
  • Recommendations

Skills you'll gain

  • Exploratory Data Analysis
  • Probability & Statistics
  • Time Series Analysis and Forecasting
  • Regression Analysis
  • Business Metrics
  • Business Economics
  • Statistical Methods
  • Decision Making
  • Microsoft Excel
  • Forecasting
  • Data Analysis
  • Key Performance Indicators (KPIs)
  • Strategic Thinking

Details to know

Shareable certificate

Add to your LinkedIn profile

Assessments

14 assignments

Taught in English

See how employees at top companies are mastering in-demand skills

Learn more about Coursera for Business
 logos of Petrobras, TATA, Danone, Capgemini, P&G and L'Oreal

Build your subject-matter expertise

This course is part of the Excel Skills for Business Forecasting Specialization
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
Coursera 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

Coursera 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

2 videos•Total 2 minutes
  • Excel Skills for Business Forecasting Introduction•0 minutes•Preview module
  • Course introduction•1 minute
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

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

3 videos•Total 22 minutes
  • Business Indicators•9 minutes•Preview module
  • 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

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

3 videos•Total 18 minutes
  • Subjective Assessment Methods•5 minutes•Preview module
  • The Sales Force Composite Method & the Jury of Executive Opinion•7 minutes
  • Subjective Probability Assessments•5 minutes
2 readings•Total 15 minutes
  • Download the Week 2 workbook•5 minutes
  • Week 2 Toolbox - Subjective Assessment Methods•10 minutes
4 assignments•Total 85 minutes
  • Week 2 Assessment•45 minutes
  • Subjective Assessment Methods•15 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

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

3 videos•Total 18 minutes
  • Exploratory Methods•5 minutes•Preview module
  • The Delphi Method•6 minutes
  • Scenario Analysis•6 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

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

1 video•Total 8 minutes
  • Biases•8 minutes•Preview module
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

Instructor

Instructor ratings

Instructor ratings

We asked all learners to give feedback on our instructors based on the quality of their teaching style.

4.7 (12 ratings)
Assoc Prof Prashan S. M. Karunaratne
Assoc Prof Prashan S. M. Karunaratne
Macquarie University
30 Courses•1,447,396 learners

Offered by

Macquarie University

Offered by

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.

Why people choose Coursera for their career

Felipe M.
Learner since 2018
"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

59 reviews

  • 5 stars

    71.18%

  • 4 stars

    16.94%

  • 3 stars

    5.08%

  • 2 stars

    3.38%

  • 1 star

    3.38%

Showing 3 of 59

C
CF
4

Reviewed on Feb 9, 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.

S
SP
5

Reviewed on Nov 6, 2024

This course gives me the right tools to deal with people for an analyst or WFM staff.

View more reviews

Explore more from Business

  • M

    Macquarie University

    Excel Skills for Business Forecasting

    Specialization

  • M

    Macquarie University

    Excel Time Series Models for Business Forecasting

    Course

  • M

    Macquarie University

    Excel Regression Models for Business Forecasting

    Course

  • J

    Johns Hopkins University

    Business Analytics with Excel: Elementary to Advanced

    Course

Coursera Plus

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

Learn more

Advance your career with an online degree

Earn a degree from world-class universities - 100% online

Explore degrees

Join over 3,400 global companies that choose Coursera for Business

Upskill your employees to excel in the digital economy

Learn more

Coursera Footer

Technical Skills

  • ChatGPT
  • Coding
  • Computer Science
  • Cybersecurity
  • DevOps
  • Ethical Hacking
  • Generative AI
  • Java Programming
  • Python
  • Web Development

Analytical Skills

  • Artificial Intelligence
  • Big Data
  • Business Analysis
  • Data Analytics
  • Data Science
  • Financial Modeling
  • Machine Learning
  • Microsoft Excel
  • Microsoft Power BI
  • SQL

Business Skills

  • Accounting
  • Digital Marketing
  • E-commerce
  • Finance
  • Google
  • Graphic Design
  • IBM
  • Marketing
  • Project Management
  • Social Media Marketing

Career Resources

  • Essential IT Certifications
  • High-Income Skills to Learn
  • How to Get a PMP Certification
  • How to Learn Artificial Intelligence
  • Popular Cybersecurity Certifications
  • Popular Data Analytics Certifications
  • What Does a Data Analyst Do?
  • Career Development Resources
  • Career Aptitude Test
  • Share your Coursera Learning Story

Coursera

  • About
  • What We Offer
  • Leadership
  • Careers
  • Catalog
  • Coursera Plus
  • Professional Certificates
  • MasterTrack® Certificates
  • Degrees
  • For Enterprise
  • For Government
  • For Campus
  • Become a Partner
  • Social Impact
  • Free Courses
  • ECTS Credit Recommendations

Community

  • Learners
  • Partners
  • Beta Testers
  • Blog
  • The Coursera Podcast
  • Tech Blog
  • Teaching Center

More

  • Press
  • Investors
  • Terms
  • Privacy
  • Help
  • Accessibility
  • Contact
  • Articles
  • Directory
  • Affiliates
  • Modern Slavery Statement
  • Manage Cookie Preferences
Learn Anywhere
Download on the App Store
Get it on Google Play
Logo of Certified B Corporation
© 2025 Coursera Inc. All rights reserved.
  • Coursera Facebook
  • Coursera Linkedin
  • Coursera Twitter
  • Coursera YouTube
  • Coursera Instagram
  • Coursera TikTok
Coursera

Welcome back

New to Coursera?

Having trouble logging in? Learner help center