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

Project Finance: Free Online Course
→
Budget to Actual Variance Analysis in FP&A
→
Rolling Forecast Best Practices
→
Football Field Valuation: Video Instruction with Excel Template Download
→
Revolver Modeling
→
How to Build an Integrated 3 Statement Financial Model
→
Demystifying Financial Restructuring: Free Mini Course
→
Financial Modeling Best Practices
→
Excel IFS Function: Investment Banking Tutorial
→
The 100+ Excel Shortcuts You Need to Know (Windows and Mac)
→
1 2 3
Explore

Popular Topics

Accounting & Finance
265 Lessons & Guides
Valuation
80 Lessons & Guides
Investment Banking
64 Lessons & Guides
Venture Capital
54 Lessons & Guides
Industry Guides
52 Lessons & Guides
Career Guides
52 Lessons & Guides
Financial Modeling
44 Lessons & Guides
Mergers & Acquisitions
39 Lessons & Guides
Private Equity
33 Lessons & Guides
Excel
30 Lessons & Guides
Hedge Funds
30 Lessons & Guides
Restructuring
28 Lessons & Guides
Fixed Income
27 Lessons & Guides
Interview Prep
24 Lessons & Guides
Templates & Documents
18 Lessons & Guides
Sales & Trading
17 Lessons & Guides
PowerPoint
16 Lessons & Guides
Real Estate
13 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.