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

Share this & earn $10
Learn Google Spreadsheets
Published at : 26 Sep 2021
453428 views
3910
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

Intro to Economics: Crash Course Econ #1

Intro to Economics: Crash Course Econ #1

Saif Nabeel - Loo [Music Video] (2020) / سيف نبيل - لو

Saif Nabeel - Loo [Music Video] (2020) / سيف نبيل - لو

She Cracked me HARDER than my HUSBAND?!  Adjusted by LADY CHIROPRACTOR!

She Cracked me HARDER than my HUSBAND?! Adjusted by LADY CHIROPRACTOR!

Patience

Patience

Ellen Meets the ‘Apparently’ Kid, Part 2

Ellen Meets the ‘Apparently’ Kid, Part 2

How to Bypass A Broken File: Friday Questions

How to Bypass A Broken File: Friday Questions

Galaxy Z fold 4 Lacking BEST S Pen Features | Galaxy Z Fold 3 One UI 4 3rd Beta

Galaxy Z fold 4 Lacking BEST S Pen Features | Galaxy Z Fold 3 One UI 4 3rd Beta

Try - Pink (Lyrics) 🎵

Try - Pink (Lyrics) 🎵

Levels (Radio Edit)

Levels (Radio Edit)

8 CRAZY WAYS TO SNEAK FOOD INTO ZOMBIE CLASS | FUNNY WAYS TO SNEAK SNACKS IDEAS BY CRAFTY HACKS

8 CRAZY WAYS TO SNEAK FOOD INTO ZOMBIE CLASS | FUNNY WAYS TO SNEAK SNACKS IDEAS BY CRAFTY HACKS

Top 10 Amenities Under $100 to Provide For Your Airbnb Guests: Airbnb Tips For New Hosts

Top 10 Amenities Under $100 to Provide For Your Airbnb Guests: Airbnb Tips For New Hosts

Norah Jones - Sunrise (Official Music Video)

Norah Jones - Sunrise (Official Music Video)

The MOST EFFECTIVE Way To Attract Girls

The MOST EFFECTIVE Way To Attract Girls

Jubi & Jang Yi Jeong - Confusing FMV (Girl Who Sees Smell OST)[ENG + Rom + Hangul]

Jubi & Jang Yi Jeong - Confusing FMV (Girl Who Sees Smell OST)[ENG + Rom + Hangul]

Sharpay, Ryan - Fabulous (from High School Musical 2) (Official Video)

Sharpay, Ryan - Fabulous (from High School Musical 2) (Official Video)

Материал

Материал

HOW TO TEACH ONLINE (Top Tips for New Online Teachers!)

HOW TO TEACH ONLINE (Top Tips for New Online Teachers!)

Julie and the Phantoms - Edge of Great (Lyrics) (From Julie and the Phantoms)

Julie and the Phantoms - Edge of Great (Lyrics) (From Julie and the Phantoms)

A child Meme

A child Meme

📚Parts By Tedd Arnold// A READ ALOUD

📚Parts By Tedd Arnold// A READ ALOUD

Red Hot Chili Peppers - Around The World [Official Music Video]

Red Hot Chili Peppers - Around The World [Official Music Video]

The Beauty Of The Green Knight

The Beauty Of The Green Knight

Now and Again - 01 - Origins

Now and Again - 01 - Origins

The long run, an inside view

The long run, an inside view

LIVE SECRETA | FLUENCY PROJECT

LIVE SECRETA | FLUENCY PROJECT

Saving our FRIEND from a VAMPIRE in Minecraft!

Saving our FRIEND from a VAMPIRE in Minecraft!

Tom Morello - Hold the Line (feat. grandson) [Official Audio]

Tom Morello - Hold the Line (feat. grandson) [Official Audio]

To Be Alone With You

To Be Alone With You

Causes of Muscle Soreness - Coursera Science of Exercise

Causes of Muscle Soreness - Coursera Science of Exercise

Creedence Clearwater Revival - Have You Ever Seen The Rain (Official)

Creedence Clearwater Revival - Have You Ever Seen The Rain (Official)

My job my memory...

My job my memory...

Australian Crawl Things Don't Seem Lyrics

Australian Crawl Things Don't Seem Lyrics

Julie and the Phantoms - Wake Up (Lyrics) (From Julie and the Phantoms)

Julie and the Phantoms - Wake Up (Lyrics) (From Julie and the Phantoms)

Sofia the First - For One and All

Sofia the First - For One and All

Everything Wrong With A View To Kill In 18 Minutes Or Less

Everything Wrong With A View To Kill In 18 Minutes Or Less

Singer R. Kelly Found Guilty

Singer R. Kelly Found Guilty

Making the Most of Your Life: Lama Yeshe

Making the Most of Your Life: Lama Yeshe

How to Quote in Under 5 minutes | Scribbr 🎓

How to Quote in Under 5 minutes | Scribbr 🎓

LUCIDS : PART ONE

LUCIDS : PART ONE

Ubuntu 12.04 Forensics - File Carving using Foremost

Ubuntu 12.04 Forensics - File Carving using Foremost

MUTEMATH - Cut and Glued (Extended Version)

MUTEMATH - Cut and Glued (Extended Version)

I got in the GUINNESS BOOK of WORLD RECORDS!!

I got in the GUINNESS BOOK of WORLD RECORDS!!

Activision Pay Train, Warzone Dying, Gunsmith vs Traditional, and MUCH More

Activision Pay Train, Warzone Dying, Gunsmith vs Traditional, and MUCH More

Mungo Jerry - In The Summertime ORIGINAL 1970

Mungo Jerry - In The Summertime ORIGINAL 1970

bath

bath

'Vacationing' Summer Karaoke Music Video | ALVINNN!!! and the Chipmunks | Nick

'Vacationing' Summer Karaoke Music Video | ALVINNN!!! and the Chipmunks | Nick

This is a Skoda Superb but not as you know it

This is a Skoda Superb but not as you know it

DaBaby - BOP on Broadway (Hip Hop Musical)

DaBaby - BOP on Broadway (Hip Hop Musical)

Moving Into My Dream NYC Apartment

Moving Into My Dream NYC Apartment