Google Sheets QUERY Topics

1. Query Syntax Basics

• Query structure: =QUERY(data, query, [headers])
• Data range understanding
• Quotation rules for strings

---

2. SELECT Clause

• Selecting specific columns
• Using column letters or numbers
• Selecting all columns: SELECT *
• Renaming columns (with label clause)

---

3. WHERE Clause (Filtering Data)

• Basic conditions: =, !=, <, >, <=, >=
• Logical operators: AND, OR
• Text filtering with contains, starts with, matches
• Date filtering with date keyword

---

4. ORDER BY Clause

• Sorting results ascending or descending
• Sorting by multiple columns

---

5. LIMIT & OFFSET

• Limiting the number of results
• Skipping rows with OFFSET

---

6. LABEL Clause

• Renaming columns in the output

---

7. FORMAT Clause

• Formatting numeric, date, or text outputs

---

8. GROUP BY & Aggregation

• Grouping rows based on column values
• Aggregation functions:
  • SUM()
  • AVG()
  • MAX()
  • MIN()
  • COUNT()

---

9. Pivot Tables with QUERY

• Using PIVOT keyword for summary reports

---

10. Handling Blank or Missing Data

• Filtering out blanks
• Using IS NOT NULL

---

11. Working with Dates

• Date format compatibility
• Using date 'YYYY-MM-DD' in queries
• Extracting specific date parts with functions

---

12. Advanced Text Search

• Using matches for regex patterns
• contains for substring searches
• Case sensitivity considerations

---

13. Combining QUERY with Other Functions

• ARRAYFORMULA
• IMPORTRANGE inside QUERY
• IFERROR with QUERY
• QUERY on filtered ranges

---

14. Real-Time Data Integration

• Pulling live data from other sheets
• Dynamic ranges with named ranges or formulas

Register Now →