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
- Look up values across sheets with XLOOKUP or INDEX and MATCH
- Build a pivot table that summarises sales by month and region
- Clean text with TRIM and text functions and remove duplicate rows
- Write conditional formulas with IF, SUMIFS and COUNTIFS
- Use absolute and relative cell references correctly when copying formulas
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.
Other units in this stage
Back to the full Data Analytics roadmap