Excel Bootcamp: Deep Dive into Advanced Excel Concepts
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.
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
| Event Fee(s) | |
| 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 |
|
Event Tags
|
|
Workshop
|
