Excel Skills Every MBA Student Needs

Why Excel still matters for MBA students

Python and Tableau get more attention in MBA data courses, but Excel remains the tool you'll actually use in case competitions, internships, and most consulting and finance roles. Being faster and more confident in Excel than your peers is a genuine competitive advantage.

Financial modelling basics

-- Revenue projection
=prior_year_revenue * (1 + growth_assumption)

-- EBITDA
=Revenue - COGS - OpEx

-- Free cash flow
=EBITDA - CapEx - Change_in_Working_Capital - Taxes

-- DCF valuation
=NPV(WACC, projected_FCFs) + Terminal_Value / (1+WACC)^years

Case competition formulas

-- Market sizing
=TAM * market_share_assumption

-- Break-even
=fixed_costs / (price - variable_cost_per_unit)

-- Payback period
=initial_investment / annual_cash_inflow

-- ROI
=(gain - cost) / cost * 100

Scenario and sensitivity analysis

Use Data Tables (Data → What-If Analysis → Data Table) to show how your output changes across a range of assumptions. In case presentations, a sensitivity table showing NPV across different growth rates and discount rates is expected at top MBA programmes.

Consulting-specific skills

Structured data — one row per observation, consistent formatting, no merged cells
Named ranges — models others can read and edit without confusion
Pivot tables — quickly summarise and explore large datasets
Charts — clear, labelled, McKinsey-style (simple, data-forward)
Keyboard shortcuts — speed in live case presentations matters

💡 The MBA Excel test

Many consulting and finance firms test Excel as part of the MBA recruiting process. Bain, BCG, and McKinsey all use quantitative case rounds that involve spreadsheet work. Practice building models from scratch in under 20 minutes.

Now practise it for real

Practice financial modelling formulas in the Finance & Banking track — NPV, IRR, PMT and more. Free to start.

Start the Finance & Banking track free →

Excel skills every MBA student needsmodelling, cases, and consulting