Dealing with Data: Sorting, Filtering, and PivotTables (Google Sheetsl)

Thursday, December 5, 2019:  9:00 AM - 10:30 AM


The registration period has closed for this event.

 

Whether you are creating a list of data from scratch in Google Sheets or downloading data from other sources, once you have it in Google Sheets you need to be able to make some sense of it and get the answers from it that you need. This workshop will show you how to sort your data, filter out just what you are looking for, and summarize, analyze and present large amounts of data using PivotTables.

This session will incorporate instructor-led demonstration and hands-on guided practice. This workshop will be in a conference room. A laptop will be provided for you but please feel free to bring your own.

 

 


Session Outcomes

Upon successful completion of this workshop, participants will be able to manipulate large lists of data by sorting, filtering and be able to create, and format PivotTables.


Target Audience

This workshop is intended for Google Sheets users who work with large lists of data and need to be able to make sense of and summarize it.


Workshop Length

1 hour plus an additional half hour for open Q & A.


Topics

 

  • Worksheet List Best Practices

  • Sorting by One Field

  • Creating a Custom Sort to Sort by Multiple Fields

  • Filtering Data

  • Creating a PivotTable

  • PivotTable Field List

  • PivotTableTools

  • Rearranging the PivotTable

  • Formatting Data Fields

  • Creating Charts from PivotTables


Presenting

Robin Bridson
Professional Development and Training Coordinator
x6559

rbridson@colgate.edu 

 




Register
Registration open through 12/5/2019 10:30 AM Eastern Time (US & Canada)

Location

Herbst Seminar Room (535 Case-Geyer)

 

Click here for Campus Map.