Thursday, June 20, 2019: 1:00 PM - 2:30 PM
Whether you are creating a list of data from scratch in Excel or downloading data from other sources, once you have it in Excel 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 Excel 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
Separating Data into Multiple Columns
Sorting by One Field
Creating a Custom Sort to Sort by Multiple Fields, Colors, or Icons
Creating a Pivot Table
Pivot Table Field List
Pivot Table Tools
Rearranging the Pivot Table
Formatting Data Fields
Professional Development and Training Coordinator
Cronin (501 Case-Geyer)