Excel Bootcamp: Deep Dive into Advanced Excel Concepts
TOPIC Deep Dive into Advanced Excel Concepts
PRESENTERS Angela Morgan, KIPP Foundation and Angie Martinez, KIPP DC
AUDIENCE School Data Users (Preference will be given to LEAs)
DETAILS This Excel Bootcamp will be a deep dive into Excel concepts that will give school data users the ability to comfortably use Excel to analyze and visualize data.
Topics covered in this session: IF functions, Advanced IFs, Date/Time Calculations, INDEX, MATCH, Text Manipulation, SORT/Filter, calculations across sheets and workbooks, Conditional Formatting, Data Validation, Protection, Database, Connections.
Participants are encouraged to register for both Overview of Core Excel Concepts and Deep Dive into Advanced Excel Concepts sessions, but MUST be proficient in all topics covered in the morning session to register for the afternoon session. *Payment for the full day will be made during registration for the Excel Basics Workshop; registration for both sessions is still required
Prerequisite topics covered at basics session: Formatting, basic calculations, ROUND, MIN/MAX, SUM/AVERAGE/MEDIAN/MODE, COUNT, COUNTA, Absolute Cell Referencing, IF, VLOOKUP, Pivot Tables, keyboard shortcuts.
Lunch will be provided
|VSP afternoon session only||$ 20.00|
|VSP morning and afternoon sessions||$ 0.00|
|Other afternoon session only||$ 50.00|
|Other morning and afternoon sessions||$ 0.00|