Join 750k+ learners today. Learn online from Wall Street Prep — the training firm that prepares new hires at the world's top financial institutions.

Enroll Today

Part of the Guide On...

Excel Part of the Guide On:
Excel

Excel Shortcuts + Formatting

Excel Shortcuts Cheat Sheet Adjust Column Width Center Across Selection Unhide Columns Highlight Duplicate Values Percent Change How to Protect a Worksheet in Excel Macro Recorder in Excel VBA

Financial Excel Functions

PV Function FV Function PMT Function IPMT Function PPMT Function Loan Amortization Schedule MIRR Function RATE Function RRI Function XIRR Function XNPV Function YIELD Function

Statistical Excel Functions

COUNTA Function COUNTIF Function COUNTIFS Function

Logical Excel Functions

SUMIF Function SUMIFS Function Excel IFS Function IFERROR Function

Math Excel Functions

SUMPRODUCT Function

Look-Up and Reference Excel Functions

Date Excel Functions

EDATE Function EOMONTH Function TODAY Function YEARFRAC Function

Excel What-if Analysis

Goal Seek Function Sensitivity Analysis (“What If” Analysis)

Excel LAMBDA Function

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 1 of this Quick Lesson

Click here to download the Excel template that goes with this video.

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.

First Name *

Last Name *

Email *

Questions? Call us at 617-314-7685

Self-Study
Boot Camps
On-Campus
Corporate
Free Training & Articles
Support
About Us
Careers
Terms
Privacy