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