In January 2019 I presented a webinar that examined a solution to a 4 dimension budget challenge. Download the materials using the button below and watch the video.
CPD note – if you are claiming CPD for watching this recording you need to keep your own records. People who attend the live sessions receive an annual listing of attendances.
NOTE: This is not a beginner’s session.
This webinar is based on a budget scenario which you need to read before the session starts. It is only 3 pages long and included in the materials.
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 are a few more tips and tricks shared in the session.
Please note: I reserve the right to delete comments that are offensive or off-topic.