Data Workshop Series: Excel Advanced Topics - VLOOKUP

Friends of Choice in Urban Schools (FOCUS) is now the DC Charter School Alliance!

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.
 Registration is closed for this event

TOPIC     VLOOKUP

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.

February 11th, 2020 9:00 AM   through   11:00 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://www.focusdc.org/civicrm/event/info?id=428&reset=1