Financial Modeling Quick Lesson: OFFSET / MATCH and Data Validation (Part 1)

Note: To download the Excel template that goes with this video, go to http://www.wallstreetprep.com/blog/fi...

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.

• #education
• #financial_modeling
• #offset
• #match
• #excel
• #data_validation
• #wall_streeet_prep
• #investment_banking
• #microsoft_excel_software