Google Sheets - Pivot Tables from Beginner to Expert
Video: .mp4 (1280x720, 30 fps(r)) | Audio: aac, 48000 Hz, 2ch | Size: 490 MB
Genre: eLearning Video | Duration: 20 lectures (59 mins) | Language: English
Master everything you need to know to create engaging pivot tables with real-world scenarios
Video: .mp4 (1280x720, 30 fps(r)) | Audio: aac, 48000 Hz, 2ch | Size: 490 MB
Genre: eLearning Video | Duration: 20 lectures (59 mins) | Language: English
Master everything you need to know to create engaging pivot tables with real-world scenarios
What you'll learn
Bring your data to life with easy-to-use pivot tables
Summarize large tables of data in seconds
Sort, filter, and SLICE the pivot table!!!
Prepare raw data for use in a pivot table
Add, average, perform statistical analysis, and more
Use calculated fields
Group your data inside your pivot table
Summarize your pivot table by week, month, year, etc.
Pull data back out of your pivot table with the GETPIVOTDATA function
Requirements
Laptop or desktop computer with an internet connection
You should have a beginner to intermediate level understanding of how to use spreadsheets.
Description
Pivot Tables allow you to summarize large tables of data in seconds. This course will give you the knowledge to create powerful pivot tables that bring new insight to your data. You will start off with understanding the purpose of pivot tables and how to prepare raw data to be pivoted. Then, work your way toward grouping data, summarizing it by date, adding calculated fields, and more.
Who this course is for:
This course is for any spreadsheet user who needs to create Intermediate to Advanced level Pivot Tables.