Data Workshop Series: Excel Advanced Topics

This event is currently full. However you can register now and get added to a waiting list. You will be notified if spaces become available.

TOPIC     VLOOKUP and INDEX MATCH 

PRESENTERS     Angela Morgan, KIPP Foundation and Katie Newmark, KIPP DC

AUDIENCE     School Data Users (Preference will be given to LEAs)

DETAILS  This workshop will be a deep dive into concepts that will give school data users the ability to combine data from two or more sources. The workshop will focus on the Excel function VLOOKUP, then we will introduce an advanced method that uses the functions INDEX and MATCH. 

The ability to dynamically lookup and retrieve information is a game-changer for many DC education data users. In addition, both of these concepts are important to know for anyone interested in later learning SQL. 

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.

March 26th, 2019 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=388&reset=1