Learn how to convert a budget into a multiple scenario budget.
Includes attendance at the live Webinar on 18 Feb 2025.
This sessions takes the budget from the Budget Challenge session and converts it into a multiple scenario solution.
Techniques shared:
the structure to make the conversion easier
using the OFFSET and MATCH functions to extract the correct scenario
helper cells to simplify formulas
keyboard shortcuts to speed up the conversion
finding cells based on colour
sheet grouping - useful but comes with a warning
data tables to capture the important metrics from each scenario
adding even more scenarios
As always there will be few general tips along the way.
The session covers
Global input and assumptions
Handling oncosts like Super and Payroll Tax
Including pay increases
Using check boxes in a budget
Using Conditional formats for warnings
Enabling start and end dates for employees
Handling overtime and annual leave
Custom functions
Validations
Functions: IF, IFERROR, ROUND, SUMIFS, COUNTIFS, OFFSET, VSTACK, HSTACK
Using range names