In this video, I’ll show you how to integrate scenarios into financial models. We’ll do this by building a drop down menu in Excel using data validation and connecting the drop down menu to the scenario analysis using the OFFSET / MATCH function.
Click here to go to Part 2 of this Quick Lesson.
Before we begin: Get the Excel template file
Use the form below to get the Excel template file used in this lesson: