Excel for Investment Banking
Excel is the primary tool used by investment banking analysts to build financial models, analyze companies, and prepare materials for client presentations. Most analysts spend a large portion of their day inside spreadsheets building discounted cash flow (DCF) models, leveraged buyout (LBO) models, and three-statement operating models. One of the biggest differences between analysts who struggle and those who thrive is how efficiently they work in Excel. Analysts who rely heavily on the mouse tend to work significantly slower than those who use keyboard shortcuts and efficient spreadsheet workflows. Over the course of a long deal process or busy week, these efficiencies can save hours of work.
See also: Learn the most useful Excel shortcuts for analysts
Excel Skills Required for Investment Banking
Investment banking analysts rely heavily on Excel for financial modeling, financial analysis, and preparing materials for client presentations.
On a typical day analysts are updating financial models, pulling financial statement data, formatting outputs for pitch books, and reviewing calculations across multiple worksheets.
Some of the most important Excel skills in investment banking include:
- Building financial models such as DCF models, LBO models, and merger models
- Navigating large spreadsheets quickly
- Selecting and formatting financial statement data
- Auditing formulas and tracing calculation errors
- Using keyboard shortcuts to work efficiently
Developing strong Excel habits early in your career makes it much easier to complete work efficiently under tight deadlines.
Workbook Shortcuts Used by Investment Banking Analysts
Investment banking analysts frequently work with multiple Excel workbooks at the same time — financial models, supporting schedules, and data exports.
Being able to quickly create, open, and save workbooks helps streamline daily workflows.
Common workbook shortcuts include:
Ctrl + O — Open an existing Excel workbook.
Ctrl + N — Create a new Excel workbook.
Ctrl + S — Save the current workbook.
Shift + F11 — Insert a new worksheet into the current workbook.
Analyst Tip: Analysts are constantly switching between Excel, PowerPoint, email, and research sources. Using Alt + Tab allows you to quickly switch between open applications without using the mouse.
Navigating Large Financial Models in Excel
Financial models used in investment banking often contain thousands of rows of data and many worksheets.
Efficient navigation allows analysts to move through models quickly when reviewing calculations or updating projections.
Common navigation shortcuts include:
Ctrl + Arrow Keys — Jump to the edge of a data region.
Ctrl + Home — Jump to the beginning of the worksheet (cell A1).
Home — Move to the beginning of the current row.
Analyst Tip: When auditing financial models, press Ctrl + G and choose Special → Formulas to jump directly to cells containing formulas. This makes it easier to review calculations in large spreadsheets.
Selecting Data Efficiently in Excel
Financial modeling often requires applying formulas and formatting across large sections of data.
Useful selection shortcuts include:
Shift + Arrow Keys — Expand a selection one cell at a time.
Ctrl + Shift + Arrow Keys — Select an entire data region instantly.
Ctrl + Space — Select an entire column.
Analyst Tip: Instead of dragging the mouse down hundreds of rows, analysts frequently use Ctrl + Shift + Arrow Keys to instantly select full ranges of financial data.
Excel Formatting Standards in Investment Banking
Investment banks follow consistent formatting conventions so financial models are easy to review and audit.
Common formatting standards include:
Blue (#0000FF) — Input assumptions
Black (#000000) — Formulas
Green (#00B050) — Links to other worksheets
Common formatting shortcuts include:
Ctrl + Shift + 1 — Apply comma formatting to numbers.
Ctrl + Shift + 5 — Apply percentage formatting.
Ctrl + B — Bold headers and key outputs.
Analyst Tip: Use Ctrl + 1 to open the Format Cells menu when applying accounting formats, decimals, or currency formatting.
Excel Shortcuts for Financial Modeling
Financial modeling requires constant formula editing and auditing.
Common shortcuts used by analysts include:
F2 — Edit formulas directly inside a cell.
Alt + = — Insert an AutoSum formula.
Ctrl + ` — Toggle formula view to show formulas instead of values.
Analyst Tip: Using Ctrl + ` allows analysts to quickly scan a spreadsheet and identify incorrect references or hardcoded numbers when reviewing financial models.
Financial Modeling Best Practices in Excel
Beyond shortcuts, good modeling discipline is essential.
Separate Inputs from Calculations
Keep assumptions separate from formulas so projections can be updated easily.
Avoid Hardcoding Numbers
Always reference cells instead of typing numbers directly into formulas.
Use Consistent Formatting
Consistent formatting helps other analysts understand the model structure.
Audit Calculations Frequently
Use Excel auditing tools to verify formulas and trace calculation dependencies.
Improving Excel Skills for Investment Banking
The fastest way to improve Excel proficiency is through deliberate practice.
Instead of memorizing lists of shortcuts, analysts improve by repeatedly practicing real spreadsheet tasks until shortcuts become automatic.
Xcel Hotkeys provides short drills designed to train the Excel shortcuts used in financial modeling and investment banking workflows.
Frequently Asked Questions
Related Training
Ready to Get Faster?
Start practicing with hands-on Excel drills designed for financial professionals.