FY23 A.I. How to Leverage Spreadsheets for Salary Projections

*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

Components visible upon registration.