Cheat sheet: the investment banking analyst's toolkit
- Free guide
- PDF · 4 pages

The essential Excel shortcuts (Windows and Mac), the colour-coding conventions of financial modelling and the analyst's go-to charts: football field, sensitivity table and waterfall chart.
This guide is currently available in French only: the download is the French version.
Preview · page 2 of 4
Keyboard reflexes and international modelling standards are what make an analyst operational from day one.
The Excel shortcuts you use all the time, on Windows and Mac: edit a cell, open the cell format, anchor references with $, insert an AutoSum, trace a calculation back to its source cells, repeat the last action.
The colour-coding conventions of modelling: blue for inputs and hard-coded assumptions, black for formulas and calculations within the sheet, green for links to another sheet in the workbook, red for external links and checks.
The full guide
All 4 pages as a PDF, free: your email address is all it takes.
By entering your email, you agree to receive the resources you requested and related communications from us. See our privacy policy.