Skip to main content

Spreadsheets for Data Analyticss

Spreadsheets here means working fluently in Excel and Google Sheets to clean, calculate and summarise small to medium datasets. Lookups, conditional logic, pivot tables and charts let an analyst answer questions quickly before moving to SQL or Python. It is the first hands-on tool on the Data Analytics path.

Stage: Analytics Foundations · Part of the Data Analytics roadmap · Last reviewed 19 November 2026

What to learn in Spreadsheets

Spreadsheets interview questions

Why is XLOOKUP preferred over VLOOKUP in modern Excel?

XLOOKUP can look left or right, defaults to exact match, returns a custom value when nothing is found, and survives inserted columns because it takes ranges rather than a column index number. VLOOKUP needs the key in the first column and a hard-coded index.

When does a pivot table stop being the right tool?

When data runs to hundreds of thousands of rows, needs repeatable refresh from a database, or requires joins across tables. Then the work moves to SQL, Python, Power Query or a BI tool so the analysis is reproducible instead of manual.

Where Spreadsheets fits in the Data Analytics roadmap

Spreadsheets belongs to the Analytics Foundations stage (beginner level), which takes about 4 hours. Think in data.

Back to the full Data Analytics roadmap