Forecasting & Budgeting Techniques with Excel

Summary:

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.

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.

Learning Outcomes:

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

 

Authored by: Pratish Sharma

With 20 years of experience in building information systems for businesses, Pratish Sharma helps organisations around Europe to improve their technical skills and streamline data processes. He also presents courses on a variety of technical subjects based on industry trends. This includes helping people to save time and resources in analysing large volumes of data and translate their findings into modelled solutions that anyone can use to gain more data insight.

 

A CPD certificate of completion will be provided by BPP Professional Education Limited upon successful completion of the online course.

CPD Points: 1

CPD Duration (hours): 1

Access: 12 months from purchase date

Price: £30.00 (excludes VAT)
Quantity: