Dealing with Data: Sorting, Filtering, and PivotTables (Excel)

Wednesday, November 14, 2018:  3:00 PM - 4:30 PM


The registration period has closed for this event.

 

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.

 

 


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 Excel 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

  • Separating Data into Multiple Columns

  • Sorting by One Field

  • Creating a Custom Sort to Sort by Multiple Fields, Colors, or Icons

  • Filtering Data

  • Creating a Pivot Table

  • Pivot Table Field List

  • Pivot Table Tools

  • Rearranging the Pivot Table

  • Formatting Data Fields

  • Creating PivotCharts


Presenting

Robin Bridson
Professional Development and Training Coordinator
x6559

rbridson@colgate.edu 

 




Register
Registration open through 11/14/2018 5:00 PM Eastern Time (US & Canada)

Location

Cronin (501 Case-Geyer)

 

Click here for Campus Map.