Data analysis in a spreadsheet: merge, filter, summarise

A starter example: the scenario merges two datasets, filters what matters and prepares a short takeaway — on live figures.

  • Merges spreadsheet data on a shared field
  • Filters rows by a condition
  • Counts good and bad periods
  • Prepares a short takeaway