FREE Webinar – Budget Challenge – Subscription Version Only

In early November 2018 I became aware of a challenge to create a budget based on a scenario set by an academic who wanted to research various solutions to budgeting problems in Excel.

NOTE: This is not a beginner’s session.

The academic presented his findings in July 2019 and I have included his paper and his solution in the folder called Author in the materials. As far as I can see his results and mine match. I believe I have created a simpler solution.

The techniques presented only apply to the subscription version of Excel.

This webinar is based on a budget scenario which you need to read before the session starts. It is only 3 pages long.

Topics covered include

  • using the new SEQUENCE function
  • using the new dynamic arrays
  • a workaround for dynamic arrays and dates
  • new functions to add up dynamic array columns
  • using INDEX-MATCH (better alternative to VLOOKUP)
  • 3-D formulas and techniques to make using them easy
  • using a reporting template
  • validations
  • extracting sheet names
  • automating reports
  • preparing for scenarios

As always there will be a few other tips and tricks shared along the way.

Date: 13/02/2025
Time: 1:00 PM AEDST
Event: FREE - Excel Budget Challenge - Subscription Version Only
Topic: FREE - Budget Challenge
Public: Public
Registration: Click here to register.