Login
Self-Study Courses
Public Boot Camps
Corporate Training
On-Campus Training
WSP Consulting
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 shortcuts for Excel 2016 for both Windows and Mac. If there ... 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 the full context of a company's ... 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 used in this video
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 create an even more useful “super” ... 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.
