Google Sheets QUERY Function Tutorial (Step-by-Step)

Published: 15 May 2026
on channel: Hablo Tech

Master the QUERY function in Google Sheets to filter, sort, and aggregate your data with a single powerful formula! In this step-by-step tutorial, you'll learn how to use SELECT, WHERE, ORDER BY, and GROUP BY clauses on a real employee dataset.

📖 Written version with a worked example you can copy: https://hablotech.com/functions/query/
Every example on the page was run in a real spreadsheet and captured.

We build an employee table from scratch and write three QUERY formulas that show off the function's most useful capabilities — filtering by department, sorting by salary, and summing totals by group.

⏱️ TIMESTAMPS:
0:00 - Intro
0:05 - Rename the spreadsheet
0:10 - Type column headers
0:17 - Enter first employee row (pattern)
0:23 - Fill remaining employee rows
0:32 - Review completed employee table
0:40 - First QUERY: filter with WHERE
1:41 - Second QUERY: sort with ORDER BY
2:22 - Third QUERY: aggregate with GROUP BY + SUM
3:15 - Final review of all three QUERY blocks

📊 WHAT YOU'LL LEARN:
• How the QUERY function syntax works in Google Sheets
• Filtering rows with the WHERE clause
• Sorting results with ORDER BY (ascending and descending)
• Aggregating data with GROUP BY and SUM
• Using the header argument so column titles carry through

The QUERY function is one of the most powerful formulas in Google Sheets — once you learn it, you can replace dozens of FILTER, SORT, and SUMIF formulas with a single clean expression.

👍 If this tutorial helped you, please LIKE and SUBSCRIBE to Hablo Tech for more Google Sheets tips, formulas, and productivity tutorials!

#GoogleSheets #QueryFunction #SpreadsheetTutorial

On this page of the site you can watch the video online Google Sheets QUERY Function Tutorial (Step-by-Step) with a duration of hours minute second in good quality, which was uploaded by the user Hablo Tech 15 May 2026, share the link with friends and acquaintances, this video has already been watched 17 times on youtube and it was liked by 0 viewers. Enjoy your viewing!

38,835

566