Excel 2: Functions and pivot tables

  • Event: 2017 IRE Conference
  • Speaker: Nick Penzenstadler of USA TODAY Network
  • Date/Time: Thursday, Jun. 22 at 10:15am
  • Location: Pinnacle Peak 2
  • Audio file: No audio file available.

In this class you’ll learn some snappy functions to help you ask questions of your data in Excel in minutes rather than hours. We’ll focus on when and how to use functions, calculate rates and change and then use the power of pivot tables to ask questions like “Which groups have most?” or “How often does this happen?”

Prerequisites: This class will be helpful if you’ve taken Excel 1 or have worked with spreadsheets. We’ll assume you can load data into Excel and get it relatively clean.

 

Speaker Bios

  • Nick Penzenstadler is an investigative reporter at USA TODAY where he works on national investigations. His team specializes in data analysis and project management for collaborations across the 109 community newsrooms within Gannett. @npenzenstadler

Related Tipsheets

No tipsheets have yet been uploaded for this event.