Data Workshop Series: Excel Advanced Topics - Pivot Tables & IF Functions
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 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. You will then be able to choose between learning more about pivot tables or learning 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.
Participants are required to bring a laptop with Excel installed and charger.