Monday, October 14, 2019: 11:00 AM - 12:30 PM
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 and PivotCharts. This session will incorporate instructor-led demonstration and hands-on guided practice.
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.
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.
1 hour plus an additional half hour for open Q & A.
Worksheet List Best Practices
Sorting by One Field
Creating a Custom Sort to Sort by Multiple Fields
Creating a PivotTable
PivotTable Field List
Rearranging the PivotTable
Formatting Data Fields
Creating Charts from PivotTables
Professional Development and Training Coordinator
Herbst Seminar Room (535 Case-Geyer)