Excel Bootcamp: Deep Dive into Advanced Excel Concepts

 Registration is closed for this event

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

October 14th, 2017 12:00 PM   through   3:30 PM
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
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://focusdc.org/civicrm/event/info?id=294&reset=1