Back to Browse

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

26.7K views
Jan 6, 2020
11:08

πŸ‘πŸ‘If you have found this content useful and want to show your appreciation, please use this link to buy me a beer 🍺. https://www.paypal.com/donate/?hosted_button_id=CGKRY2BAYEQBQ Thank you! πŸ‘πŸ‘ 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 ------------------------

Download

0 formats

No download links available.

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