Microsoft Excel
The universal spreadsheet tool used across every sector for data analysis, financial modelling, and reporting.
What it is
About Microsoft Excel
Microsoft Excel is the most widely used professional software tool in the world — present in virtually every white-collar role from entry-level administration to senior finance. At the basic level it is a structured grid for organising data, building simple calculations, and producing charts. At the intermediate level it becomes a data analysis tool: pivot tables, VLOOKUP/XLOOKUP, conditional formatting, and named ranges. At the advanced level it is a financial modelling and automation environment: multi-sheet DCF models, Monte Carlo simulations, Power Query for ETL, Power Pivot for large dataset aggregation, and VBA macros for repetitive task automation. The depth of Excel skill required varies enormously by role. A construction project manager uses it to track costs against budget. An investment banker uses it to build a three-statement financial model with circular references and sensitivity tables. An HR business partner uses Power Query to join headcount data from HRIS exports to calculate attrition by department. The tool is the same; the depth of use is entirely different. Excel literacy is now a baseline expectation for most professional roles in the UK; Excel fluency — pivot tables, XLOOKUP, data validation — separates candidates who can work at pace from those who slow teams down.
What you can do with it
Capabilities
Build a pivot table from a raw data export to summarise sales by region and month in under two minutes
Write an XLOOKUP formula to pull contract rates from a reference table into an invoice calculator
Model a three-statement financial forecast (P&L, balance sheet, cash flow) with linked assumptions and a sensitivity table
Use Power Query to import, clean, and reshape data from multiple CSV exports without writing a single formula
Create a dynamic chart that updates automatically when new data is pasted into the source range
Build a workforce attrition dashboard using COUNTIFS, pivot charts, and conditional formatting to highlight departments above threshold
How to learn it
Learning Resources
Microsoft's free Excel training at support.microsoft.com/excel — structured by skill level from beginner to advanced
ExcelJet (exceljet.net) — the best free reference for formulas, with real-world examples for every function
Chandoo.org — free tutorials on dashboards, pivot tables, and charting; strong on storytelling with data
CFI's free Excel Crash Course at corporatefinanceinstitute.com — finance-focused but broadly applicable
Pro Tip
Learn keyboard shortcuts before learning advanced functions — Ctrl+Shift+L (filters), Alt+= (AutoSum), Ctrl+T (table), F4 (lock reference), Ctrl+D/R (fill down/right). Analysts who navigate without touching the mouse work two to three times faster than those who do not, and interviewers notice.
Skills that use this tool
Roles that use this tool