Overview

Learn how to convert a budget into a multiple scenario budget.

This session takes the budget from a Budget Challenge session and converts it into a multiple scenario solution.

Why you should Attend

Instead of saving multiple versions of your budget see how to keep all the scenarios in one place, easily accessible and compare the results?

Areas Covered in the Session

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
  

Who Will Benefit

• Accountants and Finance Staff