Training Courses
Course Categories

  • Home

  • Budgeting and Forecasting in Excel

Budgeting and Forecasting in Excel

Canberra

$770.00

Training Course ID: (PS)-10022

Overview: 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.

Training Course Details

Duration
1 Day 9am - 5pm
TypePublic / Open
Provider

Plum Solutions

CPD0
Venue

TBA by Plum Solutions

VersionIntermediate

Outlines

Training Course Outlines:

Course content includes:

Day one: Budgeting and Forecasting Theory

  • Budgets and Strategic Planning
  • Using Budgets as Performance Management
  • Reporting
  • Budgeting Techniques
  • Limitations of Budgets
  • Budgeting "Soft" Skills

Day Two: Budget and Forecast Modelling

  • Building a Budget
  • Building a Forecast
  • Reporting
  • Scenarios

Outcomes

Training Course Outcomes:

  • Use budgets to measure staff performance
  • Link budgets to the strategic planning process and compare 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.

Accreditations / Prerequisites
Course Accreditations:

Course Prerequisites:

This course is designed for users who use Excel fairly regularly, and are comfortable with using simple functions. It is assumed that the user will know how to create simple formulas, and link between workbooks.

Related Courses

Related Courses:

90 visited

People Visited:

90 people visited

BOOK THIS COURSE

Select Dates

The training supplier is currently updating new course schedules, please contact the mytraining.net team to register your interest at team@mytraining.net or please call 02 8998 4940

Add Attendees (Min 1 and Max 10)




Attendees x 0

Add To Cart

Selected Course Date:

Course Attendees:

PRICE / Person:

$770.00

You have no items in your shopping cart.

Recently Viewed

  1. BSB60607 Advanced Diploma of Project Management

  2. BSB51407 Diploma of Project Management - Master Class

  3. BSB41507 Certificate IV in Project Management

  4. BSB41507 Certificate IV in Project Management

  5. Bringing Business Solutions to Life

Compare Courses

You have no items to compare.


Copyright © 2012 mytraining.net Pty Limited. ABN 90 139 474 070 All Rights Reserved.