Date: | 18/02/2025 |
---|---|
Time: | 1.00 PM (AEDST) |
Event: | Excel Budget Scenarios |
Topic: | Budget Scenarios |
Public: | Public |
Registration: | Click here to register. |
Webinar Excel Budget Scenarios – Subscription Version
Price: $25.00 incl GST
Duration: 1 hour
Learn how to convert a budget into a multiple scenario budget.
This sessions takes the budget from the Budget Challenge session and converts it into a multiple scenario solution.
Techniques shared:
- the structure to make the conversion easier
- using the OFFSET and MATCH functions to extract the correct scenario
- helper cells to simplify formulas
- keyboard shortcuts to speed up the conversion
- finding cells based on colour
- sheet grouping – useful but comes with a warning
- data tables to capture the important metrics from each scenario
- adding even more scenarios
As always there will be few general tips along the way.