Date: | 25/02/2025 |
---|---|
Time: | 1:00 PM AEDST |
Event: | Three Statement Budget - Dynamic Arrays (1.25 hours) |
Topic: | Three Report Budget |
Public: | Public |
Registration: | Click here to register. |
Webinar – Three Statement Budget – Dynamic Arrays
Price: $25 incl GST
Duration: 1hr 15 min
This session examines how you can create a combined Profit & Loss, Balance Sheet and a Cash Flow budget.
This session uses the subscription version of Excel with dynamic arrays.
We will focus on reviewing existing formulas and structures.
The techniques covered include
- display and format techniques for budgets
- functions used EDATE, IF, SUMIFS, INDEX, MATCH
- dynamic array function used SEQUENCE
- using dynamic array formulas
- using centralised logic calculations
- different budget assumption calculations
- handling single or monthly assumptions
- getting a flexible starting position for the balance sheet
- using a workings sheet
- loan schedule
- handling GST
- validations that handle error cells
Plus I will share extra tips along the way.