Welcome to Wall Street Prep! Use code at checkout for 15% off.

Wall Street Prep
Free Lessons and Guides

Excel

Excel is the day to day workhorse of finance professionals. Below we provide a list of lessons, tips and shortcuts to get you comfortable with spreadsheets.

View Our Full Excel Crash Course

Related Topics
Most Viewed
The 100+ Excel Shortcuts You Need to Know (Windows and Mac)

Excel shortcuts are a fundamental component of efficient financial modeling. Quite simply, it's well worth the time to learn them. Here, Wall Street Prep has compiled the most ...

→
Football Field Valuation: Video Instruction with Excel Template Download

One of the most common slides in an investment banking pitchbook is the football field. The football field is a floating bar chart in Excel that puts several valuation analyse ...

→
Excel IFS Function: Investment Banking Tutorial

In the video below, we will introduce you to the Excel 2016 IFS function - an exciting new features that makes writing nested IF statements much more efficient. Click here to ...

→
Index & Match

In a prior post, I discussed scenario analysis using the OFFSET function. Today I would like to introduce you to two useful formulas, the “Index” and “Match” functions, which ...

→
What's New

Latest Excel Content

Modified Internal Rate of Return (MIRR)
→
XIRR Function
→
Protect Excel Worksheet
→
Macro Recorder in Excel VBA
→
Excel LAMBDA Function
→
RIP INDEX MATCH? Example Where XLOOKUP Loses
→
Using XLOOKUP to Generate Multiple Values
→
Scenario Analysis Using XLOOKUP [VIDEO]
→
Nested (Two-Way) XLOOKUP vs Index Match
→
XLOOKUP in Excel: Comparison to VLOOKUP and Index Match
→
1 2 3
Explore

Popular Topics

Accounting & Finance
273 Lessons & Guides
Valuation
81 Lessons & Guides
Investment Banking
64 Lessons & Guides
Venture Capital
55 Lessons & Guides
Career Guides
52 Lessons & Guides
Industry Guides
51 Lessons & Guides
Mergers & Acquisitions
46 Lessons & Guides
Financial Modeling
45 Lessons & Guides
Private Equity
36 Lessons & Guides
Hedge Funds
30 Lessons & Guides
Excel
30 Lessons & Guides
Restructuring
28 Lessons & Guides
Fixed Income
27 Lessons & Guides
Interview Prep
24 Lessons & Guides
Templates & Documents
18 Lessons & Guides
Real Estate
17 Lessons & Guides
Sales & Trading
17 Lessons & Guides
PowerPoint
16 Lessons & Guides
Project Finance
13 Lessons & Guides
Compensation
10 Lessons & Guides
Equity Research
8 Lessons & Guides
X

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.