FY23 A.I. How to Leverage Spreadsheets for Salary Projections (Repeated Session)
-
Register
- Community Admin - Free!
*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)
Director of Finance
Weston Public Schools
David has been the Director of Finance with the Weston Public Schools since July 2025. Prior to joining Weston, he was the Assistant Superintendent for Finance and Operations in the Lexinton Public Schools for six years and 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.