Search

29 September 2020

Forecasting, planning and budgeting techniques - with Excel

Category: MASTER COURSE

Learn the latest approaches to forecasting, planning and budgeting - and how to use spreadsheets to develop and combine them in order to get the most effective management information.

Who should attend?
Spreadsheet authors, managers, company advisers and other members of staff from all functional areas needing to further their Excel skills in developing departmental forecasts, plans or budgets. This course will help anyone wishing to gain more practical experience in Excel reporting and using statistical data.

What you will gain

  •  Knowledge of a variety of approaches to forecasting, planning and budgeting
  •  Hands-on training in developing these management tools using spreadsheets
  •  Tips on how to combine these techniques for the most effective management information.
  •  An introduction to the use of advanced spreadsheet techniques

Programme outline
Forecasting, planning and budgeting as part of the management accounting function.

Modern quantitative methods used for forecasting

  • Regression analysis
  • Time series analysis
  • Expected value calculations

Planning techniques

  • The deterministic approach
  • Optimisation using the solver tool pack
  • What-if analysis and scenario manager
  • Working with data tables
  • Introduction to stochastic planning

Functions

  • Random number generator
  • Conditional / error
  • Forecast / slope / intercept
  • Array

Budgeting

  • Producing budgets
  • Consolidation options

An introduction to Excel dashboards

  • Creating a simple dashboard
  • Tips on how to present overview data on a front screen

Laptops with Excel will be provided on the course. 

Information for Online Live dates
Please read the following guidance carefully, which applies only if you are attending this course online:

  • In addition to the Online Classroom, you will need to have your own version of Excel open to complete the exercises
  • It does prove to be challenging to follow-on with the exercises using only 1 screen as you will need to be regularly switching between open windows. We recommend to either:
  • Extend from a computer to a 2nd screen - please refer to this link for guidance on how to correctly setup a second monitor https://support.microsoft.com/en-us/help/4340331/windows-10-set-up-dual-monitors or
  • Use 2 computers, or
  • Use a tablet for the online classroom and a computer for the Excel
  • Please note that our courses are based on Excel for Windows and it is recommended that you are using at least Excel 2010 or a later version. MAC users are welcome but please note that there may be some tools and functionality that will differ from what is being presented. The presenter will accommodate for MAC versions on the course.

The course starts at 9.30am. Lunch and refreshments are included.
6 CPD hours (where applicable). 

CIMA work in partnership with BPP Professional Education to offer CPD training courses

Booking Information

Date Location Price
29 September 2020 - 09:30 Online Live Price: GBP 634.00
Member price: £571. Plus VAT on all prices.
15 October 2020 - 09:30 Online Live Price: GBP 634.00
Member price: £571. Plus VAT on all prices.
11 December 2020 - 09:30 Online Live Price: GBP 634.00
Member price: £571. Plus VAT on all prices.


Related Events

17/11/2020 09:30:00

CFO of the future 4 - flexible planning and rolling forecasts

MASTER COURSE

  • Cost:
    GBP 634.00
    Member price: £571. Plus VAT on all prices.
  • Location:
    Online Live
  • Speaker(s):

Fourth of the CFO of the future series of five one day workshops. Learn how to break free from short-term targets and replace them with systems that enable the organisation to be more flexible. Book the series or choose individual workshops - it could be the defining moment in your career.

Find out more

17/11/2020 09:30:00

Better forecasting and budgeting

MASTER COURSE

  • Cost:
    GBP 634.00
    Member price: £571. Plus VAT on all prices.
  • Location:
    Online Live
  • Speaker(s):

Make your budgets work harder, and learn the value of rolling forecasts and performance measurement systems.

Find out more

Forecasting, planning and budgeting techniques - with Excel

CIMA members and students should log in to MY CIMA before booking to receive the appropriate discount.

Book Now

In-house training 
We can develop tailored training programmes to enhance the finance and business skills of staff across your organisation. To discuss how we can meet your learning and development needs please email us.

Find out more 
If you have any queries please email cima@bpp.com or phone us on: +44 (0)3300 603400.

The venue for this course will be confirmed 14 days before the scheduled date. 

CIMA work in partnership with BPP Professional Education to offer CPD training courses.  

This course will be delivered by BPP Professional Education Limited (“BPP”).  Accordingly, when you sign up for this course, CIMA will pass on the contact details you have provided to BPP so that they can contact you to complete your booking and process payment.  BPP will process any personal information it collects about you in accordance with its privacy policy, which is available at: https://www.bpp.com/professional-education/privacy

The information provided to BPP will not be used by BPP for marketing purposes.

CIMA on demand 

Our catalogue of online CPD training courses designed to fit around your schedule.

Get any 5 courses for just £99 +VAT - limited time only.  

Find out more