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.

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.