The Query function in Google Sheets is a powerhouse! It combines the capabilities of arithmetic functions with filtering abilities and you can use dynamic settings using nested vlookups. I’m going to simplify the query function, show you how to get started, along with some demonstrations on the power this unlocks for you.

Video

Slides

Key takeaways from Hannah:

• The Query function in Google Sheets is a powerhouse!
• Query combines filtering with arithmetic functions and aggregation such as AVG. SUM, MAX, COUNT, allowing you to both cleanse and calculate in a single query.
• You are able to use dynamic settings using nested vlookups.