Class Central is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

Macquarie University

Judgmental Business Forecasting in Excel

Macquarie University via Coursera

Overview

Prepare for a new career with $100 off Coursera Plus
Gear up for jobs in high-demand fields: data analytics, digital marketing, and more.
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,

Syllabus

  • Welcome and Critical Information
    • 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,
  • Business Indicators
    • 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.
  • Subjective Assessment Methods
    • 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.
  • Exploratory Methods
    • 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.
  • Biases & Bringing All of Business Forecasting Together
    • 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.

Taught by

Dr Prashan S. M. Karunaratne

Reviews

4.5 rating at Coursera based on 45 ratings

Start your review of Judgmental Business Forecasting in Excel

Never Stop Learning.

Get personalized course recommendations, track subjects and courses with reminders, and more.

Someone learning on their laptop while sitting on the floor.