Forecasting and Planning

Excel What-If, Scenarios, and Monte Carlo Analysis
Course Created by Bill Jelen
Host of MrExcel.com website. Microsoft MVP in Excel for 10 years. Author of 43 books about Microsoft Excel and a frequent speaker at accounting conferences.

  •   Lifetime access to all lessons!
  •   30 days money back guarantee!
  •   Accessible via iPhone, iPad and Android (soon!)

The tools for forecasting and planning are right on your desktop - in Microsoft Excel. Although most people never use Excel for regression, what-if, and scenarios, it has a robust set of powerful tools at your disposal.
This course will show you how to use these tools:  Straight-Line Regression. Multiple Regression. Goal Seek. Data Tables for 2-Variable Scenarios. The Scenario Manager for 3-variable Scenarios. You will also be able to download MrExcel's Monte Carlo add-in to easily handle 20-variable scenarios. 

Course Objectives

  • Build forecasting models using regression
  • Back into an answer using Goal Seek
  • Create scenarios with 2, 3, or 20 input cells

Who Is This For?

  • Managerial Accountants
  • Director of Planning & Analysis
  • CFO
  • Data Analysts Who Answer to Any of the Above!

Course Outline

Chapter 1: Introduction

  • Lesson 1
    01-Intro
    01:11

Chapter 2: Forecasting with Excel

  • Lesson 2
    Forecasting with Straight L…
    04:56
  • Lesson 3
    Multiple Regression Analysis
    05:56

Chapter 3: What-if Scenarios in Excel

  • Lesson 4
    Goal Seek
    02:28
  • Lesson 5
    What-If Table
    05:56
  • Lesson 6
    Scenario Manager
    08:00
  • Lesson 7
    Monte Carlo Tool
    03:46

Chapter 4: Build a Top-Side Model

  • Lesson 8
    Top Side Model Using Linked…
    06:48
  • Lesson 9
    Budget worksheets using IND…
    06:30

Chapter 5: Creating a Pivot Table Report for Each Cost Center

  • Lesson 10
    Pivot Table Report for Each…
    09:04

Chapter 6: Wrap Up

  • Lesson 11
    16-WrapUp
    01:37

  •   Lifetime access to all lessons!
  •   30 days money back guarantee!
  •   Accessible via iPhone, iPad and Android (soon!)