Are you looking for ways to become more efficient and effective as an admission and enrollment professional? Do you find that you have to constantly reformat charts and dashboards and use the “cut and paste” feature to move data or worse have to retype and re-enter data completely? Do you live in fear of having your boss or head of school ask for data (immediately!) and having to spend hours pulling your data together to produce some sort of legible dashboard?
Do not fear, this 3 hour class on the essentials of excel and google sheets is just for you and will improve your life in more ways than you can even imagine! After all, “You don’t know what you don’t know.”
Join three self-proclaimed spreadsheet nerds who will share excel and google sheet tips and tricks and teach you how to use pivot tables and forecasting techniques as you look toward 2021-2022 and a new enrollment season.
No previous spreadsheet experience is needed. This is a class for everyone and all levels are welcome!
Class Format: A "fake" data set will be shared in advance of the class so that participants can follow along and practice techniques. There will also be time to work in small groups and work on the new techniques together.
April 20 from 12:00 - 1:30 pm ET
Day 1 | Spreadsheet Fundamentals
We will go through a step-by-step process on how to create a dashboard that can be updated instantly and used for reporting.
April 22 from 12:00 - 1:30 pm ET
Day 2 | Pivot Tables and Forecasting Techniques
We will build upon the skills taught in the day 1 by teaching how to create and use Pivot Tables as well as Forecasting techniques.
Don’t miss this opportunity to build new skills and become more efficient and effective as an admission, enrollment, and financial aid professional. This class will CHANGE THE WAY YOU WORK.