HDTutorial
EN
Google Sheets Pivot Tables - Basic Tutorial

Playback starts YouTube’s embedded player (privacy-enhanced mode).

Google Sheets Pivot Tables - Basic Tutorial

591,983 views October 26, 2018 5:53

Watch on YouTube
ChannelProlific Oaktree

Chapters

Description from the creator

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

Link to sheet: docs.google.com/spreadsheets/d/1CyPgLc6GRy5GQqp…

Learn more from Prolific Oaktree:
🌳 Next Video - Google Sheets - Create an Interactive Task List - youtu.be/cOOrdL_JuF0
🌳 Related Playlist - Google Apps | Full Tutorials - bit.ly/google-tutorials

#googlesheets #pivottables #prolificoaktree

About this tutorial

Prolific Oaktree published this 5:53 video tutorial on October 26, 2018. It has been watched 591,983 times on YouTube.

Duration
5:53
Published
October 26, 2018
Views
591,983
Likes
3,429

Tags

Share

Further reading

  • How to Use Pivot Tables in Google Sheets (Ultimate Guide) business.tutsplus.com

    With a pivot table, you can build reports that help you understand your original data better. Building a pivot table in Google Sheets is easier than you think. In this tutorial, I'll teach you how to use Google Sheets t…

  • Create & use pivot tables - Computer - Docs Editors Help support.google.com

    Add or edit pivot tables. On your computer, open a spreadsheet in Google Sheets. Select the cells with source data you want to use. Important: Each column needs a header. In the menu at the top, click Data Pivot table.…

  • Google Sheets Pivot Tables - Basic Tutorial prolificoaktree.com

    More training is available on how to prepare data for a Pivot Table as part of a Pivot Table Course designed with beginners in mind. Finished Pivot Table Posted in Cloud Software | Tagged Google Sheets , group by date ,…

This tutorial in other languages