Financial Modeling Quick Lessons: Integrating Scenarios w/ OFFSET/MATCH (Part 1) [UPDATED] |
|
Note: To download the Excel template that goes with this video, go to http://www.wallstreetprep.com/blog/financial-modeling-quick-lesson-2-offset-match-and-data-validation-part-1/
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. |