Data Workshop Series: Excel Bootcamp
TOPIC Overview of Core Concepts
PRESENTERS Angela Morgan, KIPP Foundation and Katie Newmark, KIPP DC
AUDIENCE School Data Users (Preference will be given to LEAs)
DETAILS This intensive Excel Bootcamp will give school data users the ability to comfortably use Excel to manipulate, analyze, and visualize data. You’ll start with the basics – learning how to create new spreadsheets, enter and manipulate data in cells, and create basic pivot tables. Topics covered in this session: Formatting, basic calculations, ROUND, MIN/MAX, SUM/AVERAGE/MEDIAN/MODE, COUNT, COUNTA, Absolute Cell Referencing, IF, VLOOKUP, Pivot Tables, keyboard shortcuts.
No prior experience necessary required for this session. Participants are required to bring a laptop and charger.