![](/accounts/masbo/images/logo.png)
FY23 A.I. How to Leverage Spreadsheets for Salary Projections
-
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.
![Speaker image](https://ffa048ace9b37a86688f-42a6cae00dd13a718576d2e4ef6ca30a.ssl.cf2.rackcdn.com/masbo_b054438b6aa2cfceb65ba9eb6648fd39.jpg)
Michael Mason
Chief Financial Officer
Arlington Public Schools
![Speaker image](https://ffa048ace9b37a86688f-42a6cae00dd13a718576d2e4ef6ca30a.ssl.cf2.rackcdn.com/masbo_e1b8360f2c1ede4f1d74e120bb201a7f.jpg)
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:
![](/images/product-status-icons/complete-small.png)
![](/images/product-status-icons/next-small.png)
![](/images/product-status-icons/disabled-small.png)
![](/images/product-status-icons/optional-small.png)
![](/images/product-status-icons/locked-small.png)