Excel 2: Functions and pivot tables (repeat)

  • Event: 2017 IRE Conference
  • Speaker: Kimbriell Kelly of Los Angeles Times
  • Date/Time: Friday, Jun. 23 at 5:00pm
  • 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

  • Kimbriell Kelly is the Deputy Editor for Enterprise and Investigations at the Los Angeles Times, Washington, D.C. Bureau. Prior to joining the Times in June, Kelly was a reporter on the Investigative Unit at The Washington Post, where she was part of the team that won a Pulitzer in 2015 for the examination of officer-involved shootings. She was a Pulitzer finalist in 2019 for her work on "Murder with Impunity,” a series on unsolved homicides. @kimbriell

Related Tipsheets

No tipsheets have yet been uploaded for this event.