Call: 1300 768 368 or

Plum Solutions

Budgeting and Forecasting in Excel

Melbourne $880.00 AUD per person

Training Course Overview

Training Course ID: (PS)-00006

If you are new to the budgeting and forecasting process, this practical course will cover issues such as using budgets to measure staff performance, linking budgets to the strategic planning process and a comparison of budgeting techniques. We will explore the difference between budgets and forecasts, and you will learn how to create your own budget, rolling forecast, variance report and budget scenarios in Excel.









This course is delivered in two parts; the first day covers the theory of budgeting and forecasting within organisations. Issues such as budgeting to organisational objectives, level of granularity and selecting the correct budgeting tool will be discussed. Students are encouraged to share their own experiences with the class. On the second day, students will build their own budget and forecasting model to bring a practical application to the skills they have learned. The model will include a budget, rolling forecast, variance report as well as scenarios and sensitivity testing.

Duration
1 Day 9:00am - 5:00pm
Provider
Plum Solutions
Venue
Level 8, 500 Collins Street, Melbourne
Type
Public / Open

Detailed Course Information

    Part One: Budgeting and Forecasting Theory
  • Budgets and Strategic Planning
  • Using Budgets as Performance Management
  • Reporting
  • Budgeting Techniques
  • Limitations of budgets
  • Budgeting ""Soft"" Skills


  • Part Two: Budget and Forecast Modelling
  • Building a Budget
  • Building a Forecast
  • Reporting
  • Scenarios

This course is delivered in two parts; the first part of the day covers the theory of budgeting and forecasting within organisations. Issues such as budgeting to organisational objectives, level of granularity and selecting the correct budgeting tool will be discussed. Students are encouraged to share their own experiences with the class. In the second part of the day, students will build their own budget and forecasting model to bring a practical application to the skills they have learned. The model will include a budget, rolling forecast, variance report as well as scenarios and sensitivity testing.

Related Training Courses

Provider Terms & Condition

Plum Solutions

Plum Solutions delivers training in the following course categories

  • Financial Modeling
  • Financial Services

Plum Solutions Training Courses and Open Programs in Sydney, Melbourne and Brisbane, Australia. With Training Courses available in these categories:


Short Courses and In-House Training Programs:


Accounting & Taxation | Business Courses | Communication Skills | Financial Services

Call us to book on 1300 768 368

I need to
book training
for myself!

1  Select Dates

Friday, 30 May 2014
Friday, 15 Aug 2014
Tuesday, 11 Nov 2014

2  Add Attendees


View Payment Options

Payment Options

"Don't forget to add your donation to Tools for Schools at checkout"

A small donation will make a huge difference"

more info

I would like to
send this course
to a friend!
I need to
arrange training
for my team!

Request a Quote