Scenario Management WITH Excel
Learn about accurate scenario management using single or multiple variables in Excel. We’ll teach you how to analyse scenarios and all about goal seeking.
Considering outcomes, calculating every variable and dealing with all the doubt, it’s enough to make you wish for a magic crystal ball. Alas…we haven’t found one yet, and the prospect of accurate scenario management is enough to fill most people with a sense of dread. Luckily, we’ve found the formulas and functions in Excel that allow you to calculate the outcome of different scenarios with a few simple clicks of the mouse.
In this interactive workshop, we’ll cover the various ways in which you can approach scenario management. Scenarios can be based on just a single changing variable or as many as you like. Perhaps you know the results you want to achieve but need to know what input values this requires. We’ll go through the different options based on several examples and time for practice will be provided.
What You’ll Learn
- how to simulate different scenarios
- execute scenario analyses in an efficient way
- how to use single or multiple variables in Excel
- how to use Excel for goal seeking
- numerous tips & tricks in Excel
- practitioners who need to analyse large amounts of data
- M&A lawyers
- competition lawyers
Céline Tytgadt is a former financial analyst. For 15 years Céline worked for firms where she managed large amounts of data. The more she learned about Excel, the faster she was able to deliver results. Deciding to delve deeper into the programme, Céline ended up going freelance so she would be able to share her love for the endless possibilities Excel provides. Her mission is to eliminate time-consuming manual tasks in Excel.
Céline teaches in English & Dutch.