Excel on Your CV: How to Showcase It So Employers Actually Notice

Excel is the most dangerous skill to claim on a finance or analyst CV. Dangerous not because it is unimportant — it remains the dominant tool in investment banking, FP&A, corporate finance, accounting, and management consulting — but because every single candidate lists it. Saying "proficient in Excel" in 2026 is the equivalent of saying "can read" on a legal CV. The baseline is assumed; what matters is the level above it that you can demonstrate.

The finance and accounting market has a well-understood mental model of Excel capability. Hiring managers in these fields — many of whom are Excel power users themselves — will not be impressed by a list of functions. They want to see evidence of financial modelling sophistication, data handling at scale, and the kind of analytical rigour that turns raw data into decision-ready outputs. Your CV needs to reflect that.

What Finance Hiring Managers Actually Look For

Excel skill in finance exists on a clear spectrum, and hiring managers roughly sort candidates into three tiers during the first read:

Basic tier: Knows standard formulas (SUM, IF, VLOOKUP, basic pivot tables). Gets through data entry and standard reporting tasks. Not what a finance role above analyst-I is looking for.

Intermediate tier: XLOOKUP/INDEX-MATCH, nested IFs, SUMIFS/COUNTIFS, multi-level pivot tables, dynamic charts, basic data validation, conditional formatting for dashboards. Competent for reporting roles and junior FP&A positions.

Advanced tier: Complex array formulas, dynamic arrays (FILTER, SORT, UNIQUE, SEQUENCE — Excel 365 functions that many candidates still do not know), Power Query for data transformation, Power Pivot with DAX for multi-table models, VBA or Office Scripts for automation, financial modelling with linked schedules (3-statement models, DCFs, LBO models), large dataset management, solver for optimisation problems.

If you are applying for roles above junior level in investment banking, private equity, FP&A, or corporate development, the hiring manager assumes you are at the advanced tier. Your CV needs to prove it with specifics.

How to Quantify Excel Work in Finance

Finance professionals are accustomed to numbers, which makes quantifying Excel work slightly more natural — but most CVs still fall short by describing the tool rather than the outcome.

Before: Built Excel models for financial analysis.

After: Built a three-statement integrated financial model (P&L, balance sheet, cash flow) for an £80M acquisition target with 5-year projections, 12 scenario levers, and a DCF valuation sensitivity table; model used by the MD and CFO to support Board presentation and ultimately underpinned the final offer price.

Before: Used Excel for monthly reporting.

After: Designed and automated the monthly management accounts pack in Excel using Power Query to consolidate data from four source systems and VBA macros to format and distribute 14 business unit reports — reduced monthly close reporting time from 3 days to 4 hours and eliminated manual formatting errors that had affected two consecutive quarters.

Before: Created Excel dashboards for the finance team.

After: Built a dynamic KPI dashboard in Excel 365 using dynamic arrays (FILTER, SORT, UNIQUE) and conditional formatting that tracked 30 operational metrics across 8 departments in real time; replaced a static monthly PowerPoint deck and cut reporting preparation from 6 hours to 20 minutes per cycle.

Excel Ecosystem: What to Signal

Excel in finance does not exist in isolation. The tools and practices around it are as important as the software itself:

Excel 365 features: Dynamic arrays (FILTER, SORT, UNIQUE, SEQUENCE, XLOOKUP, XMATCH), LET function for cleaner formulas, LAMBDA for custom functions, co-authoring. Mentioning 365-specific features signals currency — candidates still describing themselves as VLOOKUP experts read as behind the curve to a hiring manager using XLOOKUP daily.

Power Query (Get & Transform): The most undervalued Excel feature in finance CVs. If you use Power Query to clean, reshape, and combine data from multiple sources, it belongs prominently on your CV. It signals the bridge between manual Excel work and proper data engineering.

Power Pivot / Data Model with DAX: Multi-table data models, relationship management, DAX measures — this is the Excel feature set that approaches BI tool capability. Finance candidates who know Power Pivot can build financial models that would choke in a standard worksheet.

VBA / Office Scripts: Automation signals seniority. A finance candidate who automates repetitive reporting tasks frees up time for analysis — and that distinction matters to hiring managers. Be specific about what you automated.

Financial modelling standards: Three-statement models, LBO models, DCF models, merger models, budget models, rolling forecasts. Name the model type and the context (M&A, budgeting, valuation). Finance professionals will immediately understand the complexity implied.

Related tools: Word/PowerPoint for output formatting, SharePoint/Teams for distribution, sometimes Tableau or Power BI as a downstream consumer of Excel data.

Where to Place Excel on Your CV

Skills section: Do not just write "Microsoft Excel — Advanced." Write something like "Excel 365 (advanced) — Power Query, Power Pivot/DAX, VBA, dynamic arrays, 3-statement modelling." This tells any finance hiring manager immediately that you are in the serious tier.

Experience section: Excel should appear in bullets where it drove decision-making or operational outcomes — not just in a skills list. If financial modelling in Excel was a core part of your role, it should be explicit in at least two bullets per relevant position, with the model type or business context named.

Certifications / training section: Financial modelling bootcamps and courses sometimes warrant a line, but only if the programme is recognised. See below.

Certifications and Credentials

Excel itself has no universally respected certification. But the adjacent credentials carry weight in finance:

• Financial Modelling & Valuation Analyst (FMVA) — Corporate Finance Institute: Well-recognised in corporate finance and FP&A. Demonstrates financial modelling competency beyond raw Excel skill.
• Chartered Financial Analyst (CFA) Levels I–III: Not an Excel cert, but the modelling work required signals quantitative fluency. If you hold CFA level II or III, it implicitly validates your financial Excel skills.
• ACCA / ACA / CIMA: Accounting qualifications that validate the professional context in which you use Excel for financial reporting.
• Microsoft Office Specialist (Excel Expert): Legitimate but low perceived value in finance circles — interviewers know the exam does not test financial modelling. Worth listing for early-career candidates only.
• Macabacus / Wall Street Prep / Breaking Into Wall Street courses: These are respected in IB and PE circles. If you have completed any of their financial modelling programmes, mention it — particularly for investment banking analyst roles.

Common Mistakes That Weaken Finance CVs

"Advanced Excel" without examples. It is the most-repeated meaningless phrase in finance CVs. Replace it with a specific tool or model type, then demonstrate it in your bullets.

Not distinguishing Excel 365 from legacy Excel. Power Query, XLOOKUP, and dynamic arrays are Excel 365 features unavailable in Excel 2016. If you use them, say so — it signals you are working with current tooling.

Describing Excel as an input, not an output. "Used Excel to analyse data" describes a tool. "Built a rolling 18-month cash flow forecast model in Excel that the Treasury team used to manage £12M in working capital" describes an outcome. The second version will always get more attention.

Listing Excel alongside Google Sheets as equals. In investment banking and corporate finance, this can read as a red flag. These are different tools for different contexts. Finance employers use Excel heavily; list Google Sheets separately or in a different context.

Ignoring Power Query. Most finance candidates who are competent Excel users have never touched Power Query. If you have, it is a significant differentiator — particularly in FP&A and reporting roles where data consolidation is a real problem.

Closing

Excel is so expected in finance roles that poor presentation of it is a silent interview killer. The candidates who consistently get past the screening round are the ones who make their level of Excel skill impossible to underestimate — who name the model types, the features, and the business outcomes that resulted from their work, rather than relying on an adjective like "advanced" to carry the weight.

NextCV reads the finance job description you are targeting and restructures your CV to surface the Excel and financial modelling experience that matches what that specific employer needs to see at the top.