Excel Bootcamp: Overview of Core Concepts
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.
Participants are encouraged to register for both Excel sessions on Saturday, October 14th, but MUST be proficient in all topics covered in the Core Concepts session to register for the Deep Dive into Advanced Excel Concepts session.
Lunch will be provided.
|VSP morning session only||$ 20.00|
|VSP morning and afternoon sessions||$ 30.00|
|Other morning session only||$ 50.00|
|Other morning and afternoon sessions||$ 75.00|