The QUERY Function in Google Sheets

Work more effectively with your data by mastering the most powerful function in Sheets

The QUERY function is the most powerful function in Google Sheets.

You can use the QUERY function to:

  • Prepare data for use in charts and dashboards
  • Select specific rows or columns from data sets
  • Combine with drop-down menus and checkboxes to create dynamic reports
  • Combine multiple data sets
  • Drill into large data sets to create summary reports
  • Present portions of data sets on separate Sheets
  • Take advantage of pivot table type functionality, without the complex and intrusive pivot table controls
  • Present data in a friendly way for non-spreadsheet people

Working with data can be tough.

You need to juggle hundreds of formulas, pivot tables, charts, statistics, and databases.

The QUERY function is a single function that does a lot of that heavy lifting for you.

The QUERY function is different from other functions in Google Sheets. It can perform the actions of many other functions, such as filtering, sorting, or aggregating your data.

It’s known as the pivot table in function form.

It uses a special QUERY language to analyze data, which is tricky if you haven’t used it before.

This course covers everything from the basics of the QUERY function syntax to advanced methods for data analysis.

This course is practical and hands-on. At every step of the way, you’re encouraged to follow along and write your own QUERY statements.

Get started now!



By the end of this course, you'll understand:

  • What the QUERY function is
  • Why the QUERY function is so useful
  • How to use the different parts of a QUERY function, for example, grouping, filtering, labeling, etc.
  • How to write QUERY function statements to solve real problems
  • How to work more effectively with data in your Google Sheets

Who this course is for:

  • Beginner to advanced Google Sheets users
  • People who want to work with data more effectively
  • Individuals looking to master the QUERY function

This course will teach you how to use the powerful QUERY function and incorporate it into data analysis workflows.

If you're new to the QUERY function, you'll learn:

  • What the QUERY function is and why you should use it
  • How the QUERY language works
  • How to use the keywords and know what order they go in

If you already use the QUERY function, this course will:

  • Teach you all the advanced keywords and functions so you can master the QUERY function
  • Teach you tricks and best practices: how to filter with apostrophes, how to reference other cells, how to combine data with array literals, how to query queries, and much more
  • Show you how to apply the QUERY function to a variety of different questions and real-world datasets

Enroll now and get:

  • Actionable, 5 - 10 minute video lessons that walk you step-by-step through techniques
  • Access to the QUERY Function Course Templates, which you can copy and reuse as many times as you like
  • Access to the private course community group for Q&A
  • Certificate upon completion you can put on your resume

The QUERY Function Course Templates

Your course purchase includes the QUERY Function Course templates.

These are a series of Google Sheet files packed with 100's examples of QUERY formulas.

You're free to make your own copies of these templates, which are yours to modify, adapt and evolve however you wish.

Get started now!



Your Instructor


Ben Collins
Ben Collins

Hi! I'm an experienced data analytics instructor and freelance spreadsheet developer.

I help individuals and businesses better understand their data through analytical insights and visualizations.

Over 50,000 professionals from 1,000+ companies have enrolled in my training courses, including employees from PwC, Netflix, Verizon, Google, Capital One, and other Fortune 500 companies.

My training has helped 1,000’s of people advance their careers. I’ve also helped small and large organizations migrate from Microsoft Excel and Office to Google Sheets and Google Workspace.

Google recognized me as a Google Developer Expert for Google Workspace Technology in 2019, one of only a handful worldwide.

I work primarily with Google Sheets and Apps Script, and also have extensive experience with Google Looker Studio, Microsoft Excel, BigQuery, SQL, and Tableau. I've previously taught data courses and workshops for General Assembly in Washington, D.C..


Course Curriculum


  Introduction
Available in days
days after you enroll
  QUERY Function Basics
Available in days
days after you enroll
  QUERY Function Keywords
Available in days
days after you enroll
  Functions inside the QUERY Function
Available in days
days after you enroll
  Filtering Data With WHERE
Available in days
days after you enroll
  Summarizing Data with GROUP BY and PIVOT
Available in days
days after you enroll
  Working with Dates and Times in the QUERY Function
Available in days
days after you enroll
  Format Data With The FORMAT Keyword
Available in days
days after you enroll
  QUERY Function Syntax Tips
Available in days
days after you enroll
  Other Advanced QUERY Techniques
Available in days
days after you enroll
  QUERY Function Case Studies
Available in days
days after you enroll
  Over To You
Available in days
days after you enroll

Frequently Asked Questions


When does the course start and finish?
The course starts now and never ends! It is a completely self-paced online course - you decide when you start and when you finish.
How long do I have access to the course?
How does lifetime access sound? After enrolling, you have unlimited access to this course for as long as you like - across any and all devices you own.
What if I am unhappy with the course?
We would never want you to be unhappy! If you are unsatisfied with your purchase, contact us in the first 14 days and we will give you a full refund.
How much time does the course take to complete?
I’ve created a lot of content for you… over 4 hours of video content and 100's of formula examples. Depending on your experience and comfort with formulas and advanced concepts, I’d estimate that it will take you 5 - 20 hours total time to get comfortable with the material. HOWEVER… I know you’re busy so each topic is divided into a series of 10-20 minute videos so you don’t have to plan days and days around studying this topic. I’d advocate doing the lessons in batches spread across a few weeks or months, to give yourself time to absorb the knowledge.
Will I get copies of the datasets and solutions?
Yes! All the templates and solutions are provided, so you can download your own copies. Clicking on the template links will open the files so you can make a copy on your Drive account.
How do I get access to the private course community group?
When you enroll, you’ll receive the link in the last lesson of the introduction chapter. Once you’ve joined, feel free to introduce yourself and let us know how you plan to use your newfound knowledge.
What if I can’t figure out something on my own?
You can ask for help in the private community group for students! As a member of this group, you can ask questions, share your ideas and knowledge, and connect with other students.
What if I don’t have a technical background?
Don't worry, you won't be alone! This course focuses on practical techniques and teaches concepts through real-world examples, so that you won’t get lost in abstract theories and dense lectures. As long as you aren’t afraid to roll up your sleeves and put some effort in, then you’ll be able to grasp the content of this course. You’re free to watch the lessons in any order and as many times as you like, so you can take as long as you want!
Is this course suitable for complete beginners?
Probably not for complete beginners. But, if you're a regular Google Sheets user then you'll be able to master the QUERY function. In this course, I walkthrough the QUERY Function from the ground up, without making any prior assumptions. So even if you've never seen the QUERY function in action before, you won't feel lost.
Do you offer Parity Purchasing Power discounts?
Yes, I want my courses to be affordable to folks overseas in developing countries, who would otherwise not be able to purchase them. How does it work? Drop me a line with proof of where you're based and I'll be glad to offer you a PPP discount on the course.
Why am I being charged sales tax or VAT?
In order to comply with regulations in some US States, the EU, and other overseas countries, some buyers may be charged sales tax or VAT at checkout. This money is passed on to the relevant tax collection agency.
Can you provide an invoice for my company?
Yes, of course! You’ll receive a receipt after you purchase, but if you need something additional, please contact us and we can provide an invoice.
My company is interested in a bulk order. Do you have enterprise deals?
Yes, please email us at [email protected] and we can discuss details.
Does the course have closed captions available?
Yes! Every video has closed captions, which can be toggled on/off by the video controls.

The QUERY Function in Google Sheets.

So incredible I made a whole course about it.

Get started now!