QUERY Function in Google Sheets - Basic Overview
Learn how to use the QUERY function to analyze your spreadsheet table with the power of SQL. The function is tricky to learn but potent once you get it down.
Website: https://sheetshelp.com/query/
Timestamps:
0:00 Intro
0:21 Data for the query
0:40 Query syntax
1:02 SELECT the columns
3:16 Return all values matching a word using WHERE
4:18 Use math inside of WHERE
5:39 Add a column LABEL
6:50 Join clause with AND
8:28 Return top or bottom results with LIMIT
9:00 Sort with ORDER BY
9:43 Aggregate values with SUM and GROUP
10:40 Move values into columns with PIVOT
11:23 Next video - SORT Function
#googlesheets #spreadsheet #query
On this page of the site you can watch the video online QUERY Function in Google Sheets - Basic Overview with a duration of hours minute second in good quality, which was uploaded by the user Sheets Help 13 November 2021, share the link with friends and acquaintances, this video has already been watched 2,301 times on youtube and it was liked by 44 viewers. Enjoy your viewing!
