Autoplay
Autocomplete
Previous Lesson
Complete and Continue
The QUERY Function in Google Sheets
Introduction
Course Introduction (8:17)
Templates
Join The Course Community
QUERY Function Basics
What is the QUERY function? (8:58)
Referencing Data (7:02)
Header Row (6:38)
QUERY function versus Pivot Table (12:51)
The Shape of Data: Tall vs. Wide (6:45)
QUERY Function Keywords
SELECT clause (8:16)
WHERE clause (7:38)
GROUP BY clause (8:13)
PIVOT clause (3:41)
ORDER BY clause (3:44)
SKIPPING clause (3:45)
LIMIT clause (3:16)
OFFSET clause (4:30)
LABEL clause (5:19)
FORMAT clause (5:55)
OPTIONS clause (2:27)
EXERCISE: Keywords
SOLUTION: Keywords (4:04)
Functions inside the QUERY Function
Aggregation Functions (7:26)
Arithmetic Operators (9:32)
EXERCISE: Functions
SOLUTION: Functions (7:47)
Filtering Data With WHERE
Comparison Operators (6:09)
Finding Blanks and Non-Blanks (Null and Not Null Values) (2:44)
Contains (4:52)
Starts With (3:28)
Ends With (2:53)
Like And Wildcards (9:42)
Matches And REGEX (12:28)
Escape Characters (6:33)
OR + Join (8:39)
Lower And Upper Functions (6:37)
EXERCISE: WHERE Filters
SOLUTION: WHERE Filters (9:53)
Summarizing Data with GROUP BY and PIVOT
Group By (group data into categories) (6:50)
Group By Multiple Columns (5:32)
Pivot (8:29)
Subqueries (multiple QUERY functions) (10:11)
EXERCISE: Aggregation Techniques
SOLUTION: Aggregation Techniques (7:24)
Working with Dates and Times in the QUERY Function
Keywords (Scalar Functions) (6:31)
Dates in WHERE (6:47)
Date and Time Literals (8:45)
Dynamic Dates in WHERE (6:27)
DateDiff (7:08)
toDate (and finding Top 10 example) (6:08)
Time Functions (5:47)
Minutes Example (9:00)
EXERCISE: Dates and Times
SOLUTION: Dates and Times (5:48)
Format Data With The FORMAT Keyword
Format Numbers (3:33)
Format Dates (3:53)
Format Times (3:27)
Rounding Numbers (2:31)
EXERCISE: Format
SOLUTION: Format (3:14)
QUERY Function Syntax Tips
Reference Other Cells (4:39)
Col1 Notation (8:19)
Single and Double Quotes (5:48)
Robust column referencing (14:58)
Multi-line & Comments in Query (5:18)
Omit select clause (3:46)
EXERCISE: Syntax Tips
SOLUTION: Syntax Tips (5:06)
Other Advanced QUERY Techniques
Constant Value (7:00)
Mixed datatypes (9:50)
Replacing Empty Results With 0 (6:15)
Headers Trick (4:07)
Select Multiple Columns Shortcut (9:41)
QUERY Function Case Studies
Percentage Example (6:01)
Frequency Example (12:30)
Total Row Example (9:42)
Subtotals (7:03)
Dynamic Dashboard (28:19)
Joining Data Tables (15:23)
Over To You
Refer a friend...
Course Feedback
Mixed datatypes
Lesson content locked
If you're already enrolled,
you'll need to login
.
Enroll in Course to Unlock