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

**** If you have trouble opening the templates, it may be because your G Suite domain has restricted access to non-whitelisted domains. You may need to ask your G Suite domain manager to whitelist benlcollins.com. In the meantime, you can also open the link in an incognito browser to see the file. ****

Other Resources:

Google documentation for the UNIQUE function

Google documentation for the SUMIF function

Google documentation for the COUNTIF function