Google Sheets: The QUERY Function

Wishlist Share

About Course

Use one formula to filter, sort, total and summarise data in Google Sheets. This course explains the QUERY function and its SQL-like query language, including select, where, order by, group by, limit and label, with worked examples and common pitfalls.

Tutwoo is an independent learning provider and is not affiliated with or endorsed by Google. Menu names and features can vary and change with updates. This course is general skills training and is not an accredited qualification.

What Will You Learn?

  • Write QUERY formulas to select and filter columns Sort, limit and rename results Summarise data with group by and aggregate functions Avoid common errors with data types, quotes and headers

Course Content

Course Lessons

  • How QUERY works
  • Selecting, filtering and sorting
  • Summarising with group by
  • Troubleshooting QUERY

Sources & Further Reading
The official guidance this course is based on.

Final Assessment

Student Ratings & Reviews

No Review Yet
No Review Yet

Want to receive push notifications for all major on-site activities?

✕