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. |
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.