Training Trains Internship
Student login
← Data Analytics learning path
Data Analytics · Module 3 of 10

Spreadsheets for analysis

Use Excel or Google Sheets for quick analysis.

📖 Key ideas

  1. Sort and filter data to explore.
  2. Formulas: SUM, AVERAGE, COUNTIF, SUMIFS, IF.
  3. Lookups: XLOOKUP or VLOOKUP join data.
  4. Pivot tables summarise data quickly.
  5. Conditional formatting highlights patterns.
💡 Real-life example: A pivot table is a magic sorter: drag fields and instantly see totals by any category.
Pivot tableInteractive summary table
XLOOKUPFinds values from another table
SUMIFSSums with multiple conditions
Conditional formattingColours cells by rules