FY23 A.I. How to Leverage Spreadsheets for Salary Projections (Repeated Session)

*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

David Coelho (Moderator)

Assistant Superintendent for Finance and Operations

Lexington Public Schools

David has been the Assistant Superintendent for Finance and Operations with the Lexington Public Schools since July 2019.  Prior to joining Lexington, he was the Director of Finance in the Bedford Public Schools for sixteen years.  David came to public education after ten years of service in state government and the nonprofit sector.  He holds a BA in Government and Economics form Clark University and a Masters in Public Administration from Suffolk University.

Key:

Complete
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.
You must register to access.
Slide Deck: How to Leverage Spreadsheets for Salary Projections
Open to download resource.
Open to download resource.
You must register to access.
Spreadsheet Folder Link
Select the "View On-Demand Recording" button to begin.
Select the "View On-Demand Recording" button to begin.
You must register to access.
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.
You must register to access.
PDP Certificate
1.00 PDP credit  |  Certificate available
1.00 PDP credit  |  Certificate available
You must register to access.