All resources

Cheat sheet: the investment banking analyst's toolkit

  • Free guide
  • PDF · 4 pages
Cover: “La boîte à outils IB”, Excel, charts and conventions, keyboard keys and a chart

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.

Your complete prep is on the platform.

Structured lessons, a bank of answered questions, real interview reports and progress tracking, all in one place.