Forecasting, Planning & Budgeting Techniques - with Excel
Pricing
Cost for BPP PD Members: £415 + VAT + 6 CPD Hours
(£599 + VAT for non BPP PD Members) Click Here for details of our membership scheme.)
Course level
Intermediate
Delegates
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 is open to anyone wishing to gain more practical experience in Excel reporting and making use of statistical data.
Course Content
This one day course offers hands-on training surrounding specific skills in Excel which help enhance forecasting and budgeting practices, as part of the management accounting function.
Learning outcomes include obtaining a greater understanding of:
- 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 toolpak
- The ‘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
- Create a simple dashboard
- Tips on how to present overview data on a front screen
"A CPD certificate of completion will be provided by BPP Professional Education Limited upon request, following attendance."
Course Dates
Location |
Dates |
Time |
Availability |
|
|
|
|
|
|
Manchester |
22 Oct 2020 |
9:30 AM - 4:30 PM |
Limited |
Book Now
|
|
|
|
|
|
London |
27 Oct 2020 |
9:30 AM - 4:30 PM |
Spaces |
Book Now
|
|
|
|
|
|
London |
17 Dec 2020 |
9:30 AM - 4:30 PM |
Limited |
Book Now
|