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

Excel Must Reads

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 important time-saving Excel shortcuts for both ... Read More

→

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 analyses side-by-side to provide clients with ... Read More

→

Investment bankers can now die and go to heaven: Meet the Excel 2016 IFS function

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 download the Excel file ... Read More

→

Financial Modeling Techniques: 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 can actually be combined to ... Read More

→