Google Sheets: Pivot Tables

Go to class
Write Review

Free Online Course: Google Sheets: Pivot Tables provided by LinkedIn Learning is a comprehensive online course, which lasts for Less than 1 hour of material. The course is taught in English and is free of charge. Upon completion of the course, you can receive an e-certificate from LinkedIn Learning. Google Sheets: Pivot Tables is taught by Curt Frye.

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