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
Need a Business Analyst who knows these tools?
I use these tools to turn business problems into clear requirements and measurable results.