Excel Yourself/Advanced Budgeting Techniques 2023

Advanced Excel Budgeting Techniques

Excel is the main application used to create budgets for small to medium organisations. Even large organisations use it as part of their budget process.

You can create flexible budgeting models in Excel by combining its many built-in features with its various functions.

This course covers

How to
  • choose monthly allocation methods on a line by line basis
  • select different inflation rates to apply on a line by line basis
  • choose between percentage-based allocations or per unit allocations
  • turn inflation rates off and on at the click of a Check Box
  • use drop down lists for selecting options
  • create a flexible validation system
  • use dynamic arrays
These techniques could also be applied to forecasting and financial modelling.

Course Level: Advanced

Price: AUD25
Duration: 1 hour 

  • $25

Advanced Budgeting Techniques 2023

  • Closed

Discover how to build in row level selections to your budget. 

Contents

Course materials

The pdf manual and blank Excel file plus the Excel completed file.
Advanced Budgeting Techniques 2023 amended.pdf
Advanced Budgeting Techniques 2023.xlsx
Advanced Budgeting Techniques 2023 completed fixed.xlsx
Advanced Budgeting Techniques 2023 completed fixed 2.xlsx

Webinar Recording

Advanced Budgeting Techniques 2023 video - watch till the end

Quizzes

Test your knowledge of the course.
Quiz Part One
Quiz Part Two