Data Workshop Series: Excel Advanced Topics
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 for those with limited or no experience using VLOOKUP. The ability to dynamically lookup and retrieve information is a game-changer for many DC education data users. In addition, this concept is 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.