BA Toolkit / Data & analytics

Microsoft Excel

Still the most-used analysis tool in business.

What it is

Excel is Microsoft’s spreadsheet application, used for calculations, data cleaning, pivot tables, charts and quick models.

How a Business Analyst uses it

  • Analyse data with pivot tables and lookups to answer business questions quickly
  • Build traceability matrices that link requirements to tests
  • Model costs, benefits and options for a business case
  • Validate and clean data before a migration or report

Practical tip

Keep raw data, calculations and outputs on separate sheets so others can check your work.

Where I've used it

I used Excel throughout: data analysis at Host My Code, documentation and analysis at Cyberaon Technologies, and modelling during my MSc.

Related tools

← Back to the full toolkit

Need a Business Analyst who knows these tools?

I use these tools to turn business problems into clear requirements and measurable results.

Scroll to Top