Excel 2: Functions and pivot tables
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.
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
No tipsheets have yet been uploaded for this event.