Google Sheets QUERY Function Tutorial - SELECT, WHERE, LIKE, AND, OR, LIMIT statements - Part 1

Share this & earn $10
Learn Google Spreadsheets
Published at : 22 Oct 2021
461512 views
3994
90

Video tutorial series about QUERY function in Google Sheets.

In this tutorial we’ll cover how to use QUERY function in Google Sheets to pull filtered results out of your main dataset. We’ll use SELECT, WHERE, LIKE, AND, OR and LIMIT statements to filter data by number value, text & text that contains a certain string in it.

Google Sheets
https://www.google.com/sheets/about/

Website:
https://www.chicagocomputerclasses.com/

QUERYGoogle SheetsFunction

B1-Special Occasions: Important Questions

B1-Special Occasions: Important Questions

8 BEST Shooting Techniques in Soccer or Football

8 BEST Shooting Techniques in Soccer or Football

sawing a big oak log

sawing a big oak log

A Great Work

A Great Work

[TEAMSPEAK] ТОП1 на SANHOK PMPL CIS от Team UNIQUE PUBG Mobile

[TEAMSPEAK] ТОП1 на SANHOK PMPL CIS от Team UNIQUE PUBG Mobile

Ed Sheeran - Visiting Hours [Official Lyric Video]

Ed Sheeran - Visiting Hours [Official Lyric Video]

AN ALMOST PERFECT DREAM! / Gabriel Wibmer

AN ALMOST PERFECT DREAM! / Gabriel Wibmer

Dobby is a Free Elf | Harry Potter and the Chamber of Secrets

Dobby is a Free Elf | Harry Potter and the Chamber of Secrets

A surprise performance of Ravel's Bolero stuns shoppers!

A surprise performance of Ravel's Bolero stuns shoppers!

Category Theory 1.2: What is a category?

Category Theory 1.2: What is a category?

Crazy Acts Around The World! | Got Talent Global

Crazy Acts Around The World! | Got Talent Global

ACES Finalist March 2015 - 'Infrequent Flyers Club' Tigerair by McCann Melbourne

ACES Finalist March 2015 - 'Infrequent Flyers Club' Tigerair by McCann Melbourne

Astronaut Ape - Thirty Fourth Ritual

Astronaut Ape - Thirty Fourth Ritual

GOOD SELECTION

GOOD SELECTION

Lil Nas X, Jack Harlow - INDUSTRY BABY (EXTENDED - Official Audio)

Lil Nas X, Jack Harlow - INDUSTRY BABY (EXTENDED - Official Audio)

I've been feeling a lot better...

I've been feeling a lot better...

Format Υπολογιστή Και Εγκατάσταση Windows: Όλη Η Αλήθεια

Format Υπολογιστή Και Εγκατάσταση Windows: Όλη Η Αλήθεια

Wittgenstein: A Wonderful Life (1989)

Wittgenstein: A Wonderful Life (1989)

Minecraft But INVENTORY Makes You GO FASTER!

Minecraft But INVENTORY Makes You GO FASTER!

Mexican Spanish | Can Italian and Portuguese speakers understand it?

Mexican Spanish | Can Italian and Portuguese speakers understand it?

The Age of Liberal Conspiracy Theories?

The Age of Liberal Conspiracy Theories?

10 Things You SHOULD Be Buying at Costco in November 2021

10 Things You SHOULD Be Buying at Costco in November 2021

Tom Misch - You're On My Mind [Official Audio]

Tom Misch - You're On My Mind [Official Audio]

These 10 Companies Produce Almost Everything You Use Every Day...

These 10 Companies Produce Almost Everything You Use Every Day...

Ken Ashcorp - Wear

Ken Ashcorp - Wear

Night-time sector 'has to concede' to ticketing system

Night-time sector 'has to concede' to ticketing system

Ethnix - Open up (Official Video)

Ethnix - Open up (Official Video)

BARRONS 333 High Frequency Word List for the GRE: Part 1 - First 111 Words

BARRONS 333 High Frequency Word List for the GRE: Part 1 - First 111 Words

Phantogram - Black Out Days (Slowed/Lyrics) "And stay, Hey hey hey ah" [Tiktok Song]

Phantogram - Black Out Days (Slowed/Lyrics) "And stay, Hey hey hey ah" [Tiktok Song]

Undercover Millionaire Tries To Give Away A FREE House in Hyde Park, London

Undercover Millionaire Tries To Give Away A FREE House in Hyde Park, London

Nobody - Official Trailer (HD)

Nobody - Official Trailer (HD)

It is advisable to avoid foods containing large amounts of

It is advisable to avoid foods containing large amounts of

A Beautiful Day | Start of the Day Song for Kids | Jack Hartmann

A Beautiful Day | Start of the Day Song for Kids | Jack Hartmann

Shaneil Muir - Exclusive (Official Music Video)

Shaneil Muir - Exclusive (Official Music Video)

#Fanny video #hindi #commend

#Fanny video #hindi #commend

Most Popular Websites 1996 - 2019

Most Popular Websites 1996 - 2019

Ylona Garcia - Each Day (Official Lyric Video)

Ylona Garcia - Each Day (Official Lyric Video)

10 Of The Funniest Parks and Recreation Moments | Comedy Bites

10 Of The Funniest Parks and Recreation Moments | Comedy Bites

Partly Cloudy

Partly Cloudy

Ariana, Kelly, John and Blake Deliver an Incredible Coach Performance | The Voice 2021

Ariana, Kelly, John and Blake Deliver an Incredible Coach Performance | The Voice 2021

WHAT I EAT IN A DAY to shed pounds after 40 + 10 Easy Weight Loss Tips

WHAT I EAT IN A DAY to shed pounds after 40 + 10 Easy Weight Loss Tips

CUP SONG BEST MOMENTS AMONG US is DEFINITELY not appropriate for THIS KID 2

CUP SONG BEST MOMENTS AMONG US is DEFINITELY not appropriate for THIS KID 2

Do These Jokes Pass or Fail? #Shorts

Do These Jokes Pass or Fail? #Shorts

100x SKELETON ARMY vs EVERY GOD | TABS - Totally Accurate Battle Simulator

100x SKELETON ARMY vs EVERY GOD | TABS - Totally Accurate Battle Simulator

The Secret to a Clean and Organized Home

The Secret to a Clean and Organized Home

Mother can only afford one meal to share with her family  | WWYD

Mother can only afford one meal to share with her family | WWYD

D-Block & S-te-Fan & DJ Isaac - World Renowned (Official Video)

D-Block & S-te-Fan & DJ Isaac - World Renowned (Official Video)

TOP 50 FUNNIEST GAMING GLITCHES

TOP 50 FUNNIEST GAMING GLITCHES

(ORIGINAL VIDEO) your not that guy pal trust me your not that guy

(ORIGINAL VIDEO) your not that guy pal trust me your not that guy