Data Workshop Series: Excel Advanced Topics
Please visit www.dccharters.org to learn about our new organization and to see the latest news and information related to DC charter schools.
The FOCUS DC website is online to see historic information, but is not actively updated.
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.
Event Fee(s) | |
VSP | $ 20.00 |
Other | $ 50.00 |
Event Tags
|
Workshop
|