SUNY Geneseo
Sign Up

Looking for a quick and accurate method for computing sums, averages, and percentages for spreadsheet data? In this workshop, we will practice aggregating data (viz., Google form survey responses, Argos reports) in Excel using pivot tables. Pivot tables are so-named for the ability to turn or pivot the aggregated data, allowing us to examine the underlying data from different perspectives. Upon opening a raw data file (e.g., in a CSV format), an informative pivot table with aggregated data can be created in as few as 5 clicks allowing us to make sense of data sets (small and large) very quickly. We will also explore creating slicers to filter pivot tables with as few as 3 additional clicks. Practice data will be provided for use during the workshop. Although we will use Excel, please note that a very similar method can be applied to data in Google Sheets.

1 person is interested in this event