Previous Lecture Complete and continue  

  Lesson 3: Introduction to Pivot Tables

⬇️⬇️Templates are available under the video! ⬇️⬇️

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 pivot table exercise can be accessed by clicking the link below (it will prompt you to make a copy on your Drive).

Template:

03 Pivot Tables: Introduction

Other Resources:

Google documentation for the UNIQUE function

Google documentation for the SUMIF function

Google documentation for the COUNTIF function