Monthly Subscription Starting at AED 99 + VAT

Judgmental Business Forecasting in Excel
  • Level Professional
  • Duration 10 hours
  • Course by Macquarie University
  • Offered by

About

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,

Modules

About the course

    • 2 Videos
    • 4 Readings
    • 1 Discussion
Show info about module content

1 Discussions

  • Set your goals and be successful

2 Videos

  • Excel Skills for Business Forecasting Introduction
  • Course introduction

4 Readings

  • Welcome to Judgmental Business Forecasting in Excel
  • Course goals and weekly learning objectives
  • Important information about versions and regions
  • Quizzes and Navigation

Introduction

    • 1 Videos
    • 1 Assignment
Show info about module content

1 Assignment

  • Business Indicators

1 Videos

  • Business Indicators

Practice Videos

    • 2 Videos
    • 1 Readings
    • 2 Assignment
Show info about module content

2 Assignment

  • Leading Indicators
  • Composite Leading Indicators

2 Videos

  • Leading Indicators
  • Composite Leading Indicators

1 Readings

  • Download the Week 1 workbook

Toolbox

    • 1 Readings
Show info about module content

1 Readings

  • Week 1 Toolbox - Business Indicators

Assessment

    • 1 Assignment
Show info about module content

1 Assignment

  • Week 1 Assessment

Introduction

    • 1 Videos
    • 1 Assignment
Show info about module content

1 Assignment

  • Subjective Assessment Methods

1 Videos

  • Subjective Assessment Methods

Practice Videos

    • 2 Videos
    • 1 Readings
    • 2 Assignment
Show info about module content

2 Assignment

  • The Sales Force Composite Method & the Jury of Executive Opinion
  • Subjective Probability Assessments

2 Videos

  • The Sales Force Composite Method & the Jury of Executive Opinion
  • Subjective Probability Assessments

1 Readings

  • Download the Week 2 workbook

Toolbox

    • 1 Readings
Show info about module content

1 Readings

  • Week 2 Toolbox - Subjective Assessment Methods

Assessment

    • 1 PeerReview
    • 1 Assignment
Show info about module content

1 Assignment

  • Week 2 Assessment

1 Peer Review

  • Subjective Assessment Methods

Introduction

    • 1 Videos
    • 1 Assignment
Show info about module content

1 Assignment

  • Exploratory Methods

1 Videos

  • Exploratory Methods

Practice Videos

    • 2 Videos
    • 1 Readings
    • 2 Assignment
Show info about module content

2 Assignment

  • The Delphi Method
  • Scenario Analysis

2 Videos

  • The Delphi Method
  • Scenario Analysis

1 Readings

  • Download the Week 3 workbook

Toolbox

    • 1 Readings
Show info about module content

1 Readings

  • Week 3 Toolbox - Exploratory Methods

Assessment

    • 1 PeerReview
    • 1 Assignment
Show info about module content

1 Assignment

  • Week 3 Assessment

1 Peer Review

  • Exploratory Methods

Biases in Judgmental Forecasting

    • 1 Videos
    • 2 Readings
    • 1 Assignment
Show info about module content

1 Assignment

  • Biases

1 Videos

  • Biases

2 Readings

  • The answers to the questions in the video
  • Biases - Visualisation and Check List

Toolbox

    • 1 Readings
Show info about module content

1 Readings

  • Week 4 Toolbox - Biases in Judgmental Forecasting

Case Study

    • 1 Readings
Show info about module content

1 Readings

  • Case Study

Assessment

    • 1 Assignment
Show info about module content

1 Assignment

  • Week 4 Assessment

Auto Summary

Enhance your business forecasting skills with the "Judgmental Business Forecasting in Excel" course. Dive into structured methodologies, including Business Indicators, Subjective Assessment, and Exploratory Methods. Learn to leverage Excel for generating and visualizing judgmental forecasts. Ideal for professionals seeking advanced insights beyond quantitative methods. Available on Coursera with Starter and Professional subscription options, this 600-minute course is perfect for those looking to refine their expertise in Business & Management.

Dr Prashan S. M. Karunaratne
Instructor

Dr Prashan S. M. Karunaratne