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
Click here to download the Excel template that goes with this video.
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.