YoVDO

Google Sheets: Pivot Tables

Offered By: LinkedIn Learning

Tags

Google Sheets Courses Data Analysis Courses Data Sorting Courses Data Filtering Courses Data Manipulation Courses Pivot Tables Courses

Course Description

Overview

Learn how to summarize and rearrange your Google Sheets data dynamically with pivot tables.

Syllabus

Introduction
  • Welcome
  • What you should know
1. Creating and Manipulating Pivot Tables
  • Arrange your data for use in a pivot table
  • Create a pivot table
  • Pivot a pivot table
  • Edit a pivot table’s data source
  • Change a value field’s summary operation
  • Create a calculated field
  • Show and hide totals
2. Manipulating Pivot Tables
  • Sort values in a pivot table
  • Filter a pivot table by rule
  • Filter a pivot table by selection
  • Filter a pivot table using a search filter
  • Filter a pivot table using a filter field
  • Filter a pivot table using show and hide detail controls
Conclusion
  • Further information

Taught by

Curt Frye

Related Courses

Making Sense of Data
Google via Independent
Introduction to Spreadsheets and Models
University of Pennsylvania via Coursera
Comptabilité de gestion et pratique du tableur
Université Montpellier 2 via France Université Numerique
The Power of Data in Health and Social Care
University of Strathclyde via FutureLearn
Digital Media Analytics: Introduction
Purdue University via FutureLearn