Google Sheets - Pivot Tables from Beginner to Expert

Offered By: Skillshare

Tags

Google Sheets Courses Time Series Analysis Courses Data Sorting Courses Data Filtering Courses Statistical Analysis Courses Data Summarization Courses Pivot Tables Courses

Course Description

Overview

Bring your data to life with easy-to-use pivot tables.

Summarize large tables of data in seconds.
Sort, filter, and SLICE your pivot tables!!!
Prepare raw data for use in a pivot table
Prepare raw data for use in a pivot table
Sum, 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

This course is for beginner and intermediate level spreadsheet users who need to create Intermediate to Advanced level Pivot Tables.

Syllabus

Welcome to the course!
What are pivot tables?
Why do we use pivot tables?
Preparing your data
Your First Pivot Tables
Add and rearrange columns and rows
Available functions
Sort and filter
Slicers
Drill down
Calculated fields
Group data
Summarize data
GETPIVOTDATA

Taught by

Adam Steinfurth

Related Courses

Policy Analysis Using Interrupted Time Series
The University of British Columbia via edX Quantitative Finance
Indian Institute of Technology Kanpur via Swayam Macroeconometric Forecasting
International Monetary Fund via edX Explaining Your Data Using Tableau
University of California, Davis via Coursera Time Series Forecasting
Udacity