Excel for Data Analysts
Excel is the most common tool for quick analysis, using formulas, pivot tables and charts.
Stage: Spreadsheets and SQL · Part of the Data Analyst roadmap · Last reviewed 19 November 2026
What to learn in Excel
- VLOOKUP and XLOOKUP
- Pivot tables
- Conditional formatting
Excel interview questions
What is the difference between VLOOKUP and XLOOKUP?
XLOOKUP can look left, defaults to exact match and handles missing values more cleanly than VLOOKUP.
Where Excel fits in the Data Analyst roadmap
Excel belongs to the Spreadsheets and SQL stage. The tools every analyst uses daily.
Other units in this stage
Back to the full Data Analyst roadmap