Excel Yourself/Advanced Excel Budgeting Techniques

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 will cover

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
These techniques could also be applied to forecasting and financial modelling.

Course Level: Advanced

Price: AUD25

  • $25

Advanced Excel Budgeting Techniques

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.pdf
  • 355 KB
Budgeting Examples
  • 148 KB
Budgeting Examples completed.xlsx
  • 173 KB

Webinar Recording

Excel Advanced Budgeting Techniques.mp4
  • (1h 08m 59s)
  • 270 MB

Quizzes

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