Forecasting and budgeting techniques with Excel online course
The course covers an insight into powerful and effective trending techniques for forecasting and budgeting and includes industry-standard Excel models which can be applied with any business data easily.
Price: £35 + VAT
BPP are currently in the process of moving to a new online system and therefore we ask in the interim that you email BPP (using the booking button above) to book your online course.
Overview
Spreadsheets are an almost universal tool for working in today’s businesses. Whether in a role as an accountant, support services, or analyst, Microsoft Excel provides the functionality to calculate, forecast, monitor, and model most processes.
Techniques for forecasting and budgeting are much talked about today, with a large part of the process being streamlined using modern-day Excel solutions as part of the management accounting role.
The course covers an insight into powerful and effective trending techniques for forecasting and budgeting and includes industry-standard Excel models which can be applied with any business data easily.
The course will aim to get you up to speed on forecasting terminology and techniques and help you identify ways to improve decision making in your organisation.
What you will gain
On completion of this course, you will have a greater understanding of:
- Modern quantitative techniques for forecasting
- Using trending functions (i.e. Forecast, Trend)
- A brief insight into statistical equations
- Discover ways to handle seasonality by using the new Classic Multiplicative Model
- Step by step approach to breaking down the data
- Understanding the jargon
- Producing a forecasted output
- Budgeting techniques using in-built solutions
- Scenario Manager to review budget value and impact
- Making more informed decisions on budgeting
Course content
- Forecasting – Part 1 – Excel Walkthrough (Introduction)
- Forecasting – Part 2 – Excel Walkthrough (Trends and forecasts)
- Budgeting – Part 1 – Excel Walkthrough (Introduction & Input Sheet)
- Budgeting – Part 2 – Excel Walkthrough (Expense budget example)
- Bonus Section – Seasonality
Questions?
BPP | Tel: 0330 060 3303 | Email: ldicas@bpp.com
