Andrei Pinter

Hands offthe mouse.

Excel keyboard shortcuts for investment banking

  1. IntermediateMove, select, edit and format without reaching for the mouse.
  2. AdvancedRibbon key tips, Paste Special, grouping, tracing and data tools.
  3. ExpertGo To Special, sensitivity tables, calculation modes and the sequences that chain it all.

Every shortcut a financial model needs, from your first week on the desk to the sequences senior analysts chain without looking. 180 shortcuts, ten worked sequences and the number formats that make an output page look finished. Windows first, because that's what the banks run. Switch to Mac any time.

Each key is shaded by how many shortcuts in this guide use it. Click a key to see them all.
A1
Level: AllCount: 0