Google Sheets Pivot Tables - Basic Tutorial

Learn how to create a basic pivot table, starting with the right data and ending with an easy-to-read report. This tutorial will lead you through basic creation, how to fill columns and rows, fill the body of the table with data, and group by date.

🕒 Timestamps:
0:00 Intro
0:33 Start with good data
1:09 Beginning to create
1:49 Make your columns and rows
2:53 Fill the middle with data
3:30 Analyze by date
3:45 Group by year
4:19 Filter by year
5:04 Other filters

Learn more from Prolific Oaktree:

#googlesheets #pivottables #prolificoaktree

[ProlificOaktree]

The Pivot table option is now on the Insert menu!

[julianbenabides]

Thank you SO MUCH for making a clear, concise video in about 5 minutes. I hate when I just need a simple explanation, like what you provided here, but the video maker puts it into a 30 minute video.

[antoniomcfarlane]

WHAT EVERYONE ELSE SAID!!
It's all about the layout. Well-planned & well-executed! And, I've never been moved to comment on a tutorial before. No stupid music. No discussion about things that aren't relevant, no... (You'd think that would be the minimum, but it's the exception.)
Thank you!

[princepessa]

Thank you SO much for creating this video! I was asked to create a pivot table for work and had no idea how to create one. Your video was easy to understand and a complete lifesaver for me, thank you!! 💛

[libertyjustice]

Just passed my google educator level 2 exam! Your videos really helped me to prepare. Thanks!

[annieklyce]

This is AMAZING! The birds in the background are a great addition :) Thank you!

[david-barna]

It's a shame Phil left. He was the best.

[rightbraindom]

Finally a tutorial that doesn't make me fall asleep. Thank you!

[Alymarii]

This is incredibly helpful and very nice of you to break this down for people, completely for free.

Thank you so much.

[nguyenthanhhuynh]

incredibly helful and easy to understand. I spent so much time just to understand pivot table until i see your video!

[BrienOToole]

Clearest exposition I've ever seen.

[TDCtracyhill]

Greatly appreciate your presentation style! You offer an explanation along with each selection - exactly what I needed!

[reverse]

Excellent tutorial. Straight to the point. Thanks!

[davidpranatamurti]

Thank you for sharing useful tips on Google Sheets.

[kanwalnanda]

Thank you for your clear explanation, very concise and accurate explaination. I learnt a very valuable skill today.

[oiukozl]

Very very helpful. Thanks for sharing this in detail.

[twirlspin]

This is great very easy to understand and well laid out thanks! not exactly what I want but it got me on the right path. Will check your other videos to see if you address combining multiple sheets of data

[SuriyaWetzler]

Very nice n summary description. Thank you 🙏🏻

[shoremedic]

Made it look easy. Now to practice and apply to my data. Thanks!

[michaelscott]

Exactly what I was looking for, thank you!