Welcome back to the Wall Street Prep Quick Lesson Series!
In the videos below, 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.
Ready to dive in? Before starting the videos below, be sure to download this lesson's Excel model template: OFFSET/MATCH Excel template.
OFFSET/MATCH, Video 1
OFFSET/MATCH, Video 2
The Wall Street Prep Quicklesson Series
7 Free Financial Modeling Lessons
Get instant access to video lessons taught by experienced investment bankers. Learn financial statement modeling, DCF, M&A, LBO, Comps and Excel shortcuts.