Excel: Advanced pivot tables

  • Event: 2019 CAR Conference
  • Speaker: Kimbriell Kelly of Los Angeles Times
  • Date/Time: Friday, Mar. 8 at 9:00am
  • Location: Salon 3
  • Audio file: No audio file available.

You've done a few pivot tables and are getting curious what more you could do with them. What happens if you aggregate by more than one column? What are those "column" and "filter" boxes for? Come unlock the full potential of pivot tables in this intermediate spreadsheet class.

This session is good for: People familiar with spreadsheets and aggregating data with pivot tables, or anyone who has taken Excel 1-3.

Speaker Bios

  • Kimbriell Kelly is deputy editor for Enterprise & Investigations at the D.C. Bureau of the LA Times. A former investigative reporter at The Washington Post, she was part of a team that won the 2016 Pulitzer Prize documenting fatal police shootings; also a 2019 Pulitzer finalist for series on unsolved murders. Her 2016 series on housing disparities won an NABJ Salute to Excellence Award, and prior housing reporting sparked a lawsuit resulting in an $8.7 billion settlement. @kimbriell

Related Tipsheets

No tipsheets have yet been uploaded for this event.