This video guide walks you through how to use Pivot Tables in Google Sheets.
The link to the Titanic data is here. Go to File > Make a copy to start. The interactive grouping example can be found here.
We'll practice grouping in rows and columns, and then various summarizing tools: counta, sum, average, etc.
We'll review grouping, and then introduce filters.
The police shooting spreadsheet is here. Go to File > Make a copy to start.
We'll learn how to extract years and months from a date, and then use a pivot table to run an analysis.
We'll learn how to look up data from another spreadsheet and merge it with your data.