YoVDO

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

Introduction to Statistics: Descriptive Statistics
University of California, Berkeley via edX
Statistical Reasoning for Public Health 1: Estimation, Inference, & Interpretation
Johns Hopkins University via Coursera
Excel Skills for Business: Intermediate I
Macquarie University via Coursera
Introduction to Statistics for Data Science
SAP Learning
Complex Retrieval Queries in MySQL Workbench
Coursera Project Network via Coursera