Excel Yourself/Budget Template (1.5 hrs)

Excel Budget Template

In this webinar recording I share a budget structure I have used successfully to create a budget that allows a couple of levels. This structure has some flexibility and incorporates a number of advanced Excel features that work well together. The budget template is scalable and can be applied to numerous scenarios.

The Budget Template session outcomes will include
 • discover a scalable, flexible Excel budget structure
 • learn formulas that can easily consolidate budgets from multiple sheets, making uploads into accounting systems easier
 • find out about a little-used function that can make allocations easier to create
 • see how to use tables to add structure and flexibility to your Excel files
 • a range name trick that involves formatted tables
 • adding validations to your budgets

As always, you will also pick up a few other tips and tricks along the way.

  • $25

Budget Template (1.5 hrs)

See how you can use a Budget Template to speed up the budget creation process. The techniques in this sessions work in all versions. Versions: All versions Recorded: Feb 2020 Level: Advanced Duration: 1.5 hours Price: AU$25

Contents

Course materials

The pdf manual plus the blank Excel file and the completed Excel file.
Excel Budget Template 2020.pdf
  • 495 KB
Budget_Template_2020
  • 125 KB
Budget_Template_completed_file
  • 192 KB
Budget_Template_Completed_TAS
  • 203 KB

Webinar Recording

Excel_Budget_Template.mp4
  • (1h 34m 24s)
  • 368 MB
Alterativee video if you have issues watching the above video

    Quizzes

    Quizzes: Part One
      Quizzes: Part Two