Excel Boot Camp: 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.
Data Workshop Series: Excel Boot Camp
|
TOPIC |
Deep Dive into Advanced Excel Concepts |
|
DATE |
Saturday, January 28th, 2017 |
|
TIME |
1pm - 3pm 12:30-1:00- lunch |
|
AUDIENCE |
School Data Users (Preference will be given to LEAs) |
|
DETAILS |
This Excel boot camp 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 Excel Basics- Overview of Core 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. 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. |
|
COST |
VSP - $20 for one session or $30 for both sessions (must be registered for both morning and afternoon sessions) Lunch will be provided |
United States
| 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
|
