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 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.

December 4th, 2019 9:00 AM   through   11:00 AM
Event Fee(s)
VSP $ 20.00
Other $ 50.00
Event Tags
Audience Targeted (L) - School Leader, (D) - Data Manager, (H) - Human Resources Manager
Subject Matter Data
Workshop
Strand Business, Operations and Compliance
Activity Workshop

Please let your friends, colleagues and followers know about this page by clicking a social button below or by sharing the following url:
https://www.focusdc.org/civicrm/event/info?id=424&reset=1