What are the essential Excel add-ins and shortcuts every Investment Banker should know?

In investment banking, speed, accuracy, and formatting consistency are everything. Because mouse usage is a massive bottleneck, bankers rely heavily on specialized add-ins and keyboard-only navigation.

Essential Excel Add-Ins for Investment Bankers

• Macabacus : Widely considered the gold standard for financial modeling, error-checking, and rapid formatting. It standardizes fonts/colors, cycles cell coloring (blue for hardcodes, black for formulas), builds dynamic audit trails, and helps cleanly export Excel charts into PowerPoint.o11.ai+1
• Capital IQ or FactSet : Essential market data stream plugins. They allow bankers to pull live historical financials, pricing, comps, and transaction multiples directly into a spreadsheet via custom formulas (e.g., pulling enterprise value or revenue estimates on the fly).o11.ai
• Daloopa / o11 : Modern data and AI-driven automation add-ins increasingly used to auto-populate historical data, pull KPIs straight from SEC filings, or assist with generative modeling and rapid data entry.daloopa.com+1
• Excel Native ToolPak & Solver : Built-in utilities used for basic descriptive statistics, correlation matrices, and optimization/scenario-testing in complex valuation models.daloopa.com+1

Essential Investment Banking Shortcuts (No Mouse Required!)

Mastering these shortcuts allows you to build and audit models at lightning speed.

Navigation & Selection

1. Ctrl + Arrow Keys : Jump to the edge of a data region (skips empty cells instantly).
2. Ctrl + Shift + Arrow Keys : Highlight a continuous block of data.
3. Shift + Space / Ctrl + Space : Select an entire row or entire column.
4. Ctrl + - / Ctrl + Shift + + : Delete or insert selected rows/columns (combined right after row/column selection).
5. Ctrl + Page Up / Page Down : Switch back and forth between worksheet tabs.wallstreetoasis.com

Auditing & Formulas

1. F2 : Edit the active cell (crucial to see what formula components are linked where).
2. Ctrl + [ : Trace precedents (jump straight to the cells feeding into your current formula).
3. Alt + (Alt + Equals): Auto-sum a selected range immediately.
4. F4 : Toggle absolute/relative cell references (A1 vs A1) while writing a formula.
5. F9 : Calculate a specific highlighted portion of a formula to evaluate its intermediate value.

Formatting & Cleanup

1. Ctrl + 1 : Open the Format Cells dialog box (number formatting, borders, alignment).
2. Alt + H + O + I : Auto-fit column width so text/numbers aren't cut off or showing #####.
3. Alt + W + V + G : Toggle gridlines on or off for a clean, presentation-ready look.
4. Shift + F2 : Insert or edit a cell comment/note (used for sanity checks or footnote assumptions).
5. Alt + H + E + A : Clear all contents/formats in a selected cell or range.wallstreetoasis.com

Pro-tip: Set up a customized Quick Access Toolbar (QAT) via Alt + T + O to map your most frequently used actions (like font color cycling, borders, and center alignment) to simple Alt + [Number] keys.breakingintowallstreet.com

Would you like me to share a step-by-step guide on how to set up an optimized Quick Access Toolbar or dive deeper into auditing complex financial models using these shortcuts?

If you’re working in investment banking, the goal is less “know every Excel feature” and more build, audit, and modify models quickly without touching the mouse.

1. Add-ins & tools worth knowing

Tool	Priority	What bankers use it for
Power Query	⭐⭐⭐⭐⭐	Importing, cleaning, combining and refreshing large datasets
Power Pivot / Data Model	⭐⭐⭐⭐	Large datasets, relationships, PivotTables and financial analysis
Analysis ToolPak	⭐⭐	Regression, statistical analysis and other quantitative work
Solver	⭐⭐⭐	Optimization, capital structure / transaction scenarios and sensitivity-type problems
VBA / Macros	⭐⭐⭐⭐⭐	Automating repetitive banking workflows
Office Scripts	⭐⭐	Automation, particularly in Microsoft 365/web environments
Copilot in Excel	⭐⭐	Formula assistance, analysis and data manipulation—useful, but not a substitute for understanding the model

One important distinction: Power Query is no longer something you generally install as a separate add-in. It is integrated into modern Excel's Data → Get & Transform experience. Microsoft describes it as the primary Excel experience for importing and shaping data.Microsoft Support+1

Similarly, the Analysis ToolPak is a genuine Excel add-in that can be enabled through Excel's Add-ins settings.Microsoft Support

What I'd prioritize as a banker

Must know:

• Power Query
• VBA/macros
• PivotTables
• Data Tables
• Solver
• Named ranges
• Tables / structured references
• Power Pivot if you regularly handle large datasets

Nice to know:

• Analysis ToolPak
• Office Scripts
• Copilot

2. The essential investment-banking shortcuts

Assuming Excel for Windows, these are the ones I'd drill until they're muscle memory.

Navigation

Ctrl + G is particularly useful when you're jumping around a 50-sheet model. Microsoft documents it as Excel's Go To shortcut.Microsoft Support

Editing & formulas

F4 is critical.

For example:

=A1*B1

Press F4 while on a reference and Excel cycles through:

$A$1
A$1
$A1
A1

You'll use this constantly when building models.

3. The banking-specific shortcuts

These are arguably more valuable than generic Excel shortcuts.

Paste Special

Ctrl + Alt + V

Then:

• V → Values
• F → Formulas
• T → Formats
• E → Transpose
• D → Divide
• M → Multiply

Paste Special → Values is one of the most frequently used operations in financial modeling.

Insert/delete rows and columns

Ctrl + +
Ctrl + -

Depending on your keyboard, you may need the number-pad +/-.

Hide/unhide

Ctrl + 9     Hide rows
Ctrl + 0     Hide columns

Microsoft confirms these shortcuts for Excel.Microsoft Support

Formatting

Ctrl + 1     Format Cells
Ctrl + B     Bold
Ctrl + I     Italic
Ctrl + U     Underline

Ctrl + 1 is the big one for bankers.

You'll constantly use it for:

• Number formats
• Percentages
• Dates
• Currency
• Borders
• Alignment
• Font
• Protection

4. Formula auditing shortcuts

These become extremely important when you're reviewing someone else's model.

F2 + Ctrl+[ / Ctrl+] is an excellent combination for tracing a model quickly.

5. Financial-modeling formulas you should know cold

Shortcuts are only half the battle. A good banker should be extremely comfortable with:

Core

SUM
AVERAGE
MIN
MAX
COUNT
ROUND
ABS

Logic

IF
IFS
AND
OR
IFERROR

Lookups

XLOOKUP
INDEX
MATCH
XMATCH

I'd particularly learn XLOOKUP + INDEX/MATCH.

You will encounter older banking models using INDEX/MATCH for years, even though XLOOKUP is now extremely convenient.

Conditional aggregation

SUMIF
SUMIFS
COUNTIF
COUNTIFS
AVERAGEIF
AVERAGEIFS

Dates

YEAR
MONTH
DAY
EOMONTH
EDATE
YEARFRAC
NETWORKDAYS

These are essential for debt schedules, operating models, transaction models and valuation work.

Modern Excel

FILTER
SORT
UNIQUE
LET
CHOOSECOLS
TAKE
DROP

These can dramatically simplify newer models and analysis.

6. The shortcuts I'd memorize first

If you only have time to memorize 20, make them these:

F2                  Edit cell
F4                  Toggle absolute references
Ctrl + Arrow        Navigate data
Ctrl + Shift + Arrow Select data
Ctrl + D            Fill down
Ctrl + R            Fill right
Ctrl + 1            Format Cells
Ctrl + Alt + V      Paste Special
Ctrl + G            Go To
Ctrl + Page Up/Down Switch sheets
Ctrl + +            Insert
Ctrl + -            Delete
Ctrl + 9            Hide rows
Ctrl + 0            Hide columns
Alt + =             AutoSum
Ctrl + S            Save
Ctrl + Z            Undo
Ctrl + Y            Redo
Ctrl + [            Go to precedents
Ctrl + ]            Go to dependents

Microsoft maintains the full current shortcut reference, including Windows and Mac variations.Microsoft Support

7. Investment-banking Excel "muscle memory"

The real progression is:

Level 1 — Keyboard proficiency

Stop reaching for the mouse. Level 2 — Formula proficiency

Build formulas quickly and understand references. Level 3 — Modeling proficiency

Three-statement models, DCFs, LBOs, merger models, debt schedules. Level 4 — Audit proficiency

Trace formulas, identify hardcodes, find circularity, check assumptions and reconcile outputs. Level 5 — Automation

Power Query + VBA + Power Pivot to eliminate repetitive work. Power Query is particularly valuable here because queries can be refreshed after importing and transforming data, rather than repeatedly cleaning the same source manually.Microsoft Support+1

One practical rule

If you're starting investment banking, I'd spend far more time mastering shortcuts, formulas, formatting and modeling conventions than installing dozens of third-party add-ins. A banker who can build a clean three-statement model entirely from the keyboard is much more useful than someone with 15 add-ins but weak Excel fundamentals.

If you want, I can also give you a “Top 50 Excel shortcuts for investment banking” one-page cheat sheet, organized specifically around DCF, LBO, M&A and three-statement modeling.

In investment banking, Excel isn't just a program—it is your primary operational environment . To survive 100-hour workweeks, you need to keep your hands strictly on the keyboard (the mouse is enemy number one).o11.ai

Essential Investment Banking Add-Ins

• Macabacus or Peak Frameworks / ClusterSeven-style tools : Widely recognized as the kings of formatting, auditing, and cleanup. They standardize fonts, cycle hard-coded vs. formula colors, fix broken links, and build clean error-checking structures.
• S&P Capital IQ / FactSet / Bloomberg Add-ins : The lifelined data-streams. Used to pull live historical financial data, comps, pricing, and transaction metrics directly into models using proprietary formulas (e.g., CIQ or FactSet formulas).o11.ai
• Daloopa / o11 / AlphaSense Plugins : Modern AI and data extraction tools gaining immense traction for automating data entry, spreading financials, and rapidly parsing public filings into structured excel rows.daloopa.com+1

Critical Excel Shortcuts (No Mouse Allowed)

Navigation & Selection

1. Ctrl + Arrow Keys : Jump to the edge of a data region (up, down, left, right).
2. Ctrl + Shift + Arrow Keys : Highlight/select a contiguous block of data.
3. Ctrl + Space : Select an entire column.
4. Shift + Space : Select an entire row.
5. Ctrl + Page Up / Page Down : Switch between worksheet tabs.wallstreetoasis.com

Row & Column Manipulation

1. Ctrl + Shift + "+" : Insert rows or columns (after selecting a row/column via Spacebar shortcuts).
2. Ctrl + "-" : Delete selected rows or columns.
3. Alt + H + O + I : Auto-fit column width (pro-tip: map this or column width to your Quick Access Toolbar for a instant 2-keystroke shortcut).breakingintowallstreet.com+1

Auditing & Formulas

1. F2 : Edit the active cell.
2. Ctrl +[open bracket[ : Trace precedents (jump to the cell feeding the current formula).
3. Ctrl +]close bracket] : Trace dependents (find which cells rely on this formula).
4. F4 : Toggle absolute/relative cell references ($A$1) or repeat the last action.
5. Shift + F2 : Insert or edit a cell comment/note.wallstreetoasis.com

Formatting

1. Ctrl + 1 : Open the Format Cells dialog box.
2. Alt + H + B : Bring up border menus.
3. Alt + E + S + T : Paste formatting only (Paste Special → Formats).wallstreetoasis.com

Would you like me to share instructions on how to set up a high-speed Quick Access Toolbar (QAT) for formatting, or dive deeper into financial modeling layout standards (like standard color coding for inputs vs. formulas)?

If you're going into investment banking, Excel speed matters less because you know hundreds of shortcuts and more because you can build, audit, navigate, and format a model without reaching for the mouse.

Here’s the practical “must know” stack.

1. Excel add-ins & tools

Tier 1 — Learn these first

Tool	What bankers use it for	Priority
Macabacus	Financial-modeling shortcuts, formula auditing, formatting, Excel ↔ PowerPoint linking, templates	⭐⭐⭐⭐⭐
Power Query	Importing, cleaning, merging and refreshing messy data	⭐⭐⭐⭐
Power Pivot	Large datasets and relational financial analysis	⭐⭐⭐
Solver	Optimization / constrained scenarios	⭐⭐
Analysis ToolPak	Regression, statistics and other analytical work	⭐⭐
Inquire	Comparing/auditing workbooks and identifying spreadsheet differences	⭐⭐
VBA / Macros	Automating repetitive tasks	⭐⭐⭐⭐

Macabacus is the most specifically finance-oriented option. It provides 100+ customizable shortcuts, formula-auditing tools, financial-modeling tools, charting and Excel-to-PowerPoint functionality.Macabacus+1

macabacus.com

Power Query is increasingly useful when you're given raw company/market data that needs cleaning before it enters a model. Microsoft describes it as a tool for connecting to external data, transforming it, merging tables and refreshing the resulting data.Microsoft Support

Solver is useful for optimization problems involving an objective cell, variable cells and constraints.Microsoft Support

The Analysis ToolPak provides statistical tools such as regression, histograms and sampling.Microsoft Support

Important distinction

You do not need every add-in installed to be a good banking analyst.

I'd prioritize:

Macabacus → Power Query → VBA → Power Pivot → Solver/ToolPak/Inquire

And learn native Excel extremely well before relying on add-ins.

2. The Excel shortcuts every banker should know

I'm assuming Windows Excel, since that's the environment most commonly encountered in banking. Mac and Windows shortcuts differ substantially, particularly for ribbon commands.Wall Street Prep

Navigation

These should become muscle memory:

Ctrl + Arrow and Ctrl + Shift + Arrow are particularly important when you're navigating huge operating models.

3. Formula shortcuts

These are banker essentials.

F4 — Lock references

While editing a formula:

A1 → $A$1 → A$1 → $A1 → A1

This is essential when building forecasts and dragging formulas across periods.

Ctrl + [

Jump to the cells referenced by the current formula.

Extremely useful for auditing a model.

Ctrl + ]

Jump to cells that depend on the current cell.

Ctrl + ~

Toggle between:

formula view

and

calculated values

Excellent for quickly reviewing model logic.

Alt + =

AutoSum.

Ctrl + Shift + Enter

Historically important for array formulas; less important in modern Excel because dynamic arrays have largely replaced the old CSE workflow.

4. Paste Special

One of the highest-value skills in banking.

Ctrl + Alt + V

Opens Paste Special.Wall Street Prep

You should be comfortable with:

• Values
• Formats
• Formulas
• Transpose
• Multiply
• Divide

For example, if you have a column of numbers that needs to be converted from thousands to millions, you can use Paste Special → Divide rather than writing another formula.

5. Formatting shortcuts

Financial models involve a lot of formatting.

Know these:

But don't obsess over generic Excel formatting shortcuts. In banking, your firm may have a specific formatting convention or Macabacus-based formatting system.

6. Row/column manipulation

Learn these until they're automatic:

• Ctrl + Space → select entire column
• Shift + Space → select entire row
• Ctrl + + → insert
• Ctrl + - → delete
• Ctrl + 9 → hide rows
• Ctrl + 0 → hide columns
• Alt + = → AutoSum

And learn to use Group/Outline for large models.

7. The functions you actually need

Shortcuts aren't enough. For banking, I'd make sure you are extremely comfortable with:

Core

SUM
MIN
MAX
AVERAGE
COUNT
ROUND
ABS

Logic

IF
IFS
AND
OR
IFERROR

Lookup

XLOOKUP
INDEX
MATCH
XMATCH

You should understand both XLOOKUP and the traditional INDEX/MATCH, because you'll encounter older banking models.

Financial

NPV
XNPV
IRR
XIRR
PV
FV
PMT

Date

YEAR
MONTH
DAY
EOMONTH
EDATE
YEARFRAC

Text

LEFT
RIGHT
MID
LEN
FIND
SEARCH
TEXT
CONCAT
TEXTJOIN

Modern Excel

FILTER
SORT
UNIQUE
LET

8. Investment-banking-specific Excel skills

This is where Excel knowledge turns into banking Excel knowledge.

You should be able to build without much hesitation:

• 3-statement financial models
• DCFs
• Trading comps
• Precedent transactions
• Accretion/dilution analyses
• LBO models
• Debt schedules
• Sources & uses
• Purchase-price allocation
• Sensitivity tables
• Scenario analyses
• Operating forecasts
• Revenue / EBITDA bridges

And, critically, understand why the formulas work, not merely reproduce them.

9. Learn Data Tables & sensitivity analysis

This is particularly important for valuation.

Excel's What-If Analysis includes Data Tables, Goal Seek and Scenarios; Data Tables can evaluate one- or two-variable sensitivities, while Goal Seek works backward from a desired result to determine an input.Microsoft Support

For example:

              WACC
          8%    9%    10%   11%   12%
        --------------------------------
4.0%    |  ...   ...   ...   ...   ...
4.5%    |  ...   ...   ...   ...   ...
5.0%    |  ...   ...   ...   ...   ...
5.5%    |  ...   ...   ...   ...   ...

That kind of sensitivity table is much more relevant to an analyst than knowing obscure Excel functions.

10. VBA: learn enough to be dangerous

You don't need to become a software engineer.

But you should understand:

• Recording a macro
• Running a macro
• Editing basic VBA
• Variables
• For loops
• If statements
• Working with ranges
• Copy/paste automation
• Opening/saving workbooks
• Creating simple custom functions

The goal is:

If I've done this manually 50 times, can Excel do it for me? That's where VBA becomes valuable.

11. Excel → PowerPoint is a major banking skill

Don't underestimate this.

Bankers frequently move:

Excel analysis → PowerPoint presentation

Macabacus specifically supports linking Excel data/charts to PowerPoint and Word, as well as formatting and presentation workflows.Macabacus

You want to understand:

• Linked vs. embedded objects
• Updating links
• Paste as picture
• Paste as linked Excel object
• Chart formatting
• Maintaining source formatting
• Breaking/unbreaking links
• Updating multiple slides efficiently

12. The 20 shortcuts I'd memorize first

If you're starting from zero, don't try to memorize 150.

Memorize these:

F2                  Edit cell
F4                  Lock reference
Ctrl + C            Copy
Ctrl + X            Cut
Ctrl + V            Paste
Ctrl + Alt + V      Paste Special
Ctrl + Z            Undo
Ctrl + Y            Redo
Ctrl + Arrow        Jump through data
Ctrl + Shift + →    Select through data
Ctrl + Home         Go to A1
Ctrl + End          Go to last used cell
Ctrl + PageUp       Previous sheet
Ctrl + PageDown     Next sheet
Ctrl + [            Trace precedents
Ctrl + ]            Trace dependents
Ctrl + ~            Show formulas
Alt + =             AutoSum
Ctrl + 1            Format Cells
F5                  Go To

Wall Street Prep's finance-oriented shortcut guide highlights many of these same commands, including F2, F4, precedent/dependent tracing, formula view and Paste Special.Wall Street Prep

The real "banker Excel" hierarchy

I'd learn it in this order:

1. Keyboard navigation ↓ 2. Formula construction & absolute references ↓ 3. Formatting without a mouse ↓ 4. Financial functions ↓ 5. Model architecture ↓ 6. Auditing / error checking ↓ 7. Sensitivity & scenario analysis ↓ 8. Power Query / data manipulation ↓ 9. VBA / automation ↓ 10. Macabacus

The biggest mistake is trying to become a shortcut expert before becoming a financial-modeling expert. The shortcuts are there to make good modeling faster—not to substitute for understanding the model.

If you're preparing for an investment-banking internship or analyst role, a very effective target is: be able to build a basic 3-statement model + DCF entirely from the keyboard, then audit someone else's model quickly.

Macabacus specifically supports linking Excel data/charts to PowerPoint and Word, as well as formatting and presentation workflows.

You want to understand:

YEAR
MONTH
DAY
EOMONTH
EDATE
YEARFRAC

Text

LEFT
RIGHT
MID
LEN
FIND
SEARCH
TEXT
CONCAT
TEXTJOIN

Modern Excel

FILTER
SORT
UNIQUE
LET

8. Investment-banking-specific Excel skills

This is where Excel knowledge turns into banking Excel knowledge.

You should be able to build without much hesitation:

• 3-statement financial models
• DCFs
• Trading comps
• Precedent transactions
• Accretion/dilution analyses
• LBO models
• Debt schedules
• Sources & uses
• Purchase-price allocation
• Sensitivity tables
• Scenario analyses
• Operating forecasts
• Revenue / EBITDA bridges

And, critically, understand why the formulas work, not merely reproduce them.

9. Learn Data Tables & sensitivity analysis

This is particularly important for valuation.

Excel's What-If Analysis includes Data Tables, Goal Seek and Scenarios; Data Tables can evaluate one- or two-variable sensitivities, while Goal Seek works backward from a desired result to determine an input.

For example:

In investment banking, Excel isn't just a spreadsheet tool—it is the primary environment where models, pitch books, and valuation analyses are built under tight deadlines . To survive 100-hour weeks, analysts rely on add-ins to automate heavy lifting and pure keyboard navigation (banning the mouse entirely) to move at lightning speed.o11.ai

Essential Excel Add-Ins

• Macabacus / Modano / Leveraged Finance Tools: Widely used productivity suites that handle tedious formatting, error checking, dynamic cycle coloring (blue for inputs, black for formulas, green for links), and seamless PowerPoint/Word linking.o11.ai
• Capital IQ / FactSet / Bloomberg Plugins: Institutional data stream add-ins that allow bankers to pull live historical financials, pricing, comps data, and transaction multiples directly into a spreadsheet via custom formulas.o11.ai
• Daloopa / AlphaSense (formerly BamSEC): Modern financial data and parsing add-ins utilized to instantly pull KPIs, segment data, and SEC filings straight into models without manual data entry.daloopa.com+1
• Arixcel / Spreadsheet Studio: Specialized auditing add-ins used for rapid structural error-checking, tracing complex circular references, and auditing large-scale LBO or M&A models.o11.ai

Essential Keyboard Shortcuts (No Mouse Required)

Mastering the Alt-key ribbon sequences and core control commands separates a senior analyst from a beginner.

Navigation & Selection

1. Ctrl + Spacebar : Select an entire column.
2. Shift + Spacebar : Select an entire row.
3. Ctrl + Shift + + (or Ctrl + + ): Insert rows or columns (after selecting entire row/column).
4. Ctrl + - : Delete selected row or column.
5. Ctrl + Page Up / Page Down : Move between different worksheets in a workbook.wallstreetoasis.com

Auditing & Tracing

1. Ctrl + [ (Left Bracket): Trace precedents (jump directly to cells feeding the active formula).
2. Ctrl + ] (Right Bracket): Trace dependents (jump to cells affected by the active formula).
3. F5 + Enter : Jump back to your original cell after tracing precedents/dependents.
4. F2 : Edit the active cell.

Formatting & Styling (Enhanced via Quick Access Toolbar)

1. Ctrl + 1 : Open the Format Cells dialog box.
2. Alt + W + V + G : Toggle gridlines on or off.
3. Alt + H + O + I : Auto-fit column width.
4. Alt + H + H : Bring up fill color palette.
5. Alt + H + B : Bring up border menus (e.g., top thin border, bottom double-bottom accounting underline).wallstreetoasis.com

Data & Operations

1. Alt + A + T : Turn filters on or off.
2. Shift + F2 : Insert or edit a cell comment/note.
3. Alt + H + E + A : Clear all contents/formatting from a cell.wallstreetoasis.com

Would you like me to share a step-by-step guide on how to set up a custom Quick Access Toolbar (QAT) for one-touch financial formatting?

For an investment banker, Excel speed comes from three things:

1. Modeling tools that reduce repetitive work
2. Keyboard mastery so you rarely touch the mouse
3. Banking-specific habits (formatting discipline, auditing, checks)

Below is the practical toolkit most analysts and associates should know.o11+1

Essential Excel Add-ins & Tools

1. Macabacus — Most important banking add-in

Best for: Financial modeling, formatting, auditing, and PowerPoint output.

Key features:

• Formula auditing and error checking
• Trace precedents/dependents
• Standardized banker formatting
• Faster model navigation
• Excel → PowerPoint linking
• Cell color cycling: - Blue = hardcoded input
• Black = formula
• Green = linked from another sheet/workbook

If your bank has Macabacus, learn it early. It is designed specifically around investment banking workflows.o11

2. Market Data Excel Plugins

S&P Global Capital IQ Excel Plug-in

Best for:

• Comparable company analysis
• Transaction comps
• Historical financials
• Trading multiples
• Consensus estimates

Typical uses:

• Pulling revenue, EBITDA, EPS, market cap
• Updating comps tables quickly

FactSet Excel Add-in

Best for:

• Institutional-quality financial data
• Estimates
• Ownership data
• Screening
• Valuation analysis

Bloomberg L.P. Excel Add-in

Best for:

• Market data
• Stock prices
• FX rates
• Interest rates
• Fixed income data

3. Microsoft Excel Power Query

Best for:

• Cleaning messy datasets
• Importing recurring data dumps
• Automating repetitive data preparation

Example:

• Download 20 companies' financial statements monthly
• Automatically clean and refresh the dataset

4. Excel Inquire Add-in

Best for:

• Comparing workbook versions
• Finding broken links
• Reviewing model changes

Useful before sending a model to a senior banker or client.Parse

Must-Know Excel Shortcuts (Windows)

Navigation

These are essential because banking models can contain dozens of tabs and thousands of rows.Wall Street Prep

Formula & Modeling Shortcuts

Example:

Before:

=B5*C10

After pressing F4 on C10:

=B5*$C$10

Copy / Paste Power Moves

Most-used Paste Special options:

• V → Values only
• F → Formulas
• T → Formatting
• E → Transpose

Formatting Shortcuts

Banker-Specific Shortcuts

Insert rows/columns

• Ctrl + + → Insert
• Ctrl + - → Delete

Autofit columns

Alt → H → O → I

Useful when cleaning imported data.

Filters

Ctrl + Shift + L

Quickly toggle filters on/off.

Current date

Ctrl + ;

Useful for model dates and transaction timelines.

Functions Every Investment Banker Should Know

Valuation / Modeling

• SUM
• AVERAGE
• MIN/MAX
• IF
• AND/OR
• INDEX
• MATCH
• XLOOKUP
• SUMIFS
• COUNTIFS

Financial Modeling

• NPV
• IRR
• XIRR
• XNPV
• PMT
• YEARFRAC
• EOMONTH

Data Cleaning

• LEFT
• RIGHT
• MID
• TRIM
• TEXT
• VALUE
• SUBSTITUTE

Banking Excel Habits That Matter

1. Avoid hardcoding inside formulas

Bad:

=Revenue*1.05

Better:

=Revenue*(1+Growth Rate Assumption)

2. Build checks everywhere

Examples:

Balance sheet check

Assets - Liabilities - Equity = 0

Sources & uses

Sources - Uses = 0

Debt roll-forward

Beginning Debt + New Debt - Repayment = Ending Debt

3. Minimize mouse usage

A strong analyst can:

• Navigate a 50-tab model
• Audit formulas
• Format outputs
• Update assumptions

without leaving the keyboard.Wall Street Prep

If You Only Memorize 15 Shortcuts

1. F2 — Edit formula
2. F4 — Lock references
3. Ctrl + Arrow — Navigate
4. Ctrl + Shift + Arrow — Select ranges
5. Ctrl + Page Up/Down — Switch tabs
6. Ctrl + Alt + V — Paste Special
7. Ctrl + D — Fill down
8. Ctrl + R — Fill right
9. Ctrl + 1 — Format cells
10. Ctrl + [ — Trace precedents
11. Ctrl + ~ — Show formulas
12. Ctrl + Shift + L — Filters
13. Alt + = — AutoSum
14. F5 — Go To
15. Ctrl + S — Save

Master Macabacus + a market data plugin + these shortcuts, and you will cover the majority of Excel workflows used by investment banking analysts.o11+1

In investment banking, speed and precision in Excel are non-negotiable. Analysts and associates live in spreadsheets, and mastering the right tools and key combinations separates a smooth pitch from a late-night bottleneck.

Essential Excel Add-Ins for Investment Banking

• Capital IQ / FactSet / Bloomberg Add-in: The holy trinity of market data. These plug-ins allow bankers to pull live market caps, historical stock prices, comps data, and transaction multiples directly into Excel via proprietary formulas (like =CIQ() or =BDP()).
• Macabacus / ASquared / Efficient Finance: Productivity add-ins tailored specifically for finance professionals. They automate tedious formatting (checking for hardcoded cells vs. formulas, standardizing font colors, error checking) and build dynamic shortcuts for charting, football field analysis, and agenda generation.
• Power Query: Built into modern Excel, this is crucial for data ingestion. It lets bankers quickly clean, reshape, and merge messy data from multiple target company decks or massive data tapes without resorting to error-prone manual copy-pasting.daloopa.com+1

Essential Keyboard Shortcuts (No Mouse Required!)

Investment bankers try to avoid the mouse at all costs. Here are the core navigation, formatting, and modeling shortcuts you need to commit to muscle memory.

Navigation & Selection

1. Ctrl + Arrow Keys : Jump to the very edge of a data region (skipping blanks or stopping at the last filled cell).
2. Ctrl + Shift + Arrow Keys : Highlight a continuous block of data instantly.
3. Ctrl + Home / Ctrl + End : Jump immediately to cell A1 or the bottom-right corner of your active data sheet.
4. Ctrl + Page Down / Ctrl + Page Up : Switch forward and backward between workbook tabs.youtube.com+1

Data Editing & Formulas

1. F2 : Edit the active cell (crucial for checking formula precedents).
2. F4 : Absolute/relative reference toggle (e.g., changing A1 to $A$1 ) or repeating your last action in some contexts.
3. Alt + = : Automatically insert a SUM formula for the column or row above/left.
4. Ctrl + (grave accent): Toggle between showing cell values and showing underlying formulas across the whole sheet.

Inserting & Deleting

1. Ctrl + Shift + + (plus key): Open the Insert dialog box to insert cells, rows, or columns.
2. - (minus key) while holding Ctrl : Delete selected rows or columns instantly.

Number & Cell Formatting

1. Ctrl + Shift + $ : Format as Currency (2 decimal places).
2. Ctrl + Shift + % : Format as Percentage.
3. Ctrl + Shift + ! : Format as Number with commas and 2 decimal places.
4. Alt + H, O, I : Auto-fit column width so no text or numbers are clipped (best set up as a custom Quick Access Toolbar macro).

Would you like me to share a guide on how to set up a high-speed Quick Access Toolbar (QAT) using Alt key sequences for custom formatting, or dive deeper into auditing formulas with Ctrl + [?