Data Workshop Series: Excel Advanced Topics
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.