FY23 A.I. How to Leverage Spreadsheets for Salary Projections
-
Register
- Community Admin - Free!
Already registered?
Log in now.
*Bring your laptop to this session. 25 person maximum.* Attendees will learn how to create pivot tables and use various Excel/Google Sheet formulas to calculate a salary projection tool. The presenter will walk attendees through step by step how to leverage SUMIFS, VLOOKUP, Pivot Tables, CONCATENATE vs &,, and Data Validation. The presenter will provide any helpful tips and tricks to any function taught in the session.
Michael Mason
Chief Financial Officer
City of Chelsea
Dr. James Mealey (Moderator)
Assistant Superintendent for Finance and Operations
North Andover Public Schools
BS History - Northeastern University, MBA - Boston University, Ed.D. - New England College; Assistant Superintendent for Finance and Operations, North Andover Schools, since 2009; MASBO Board member
Key:
Complete
Next
Failed
Available
Locked
Attendance
Enter code to continue.
Enter code to continue.
To record your attendance, enter the verification code provided by the session's moderator.
Slide Deck: How to Leverage Spreadsheets for Salary Projections
Open to download resource.
Open to download resource.
Spreadsheet Folder Link
Select the "View On-Demand Recording" button to begin.
Select the "View On-Demand Recording" button to begin.
Session Evaluation: How to Leverage Spreadsheets for Salary Projections
Select the "BEGIN" button to begin.
Select the "BEGIN" button to begin.
Upon completion of this survey, your PDPs will automatically appear in your MASBO transcript.