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.

December 19th, 2018 8:30 AM   through   10:30 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://focusdc.org/civicrm/event/info?id=358&reset=1