FREE Webinar – Budget Challenge

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 my solution is simpler.

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

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

 

Date: February 13, 2020
Time: 1:00 PM AEDST
Event: FREE - Excel Budget Challenge
Topic: FREE - Budget Challenge
Public: Public
Registration: Click here to register.