Budget Bundle 2025 - Complete

Excel Yourself/Budget Bundle 2025 - Complete

Budget Bundle 2024 - over 9 hours of video

This bundle includes all six of my budget sessions plus a bonus 30 minute video about handling and reporting on scenarios. You can see all sessions listed below.

February 2024 - All six budget courses have been updated to include dynamic arrays.

The bundle includes courses for ALL Excel versions new and old.

Session Overviews

Budget Challenge (free) - has a solution to a challenge from late 2018. It includes some advanced concepts. Not a beginners session.

Advanced Budget - looks at allocations, inflation, range names and the INDIRECT function.

Budget Template - session includes a flexible structure that I have used successfully in a number of budgets.

Three Statement Budget - shows how to integrate the P&L, Balance Sheet and Cash Flow.

Budgets and Power Query - demonstrates how to solve two common budgeting issues with Power Query - centralised linking and budget consolidation.

Budget Payroll - see how to handle overtime, annual leave, oncosts and may other payroll related issues.

Buy the Budget Bundle AU$160

$160

Budget Bundle 2025 - Complete

Old & New Excel Versions Learn advanced techniques + see how to build a Budget Template. See how to use Power Query to simplify + automate + compile a budget from multiple files. Includes a payroll budget course + a three statement budget built with dynamic arrays. Bundle includes bonus content not seen in the live webinars. Versions: All versions include old and new Level: Advanced Duration: 9+ hours Price: AU$160

Contents

$25

Advanced Budgeting Techniques 2024

Discover how to build in row level selections into your budget. Incorporate Excel's new dynamic arrays in your budget. Techniques covered include - range names - logic calculations involving TRUE and FALSE - check boxes and how to turn off features - the INDIRECT function - dynamic arrays - creating a custom function example Version: Microsoft 365 Recorded: Feb 2024 Level: Advanced Duration 1 hour Price: AU$25

$25

Advanced Excel Budgeting Techniques

Discover how to build in row level selections to your budget. Version: All versions Recorded: Feb 2020 Level: Advanced Duration 1 hour Price: AU$25

$25

Bonus Budget Video - Handling Scenarios

$25

Budget and Power Query 2024

See how to solve two budget issues with Power Query. Power Query can ensure all files have the same inputs and it can automate the budget consolidation process. Version: All Versions Recorded: Feb 2024 Level: Advanced Duration: 1 hour Price: AU$25

$25

Budget and Power Query 2025

See how to solve two budget issues with Power Query. Power Query can ensure all files have the same inputs and it can automate the budget consolidation process. Version: All Versions Recorded: Feb 2025 Level: Advanced Duration: 1 hour Price: AU$25

Free

Budget Challenge 2024 - Subscription version

This course is based on a budgeting challenge set by an academic. People from around the world entered. In this session I take you through a revision to my original solution which matched his results. This revised solution uses the subscription version of Excel and dynamic arrays - a new way to calculate in Excel. Version: Microsoft 365 Recorded: Feb 2024 Level: Intermediate to Advanced Duration: 1 hour Price: Free

Free

Budget Challenge - 2025 - Subscription version

This course is based on a budgeting challenge set by an academic. People from around the world entered. In this session I take you through a revision to my original solution which matched his results. This revised solution uses the subscription version of Excel and dynamic arrays - a new way to calculate in Excel. Version: Microsoft 365 Recorded: Feb 2025 Level: Intermediate to Advanced Duration: 1 hour Price: Free

Free

Budget Challenge Solution

This course is based on a budgeting challenge set by an academic. People from around the world entered. In this session I take you through my solution which matched his results. Level: Intermediate to Advanced Duration: 1 hour Price: Free

$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

$25

Budget Template 2024 (1hr 45min)

See how you can use a Budget Template to speed up the budget creation process. This course uses new features and functions in the subscription version of Excel. Includes an extras video to cover the new functions in more depth. Version: Microsoft 365 Recorded: Feb 2024 Level: Advanced Duration: 1 hr 45 min Price: AU$25

$25

Budget Template 2025 (1 hr 45 min)

See how you can use a Budget Template to speed up the budget creation process. This course uses new features and functions in the subscription version of Excel. Includes an extras video to cover the new functions in more depth. Version: Microsoft 365 Recorded: Feb 2025 Level: Advanced Duration: 1 hr 45 min Price: AU$25

Free

Dynamic Arrays Introduction

Dynamic arrays are a game changer for creating formulas in Excel. This session introduces important concepts plus new symbols and functions to get you started using dynamic arrays. Version: Microsoft 365 Recorded: April 2024 Level: Intermediate Duration: 1 hour Price: Free

$25

Excel Budget and Power Query

See how to solve two budget issues with Power Query. Power Query can ensure all files have the same inputs and it can automate the budget consolidation process. Version: Old Version (pre-subscription) Level: Advanced Recorded; Feb 2020 Duration: 1 hour Price: AU$25

$25

Excel Budget Payroll

This session examines an existing payroll budget structure. Payroll is one of largest expenses in many organisations. Getting it right is an important step in the budget process. Often the payroll budget is separate to the main budget due to confidentiality issues. This payroll model handles up 250 staff & could be scaled further. Version: All Versions Recorded: Feb 2022 Level: Advanced Duration: 1 hour Price: AU$25

$25

Excel Budget Payroll 2024

This session examines an existing payroll budget structure. Payroll is one of largest expenses in many organisations. Getting it right is an important step in the budget process. Often the payroll budget is separate to the main budget due to confidentiality issues. This payroll model handles up 250 staff & can be scaled. Version: Microsoft 365 Recorded: Feb 2024 Level: Advanced Duration: 1.5 hours Price: AU$25

$25

Excel Budget Scenarios - 2025

Learn how to convert a single budget into a multiple scenario budget. Discover structures, techniques + shortcuts to make the conversion easier. See how to use data tables to capture the important metrics from each scenario. See how easy it is to add even more scenarios Version: Microsoft 365 Recorded: Feb 2025 Level: Advanced Duration: 1 hour Price: AU$25

$25

Three Statement Excel Budget

A three statement Budget. See how to integrate the Profit & Loss, Balance Sheet and Cash Flow. This session uses traditional Excel formulas and functions and works in all versions. Versions: All versions Recorded: Feb 2020 Level: Advanced Duration: 1 hour Price: AU$25

$25

Three Statement Excel Budget 2024

A three statement Budget built using dynamic arrays, Excel's new formula and function calculation engine. You need the subscription version of Excel for this session. See how to integrate the Profit & Loss, Balance Sheet and Cash Flow. Version: Microsoft 365 Recorded: Feb 2024 Level: Advanced Duration: 1 hr 15 min Price: AU$25

$25

Three Statement Excel Budget 2025

A three statement Budget built using dynamic arrays, Excel's new formula and function calculation engine. You need the subscription version of Excel for this session. See how to integrate the Profit & Loss, Balance Sheet and Cash Flow. Version: Microsoft 365 Recorded: Feb 2025 Level: Advanced Duration: 1 hr 15 min Price: AU$25