Skip to main content

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

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.

Back to the full Data Analyst roadmap