Login
Self-Study Courses
Virtual Boot Camps
Corporate Training
On-Campus Training
Free Articles & Videos
Support/Contact Us
About Wall Street Prep
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.
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
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
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
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
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.
