Name: Data Mastery with Google Sheets: Essential Formulas and Functions
Start: 2025-03-13T10:30:00-0400
End: 2025-03-13T11:20:00-0400

The METAA CTO Clinic will be held on Thursday, March 13, 2025 at our NEW location, Best Western Royal Plaza Hotel in Marlborough, MA. Thank you to our sponsors for supporting this event! We look forward to reconnecting with all of you! To register for the METAA CTO Clinic, please use this link! Do not register through sched.org Please review our event code of conduct.

To stay informed, follow us @TechDirectors #METAA Please visit METAA Conferences for more information!

Thursday March 13, 2025 10:30am - 11:20am EDT

Salon A

Are you familiar with spreadsheets, but looking to leverage the full potential of Google Sheets? This workshop explores key formulas and functions that will streamline your data analysis and reporting workflows. We'll delve into powerful tools like XLOOKUP for efficient data retrieval, IMPORTRANGE for seamless data integration across spreadsheets, and explore array formulas for handling complex calculations with ease. Discover how Google Sheets facilitates real-time collaboration, simplifies data validation, and provides robust version history for audit trails and peace of mind. Learn practical applications for managing technology inventory, analyzing help desk ticket data, tracking project progress, and more. Leave this session equipped to confidently automate tasks, generate insightful reports, and make data-driven decisions with Google Sheets.

Speakers

Jennifer Judkins

Director of Technology, Wayland Public Schools

Jenn Judkins is the Director of Technology at Wayland Public Schools in Massachusetts. She is a Google Certified Trainer and Innovator (#NYC19) with over 20 years in K-12 schools. Jenn is committed to supporting thoughtful and responsible integration of digital tools as a regular... Read More →

Jonathan Schmid

Director of Technology, Meadowbrook School of Weston

CTO25 How Did I Function without You The Google Sheets Functions I wish I had learned sooner. pdf

Thursday March 13, 2025 10:30am - 11:20am EDT
Salon A

Tangerine, Session 3 (10:30-11:20 a.m.)

Feedback form is now closed.

METAA CTO Clinic 2025

Jennifer Judkins

Jonathan Schmid

Sign up or log in to save this to your schedule, view media, leave feedback and see who's attending!