When it comes to investment banking, Excel is not just a tool — it’s the language of the industry. From building complex financial models to analysing massive datasets, Excel is used daily by analysts, associates, and even managing directors. For graduates looking to break into investment banking, mastering Excel is a non-negotiable skill.
In this article, we’ll explore how Excel is used in investment banking, which functions and formulas you should know, and how to build your Excel expertise before applying for roles. Whether you’re preparing for an investment banking graduate scheme or sharpening your skills during university, this guide will help you get ahead.
Why Excel Matters in Investment Banking
Excel is the backbone of nearly every analytical task in investment banking. It’s where deals are valued, companies are modelled, and performance is tracked. While banks may use high-end software for trading and risk, when it comes to corporate finance, mergers and acquisitions (M&A), and equity research, Excel remains the industry standard.
Here’s why:
- Speed and flexibility: Analysts can build and tweak models quickly without relying on complex coding or software.
- Customisation: Models can be built from scratch and tailored to specific companies, sectors, or clients.
- Communication: Models built in Excel are easy to share, edit, and audit. Clients and colleagues alike expect deliverables in Excel.
- Recruiter expectation: Banks assume graduate applicants have strong Excel knowledge — and test for it during hiring.
Simply put, if you want to be taken seriously as a graduate applicant in investment banking, you need to be fluent in Excel.
Daily Use of Excel in Investment Banking Roles
In a typical day, a junior investment banker might use Excel to:
- Build a financial model for a client preparing for an IPO
- Run a sensitivity analysis on a merger scenario
- Forecast cash flows for a company acquisition
- Create a three-statement model for a valuation
- Analyse a client’s financial performance over the last five years
- Link Excel data into pitchbook slides prepared in PowerPoint
These tasks often involve large amounts of data, tight deadlines, and high stakes — making Excel efficiency critical.
Essential Excel Skills for Investment Banking
1. Keyboard Shortcuts
Speed matters. Analysts are expected to work efficiently, often with minimal mouse use. Common shortcuts include:
- Ctrl + Shift + L: Add or remove filters
- Alt + E, S, V: Paste special values
- Ctrl + [ / Ctrl + ]: Navigate to linked cells
- F4: Repeat last action
- Ctrl + Arrow Keys: Jump across ranges of data
Recruiters often test for shortcut fluency in assessment centres.
2. Financial Functions
Knowing the right functions can save hours of manual work. Commonly used formulas include:
- IF / AND / OR: For logical testing
- VLOOKUP / INDEX-MATCH: For pulling data from tables
- SUMIFS / COUNTIFS: For conditional totals
- XNPV / XIRR: For more accurate time-based financial calculations
- ROUND / TRUNC / INT: For precision formatting
Understanding how and when to use these is a key skill for entry-level investment banking j
3. Three-Statement Modelling
The foundation of financial analysis, this involves building interconnected models of:
- The Income Statement
- The Balance Sheet
- The Cash Flow Statement
These statements are dynamically linked in Excel to reflect how changes in one area affect others. You’ll use formulas, assumptions, and Excel logic to build working models from scratch.
4. Formatting for Clients
Presentation matters in banking. Models must be clear, clean, and client-ready. That means:
- Consistent formatting: Use colour codes (e.g., blue for assumptions, black for formulas).
- Clear labels: Every row and column must be clearly titled.
- Use of named ranges: Improves readability and reduces errors.
- Avoiding clutter: Clean models are easier to update, audit, and present.
Clients and senior bankers often view these files. Presentation reflects professionalism.
5. Sensitivity & Scenario Analysis
Investment bankers often run multiple cases to test how different variables affect a model’s output. In Excel, this involves:
- Using data tables to vary one or two inputs
- Creating scenario managers to toggle between different sets of assumptions
- Using dropdowns and named ranges for user-friendly dashboards
These tools help decision-makers visualise best- and worst-case outcomes.
How to Learn Excel for Investment Banking as a Graduate
You don’t need to wait until you’re hired to master Excel. Here’s how to start building the skill during your studies:
1. Take Online Excel Courses
Platforms like CFI, Wall Street Prep, and Breaking Into Wall Street offer investment banking-specific Excel training. These courses are designed to simulate the types of tasks junior analysts handle.
2. Practise Real-World Projects
Use real company reports (from Yahoo Finance or investor relations websites) to build your own financial models. Try to:
- Recreate a company’s income statement
- Forecast earnings for five years
- Build a DCF model using assumptions for revenue, margins, and terminal value
3. Join a Finance or Investment Society
Many university finance societies run Excel and modelling workshops. If yours doesn’t — start one.
4. Participate in Case Competitions
These often involve Excel-heavy tasks such as forecasting, valuation, and analysis. Winning or even participating looks strong on a CV.
Excel Testing in Graduate Recruitment
Investment banks increasingly use Excel tests during the hiring process to filter applicants. These may be part of:
- Online assessment centres
- Superday technical tests
- Case study interviews
- Internship conversion evaluations
Typical tasks include:
- Cleaning messy data
- Performing ratio analysis
- Building a mini DCF model
- Spotting formula errors or correcting links
Being well-practised in Excel will help you avoid getting tripped up during these stages.
How to List Excel on Your Graduate CV
To stand out in a competitive application pool, be specific when listing Excel skills. Instead of simply writing “Proficient in Excel,” consider something like:
- “Built a 3-statement financial model using Excel to forecast 5-year earnings for a UK-based retail company”
- “Used INDEX-MATCH and SUMIFS to automate portfolio analysis as part of a student-managed investment fund”
- “Completed Excel for Finance course (Wall Street Prep), with modules on financial modelling and scenario analysis”
This shows both ability and initiative.
Mistakes Graduates Make with Excel
1. Relying Too Heavily on the Mouse
Speed matters. Learn shortcuts early to boost efficiency and performance.
2. Poor Formatting
Messy spreadsheets are hard to follow and reflect badly on your professionalism.
3. Ignoring Best Practices
Always include a cover sheet, separate inputs from calculations, and include clear notes for assumptions.
4. Not Understanding the “Why”
It’s not enough to use a formula — you need to understand what it’s doing and why it matters.
Excel vs. Other Tools: Why It Still Reigns
While tools like Python, R, and Tableau are gaining popularity in finance, Excel remains dominant in investment banking because:
- It’s flexible and universally understood
- Clients expect Excel deliverables
- It’s quicker for ad-hoc work than programming languages
- Everyone from interns to MDs can use it
That said, adding Python or SQL to your skill set can complement your Excel fluency, especially in data-heavy roles.
Excel for investment banking is more than an entry-level skill — it’s your daily toolkit, your report card, and your way of proving value early in your career. The better you are at Excel, the faster you’ll be able to deliver results, support deals, and gain the trust of your team.
For graduates and students, mastering Excel is one of the most practical, achievable ways to boost your employability in a crowded job market. Start now, practise often, and treat Excel like the essential finance language that it is.
