Pivot Tables are a powerful, no-code-necessary, tool used by all data journalists to analyze data in a spreadsheet. If you want to group data by a column (e.g. by zip code or by company), or multiple columns (e.g. by race AND gender), pivot tables will come in handy.
In this workshop, we will cover:
- When and when not to use a pivot table
- How to set up pivot tables in Microsoft Excel and Google Sheets
- Summing, counting, averaging, and getting minimum and maximum values with Pivot Tables
- Sorting and filtering data with Pivot Tables
What to bring: You will be provided with a computer outfitted with Excel in one of our computer labs. If you have Excel on your laptop and prefer to bring it, please do so.
Prior knowledge of Excel is helpful but not necessary
Refunds up to 1 day before event