Become an Excel “Power User.” Used to train new hires at top financial institutions around the world!
Quick Lesson: 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.
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:
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.