Spreadsheet Skills for Planning, Forecasting and Budgeting
description

About the course
Many spreadsheet users do not fully exploit the power of their software. Business forecasting, planning and budgeting are areas in which personal computers may be used by organizations. By developing spreadsheet models, the work required to produce forecasts can be dramatically reduced. Furthermore, these forecasts can be easily transferred to business plans that provide a guide to the overall performance of the firm. These plans may then in turn be readily developed into operating budgets.
By using the personal computer all of these forecasts, plans and budgets may be reviewed through extensive what-if analysis to find the key factors for management to monitor. In addition, today’s spreadsheets may be conveniently used to perform advanced techniques such as goal seeking, sensitivity analysis and risk models. 

Course Objectives

Upon completion of this course, participants will be able to:

• Navigate through the features and functions of Excel
• Have knowledge of a variety of approaches to forecasting, planning and budgeting
• Have the ability to develop these techniques on a spreadsheet
• Understand tips on how to combine these techniques to obtain the most effective management information
• Use of advanced spreadsheet techniques  
• Distinguish between data and output in spreadsheet architecture
• Analyze financial statements in order to plan ahead
• Build effective financial planning models
• Use forecasting techniques for budget preparation

TARGET PARTICIPANTS

This course is aimed at professionals who contribute to financial decision making. Participants with qualifications and or experience in accounting and finance will benefit from the new focus on building models and applying scenario's in financial planning.
This course is suitable to a wide range of professionals but will greatly benefit:

  • Business advisors, analysts & staff from all functional areas who need to advise, comment or develop business forecast plans and budgets
  • Planning Engineers
  • Strategic planners and Finance officers
  • Management Accountants
  •  Managers without formal financial qualifications

$3,500
  • Date 1 Oct. 4, 2021
  • Date 2 Oct. 8, 2021
  • Date 3 Oct. 18, 2021
  • Date 4 Oct. 22, 2021
  • Duration 1 week
  • Student 30
  • Level All level
Take this course
working hours
  • Monday 8:00 am - 6:00 pm
  • Tuesday 8:00 am - 6:00 pm
  • Wednesday 8:00 am - 6:00 pm
  • Thursday 8:00 am - 6:00 pm
  • Friday 8:00 am - 6:00 pm
  • Saturday Closed
  • Sunday Closed