How to Use Google Sheet's QUERY Function - SELECT, WHERE, LIKE, GROUP BY, PIVOT

This video demonstrates how to use Google Sheet's QUERY Function - SELECT, WHERE, LIKE, GROUP BY, PIVOT
The video well tell you the following:
How to select which columns you want to include in your query
How to perform calculations on columns - SUM, COUNT
How to specify OR and AND criteria for records to return with your query
How to specify date criteria
How to specify partial critria eg begins with
How to group by unique values within a specified column whilst performing calculations on other columns
How to pivot column headings with your query
------------------------

[@parkhyomi07]

This video was ABSOLUTELY PERFECT to learn how to use the query function! Thank you so much!!

[@alinaghazarians]

Great tutorial. Thank you Chester. I was trying the choose columns function and having so much trouble Followed your instructions and it worked perfectly. LIFE SAVER!

[@joakingart8741]

EXACTLY WHAT I NEED!!! THANKS A LOT. EXCELLENT VIDEO WITH MANY EXAMPLE.

[@jennifercruz1582]

This is extremely helpful! Thank you!

[@ManishLodhi-ek5jx]

very useful and informative

[@najminmaliki9472]

this is very helpful. thank u so so much sir.

[@OIE82]

Mr. Tugwell, that was very informative. Do you know if I can reference a range in the Query function? So, using your example, I would want to reference col "D" as the range "Branch" instead of col "D".

[@justfly2525]

Thanks!

[@LevelEZ]

Thanks

[@music_gum]

How about if i need to count data from multiple column, what will be the formula?

[@isakanderson7722]

I cant figure out how to use where and group by at the same time