The Google Sheets Query Function
Buy now
Learn more
Getting Started with Sheets Queries
Browse the Sample Dataset
Writing your first Sheets Query
Date Comparisons in Queries: Why so Complex?
Query multiple Google Sheets: IMPORTRANGE + {} = FRIENDS
Writing Basic Queries
Intro: Doing Math in Queries
Question 1: Pulling the Top Questions
Question 2: Who are the Top Tweeters?
Question 3: What's the Most Active Day of the Week?
Quiz 1: Basic Querying
Writing Advanced Queries
Intro: Diving Deeper
Question 4: What's the Top Hour of the Day?
Question 5: What are the Most-Used Hashtags?
Question 6: Whata Domains are Most-Tweeted?
Quiz 2: Advanced Querying
Bonus Section: Learn SQL too
Transitioning from Query Functions to SQL
Learn SQL in a Spreadsheet
Products
Course
Section
Writing Advanced Queries
Writing Advanced Queries
The Google Sheets Query Function
Buy now
Learn more
Getting Started with Sheets Queries
Browse the Sample Dataset
Writing your first Sheets Query
Date Comparisons in Queries: Why so Complex?
Query multiple Google Sheets: IMPORTRANGE + {} = FRIENDS
Writing Basic Queries
Intro: Doing Math in Queries
Question 1: Pulling the Top Questions
Question 2: Who are the Top Tweeters?
Question 3: What's the Most Active Day of the Week?
Quiz 1: Basic Querying
Writing Advanced Queries
Intro: Diving Deeper
Question 4: What's the Top Hour of the Day?
Question 5: What are the Most-Used Hashtags?
Question 6: Whata Domains are Most-Tweeted?
Quiz 2: Advanced Querying
Bonus Section: Learn SQL too
Transitioning from Query Functions to SQL
Learn SQL in a Spreadsheet
Now that you've got the hang of the QUERY function, we'll dive further into how you can use it for complex analysis. You can follow along using the same sample spreadsheet you copied in the last section.
5 Lessons
Intro: Diving Deeper
Question 4: What's the Top Hour of the Day?
Question 5: What are the Most-Used Hashtags?
Question 6: Whata Domains are Most-Tweeted?
Quiz 2: Advanced Querying