Google Sheets Query Function Explained

[@LeilaGharani]

Get access to the complete Google Sheets Masterclass here 👉 www.xelplus.com/course/google-sheets/

[@bobbyman410]

The biggest thing I like about Leila is how she interacts with everyone in the comments and considers her viewers as friends. Great content as usual, can't wait for the next video!

[@LeilaGharani]

Thank you! We're friends with similar interests - specially that we all love to learn.

[@charlesrobertthomas]

I've been watching your videos in MS Excel and wanted to try my hand at Google Sheets. This is the first of your videos I've watched on Google Sheets. AWESOME!!!!! Wish I had known earlier that you were a Google Sheets guru as well, it would have saved me a ton of time.

[@nadeemmalik8031]

Google Sheets is really cool. I like the way Leila explains the Query Function. It is very well illustrated and Leila's examples used to explain the topic are always brilliant and well thought out. Leila you really are the best video tutor on KZbin. Your experience and knowledge is exemplary.

[@LeilaGharani]

Glad it was helpful, Nadeem!

[@malikastar9265]

All your tutorials Leila are great, clear and to the point, thank you !

[@abdullahquhtani4247]

You are one of my favorite instructors. I bought your Excel courses on Udemy. BUT this one is beyond my budget as a collage student 😢 I may consider enrolling when there is another discount on next Black Friday or sooner one. Thank you 🙏.

[@jjackson4273]

I was really overwhelmed by the query function, but you made it simple to understand. Thanks so much for this video!

[@davidtmiller56]

Another excellent video. I’ve been using the Query function since 2015. This is an excellent quick overview. Well done.

[@mrashid229]

The best thing about this video is, it is only (12:3৪) long but describes most lucrative aspects of query() and SQL(google sheet) so clearly! Apparently too short (time) to cover so many features. Once again I am amazed by your presentation/delivery skill Leila.

[@LeilaGharani]

Wow, thank you Munim!

[@kerronduncan6697]

I clearly am guilty of underestimating google sheets. Wow powerful function. Thanks for sharing Leila!!

[@LeilaGharani]

Glad it was helpful! There are quite a few hidden gems in sheets.

[@dvd.25]

I saw many videos about query function, but I could not understand and learn enough to use it. Thank you Leila. Now all the concepts got clearer and I learned a lot through this video. I am subscribing you. Thank you again..

[@LeilaGharani]

Happy to hear that, David!

[@mreighties2860]

Also when you QUERY within same workbook and have data on multiple tabs that you want to combine inside an array literal you have to use Column Numbers - Col1, Col2, Col3. Like in this QUERY formula... =QUERY({Sheet1!A:D;Sheet2!A:D;Sheet3!A:D},"Select * where Col1 is not null ",1) ...notice I have the 3 sheets inside curly brackets with each separated by a semi-colon. This forces the data from each sheet to be stacked on top of each other so all data is only in 4 columns, A:D so that we can reference them as Col1, Col2, Col3 and Col4. If I used a comma then the data will appear in 12 columns showing data from each sheet in a row like row 2 from each sheet in row 2 with headers in row 1. Great tutorial Leila! James/mreighties :)

[@LeilaGharani]

Thanks for sharing your tips, James!

[@TheTramos00]

After learning enough Excel and enough VBA I think that Google Sheets is the right direction. But Javascript is needed also to see the real potential. Thanks for these videos.

[@LeilaGharani]

Agree. JavaScript would be a good language to know (I'm actually learning it now 😀) Excel online also uses JavaScript so it will be easy to create automations on both sides.

[@michaelcasabar4316]

i learned more from you than my college prof. Great vid!

[@RajeshKumar-mf3jf]

you have a great illustrating power, whatever i am currently doing in my business, every credit goes to you Leila,

[@imr4nkhan]

This is so powerful and your presentation style makes it look way too easy... thanks Leila, you rock!💥

[@IsraTC]

La manera en la que llevas el paso a paso hace que sea sumamente útil, contigo práctico 2 casas a la vez. El excel y el idioma. Muchas gracias Leila, saludos desde México

[@CharcoalDaddyBBQ]

This has made my daily life so much easier!!

[@tian_obia]

Excellent tutorials, thank you!

[@matrixsecurityandautomatio427]

Leila ma'am, you are spreading your knowledge in a great way. Thanks for your efforts

[@2JSinc]

Thanks you for this, after watching this and the importrange video, I managed to use the query function to import columns from my google form's, Form Responses sheet into a new Print Layout sheet, and do a switch functions on the imported data and populate several columns, now I have a Google form for entering my 3 required fields and have 8 column/fields automatically and automatically have a formatted layout ready for printing for my report. I could also just send the link of the google form to our personnel on the field and have them submit an entry anywhere they go... Thank you Super Hero and Gorgeous Ms. Liela...

[@LeilaGharani]

That's great! I'm glad the videos are helpful.

[@2JSinc]

@@LeilaGharani been watching your videos for several years now and they have been very helpful. Thanks for making them free to watch for all of us here... Happy new year!

[@mahsekerpolat3817]

You are my rescue! Thank you So much for your amazing work!

[@markk3701]

Most helpful person on KZbin

[@LeilaGharani]

I appreciate that! Thank you.

[@Moker2012]

A query building UI would be so cool. Excel is on the right track with the data model and power query; this just looks like a step back.

[@SothearithKONGMrMuyKhmer]

Google sheet has some more special features than Excel. Thanks Leila for great video, as always! 👍😍

[@LeilaGharani]

You're welcome 😊

[@hosseinkhabiri4060]

سپاس سرکار خانم قرانی، مفید بود.

[@les.matematika.online]

Very lucky to find this video, because I have a problem related to my business which requires connecting some data in Google Sheet, thank you

[@LeilaGharani]

Glad it was helpful!

[@mohammadashiq9996]

I like Google sheets Query function trying more time making a more sense thank you Leila.

[@trongpham9999]

You will be more surprised when using the keywords "format", "pivot", "label", "limit". Try it!

[@ebinvarghese8624]

Thank u very much madam. Your video is very easy to understand difficult areas of excell and google sheets. God bless u.

[@NuriaHidalgo]

Mein Gott, so viele Sachen 😅 dankbar, dass ich dein Google sheets Kurs gekauft hatte 👍🏼

[@LeilaGharani]

😊

[@venkatiyer7459]

Thanks again for teaching something new ... your teaching skill is too good ...

[@LeilaGharani]

So nice of you!

[@amarchaurasia3821]

Always a valuable video. Happy to see that 0 dislike. Perfecto

[@iancarr3923]

Excellent introduction to Query. Thanks

[@dlovegrove11]

Wow, this is great! I have recently started diving into Google Sheets, and this video is super helpful and clear. Thanks!

[@undhaddipak]

it is most useful video and enhance my knowledge. Thank you mam

[@LeilaGharani]

It's my pleasure, Dipak.

[@rahulrustagi6119]

👍👍👍 huge fan of your knowledge

[@AnandGautam9901]

This one is awesome basic understanding

[@josericardo3015]

Very Powerful Function!

[@bradleyhowell3298]

What a fantastic video! My brain hurts but I followed most... You will be seeing more of me!

[@LeilaGharani]

Glad you like it! Welcome aboard :)

[@TylerStanczak]

Haha I love that part at 0:24 really cool gif insert. :)

[@LeilaGharani]

😁

[@anorenbergs]

Leila, you are the best. Thank you!

[@LeilaGharani]

Thank you too!

[@markfrombriz]

Brilliant explaination, so clear

[@paulminosa7740]

This Video Saves my day awesome

[@thinkthinktechs1119]

Amazing work leila,I have seen all other google sheet videos on youtube but none looks wonderful like this

[@LeilaGharani]

Wow, thank you!

[@IamHiteshRathod]

This is helpful... Thank you Leila!

[@LeilaGharani]

I'm so glad! 🙏

[@user-Bryant_Liu]

Really helpful and clear! Thanks a lot!

[@davidlondon9242]

Great video. I found out what I needed to know, quickly, in a way that was easy to understand and apply for my circumstance. Thank you.

[@2000sunsunny]

Magic function. Enjoyed :) Thank you

[@LeilaGharani]

Glad you enjoyed it!

[@rodcas]

who else read ”Quiero function”? happy new year ty for all the vids

[@ilfipetrov9208]

Thank you so much! Great video. Finally got around to tackling this issue )

[@mirekkryskapriv7445]

Great explanation! Thank you a lot!!!

[@chaddemeuse6760]

You're the best, hands down. Smashing the subscribe button

[@LeilaGharani]

Welcome aboard, Chad!

[@kinnectar820]

Very helpful, thank you.

[@wayneedmondson1065]

Hi Leila. Very interesting and powerful function. Thanks for the examples to get started. Thumbs up!!

[@LeilaGharani]

You are so welcome Wayne! Thank you.

[@BaluSubbuBalasubramanya]

Simple and under standing 🧍‍♂️ 👌

[@LeilaGharani]

That's great to hear.

[@tonester1964]

This video was awesome!

[@aryanbarnwal5180]

Great tutorial helped me understand the query function easily, which I was finding challenging at first.

[@SamirHabib]

Təşəkkür edirəm Leila!!

[@AndyGizbert]

Can you query on more than 1 criteria? great video!

[@beanjp]

I found this video very helpful ❤

[@KNLP23]

Good job! Keep it up!

[@yukari3305]

Thanks and for the sharing Teacher Leila

[@LeilaGharani]

My pleasure!

[@ambotsaimo9467]

Thank you for sharing your knowledge!!! You have a very clear and organized presentation! I salute you Mam!

[@LeilaGharani]

It's my pleasure

[@praveensharma2632]

One more wonder by Leila.👍

[@dennyxhalim]

awesome video, easy to understand, how to add UPPER on the specific Select Column, thank you

[@LeilaGharani]

Glad it was helpful!

[@TeriBryant-z5u]

When I use this formula: =query(A:G,"select G sum(E) where G='Mountlake Terrace Elementary' group by C order by sum(E) desc format sum(E) '#.###'") it returns as #VALUE!

[@ryanmurphy2412]

Hi Leila. What is the closest function in excel that does the same thing as query? I have tried a few, but nothing as straight forward as query.

[@ahmedmorsy8214]

Super useful thank you

[@familiatodres3394]

hi @leilaGharani i have a question about query, dont know if your gonna answer me lol but i give it a try, one of my google sheets has inserted image in cell. but i cant import them with the imporange function ir query. it is possible? is there any way? thanks.

[@viniciusdias5478]

Very good Leyla, congratulation!

[@AccountingandQuickbooks]

Leila you always create amazing and helpful videos. 👍👍👍

[@LeilaGharani]

Thank you! 😃

[@ehsanbb1983]

Great! Thank you Leila

[@crmwako2757]

Thanks a lot, so helpful!

[@franciscovwilliams]

What a useful video! I did not know this function in Google Sheets. It's kind of similar to Pivot Table in Excel. I like it because it makes you feel like a badass programmer! haha

[@LeilaGharani]

True 🐱‍👤

[@danjarupath]

💕💕💕💕💕 Love your vdo

[@aumarivero]

Thank you so much for this tutorial. You saved me!

[@LeilaGharani]

Great to hear!

[@sathyamoney]

Nice video... Learned something new today thanks...😊😊😊

[@LeilaGharani]

My pleasure 😊

[@rbfreitas]

Great video

[@Paulydude1]

Wow that’s powerful and easy, if you already know sql. Thanks

[@LeilaGharani]

You're welcome!

[@Veigaburame]

you are the legend

[@girishwavhal6171]

Hi Leila, Just wanted to to know how can we select a specific word from a particular cell and through the query can we also get the count of that unique word..

[@blackknight6452]

Thank you Leila. And happy new year

[@LeilaGharani]

Happy new year!

[@ranganathasadalbanjan9802]

I love this.

[@nickcavolli3072]

Would you use Query to import data from one Tab to another? Or is importantrange the best option?

[@josephcruz4736]

Just use importrange if you're not doing complex data analysis

[@nitee2482]

super cool this is 🎉

[@rehanahmad1306]

Hello Leila, your tutorials are always helpful. I want to ask if query function is helpful in creating a dynamic content calendar, where we put all detail on a sheet and it get posted on calendar automatically?

[@hassanmburia8825]

Thanks you so much

[@CaribouDataScience]

Please make a video showing his to import a file with more than a 1,000,000 rows in GS?

[@tangsh497]

powerful and complicated formula

[@lacs83]

complicated???

[@accnotech3863]

CAN YOU PLEASE MAKE VIDEOS ON GOOGLE'S APPSCRIPTS FROM BEGINNERS TO ADVANCED LEVEL

[@ConsulthinkProgrammer]

Try this apps script webApp series kzbin.info/www/bejne/sJOrXmmoZ7adhpY

[@chakralamurali]

Excellent madam

[@joy15ban]

IN GOOGLE SHEET I NEED TO PULL DATA BASED ON CRITERIA IN Column O, like =QUERY(a:f, "SELECT Col1, Col2 where Col3 = cell_o:o" )

[@EnglishSquared]

Great video. I need to select from a dataset based on color. I am quite new at this - if anyone has some hints (a good video, for example), that would be great.

[@dobirnewonutube2456]

Very nice, Please make a video for a School Management System (Data Entry Form with upload Photo & Signature, Dash Board & Printing Report Card in PDF)

[@narendra1216]

Hi Leila, how to make pivot table from different different workbook in Google sheets.

[@trongpham9999]

4:04 I have a note, @Leila We will use Column number (like Col1, Col2, Col3) when using ImportRange() function or using array with { } even though the database and the QUERY() place are the same workbook.

[@jagdishhaldankar4677]

Hi Leila. Great video. Thanks for making such informative videos. Few queries: 1) What is more efficient? (Query, Array, Pivot Tables) 2) How skip first row or any specific row?

[@syedaliuddin7046]

I will say query function

[@chelahjojo4563]

well done

[@kevincockburn6305]

Great Thanks

[@introspectionnecessary9533]

Thank u so much Ma'am👌👌...would you able to make videos on applicatio symbols used in coding😅😅