Data Workshop Series: Excel Advanced Topics
TOPIC Pivot Tables and Advanced IF
PRESENTERS Angela Morgan, KIPP Foundation and Katie Newmark, KIPP DC
AUDIENCE School Data Users (Preference will be given to LEAs)
DETAILS In this workshop, you will first learn how to make basic pivot tables – a powerful feature of Excel that allows you to quickly and easily gain insights that can be shared with your team. Then learn more about the advanced IF functions [COUNTIF(S), SUMIF(S), AVERAGEIF(S)] that form the tables, giving you greater flexibility to design your own.
Prerequisite topics covered at basics session: Formatting, basic calculations, ROUND, MIN/MAX, SUM/AVERAGE/MEDIAN/MODE, COUNT, COUNTA, Absolute Cell Referencing, IF, keyboard shortcuts.
Light refreshments will be provided.