In this lesson, we introduce the Pivot Table tool. We'll summarize a dataset with formulas and then see how much easier, quicker and more flexible it is to do with Pivot Tables.

The raw dataset for this data cleaning exercise can be accessed here (will make a copy on your Drive):

Lesson 22 Data Cleaning Sheet

Resources:

Google documentation for the UNIQUE function

Google documentation for the SUMIF function

Google documentation for the COUNTIF function