Google Sheets Query Function Explained
Vložit
- čas přidán 4. 08. 2024
- Join 400,000+ professionals in our courses here 👉 link.xelplus.com/yt-d-all-cou...
Dive into the world of data analysis with Google Sheets' QUERY function. While it might seem intimidating at first, understanding its basics unlocks a world of possibilities. From simple data retrieval to complex analysis, QUERY is your go-to tool.
🎓 To master the QUERY function and other important functions check out my complete Google Sheets course: www.xelplus.com/course/google...
🔑 Key Points:
▪️ Understanding Clauses: Learn the sequence and usage of clauses like SELECT, WHERE, GROUP BY, ORDER BY, and PIVOT. Remember, the order is crucial.
▪️ Practical Examples: Start with basic queries like selecting specific columns, then advance to aggregating data with SUM, and sorting results with ORDER BY.
▪️ Advanced Usage: Explore grouping data with GROUP BY, pivoting data for a clearer view, and using ORDER BY for sorting.
▪️ Custom Formatting: Utilize the FORMAT clause to tailor the appearance of your data directly within the QUERY function.
▪️ Labeling and Limiting: Change column labels with the LABEL clause and limit the number of results with LIMIT for concise reports.
The QUERY functions is one of THE most powerful functions in Google Sheets when it comes to data analysis and data manipulation. But because it has all this flexibility it's not an easy function to master at first.
In this video I'll teach you the basics and the set of rules you need to follow if you really want to understand the Query Function in Google Sheets. You'll learn how to use SELECT, WHERE, LIMIT, GROUP BY, FORMAT and other clauses to filter data. You'll also learn how to exclude null value cells or cells that are empty when using QUERY. Also how to include cells with a specific value. We'll sort data in ascending and descending order with Query. We'll also use aggregation functions in QUERY such as the sum function.
00:00 How to Use the Google Sheets QUERY Function
00:43 Clauses in Google Sheets QUERY Function
01:57 Practical Example with Google Sheets QUERY Function
04:41 How to Aggregate Data with Google Sheets QUERY Function
08:27 How to Use Order By Clause in Google Sheets Query Function
10:19 How to Format Data with Google Sheets Query Function
11:06 How to Use the Label Clause in Google Sheets Query Function
11:32 How to Use Limit Clause in Google Sheets Query Function
Check out this video to learn how to use QUERY function together with IMPORTRANGE: • IMPORTRANGE Function i...
More Google Sheets Tutorials: • Google Sheets Tips, Tr...
★ My Online Excel Courses ► www.xelplus.com/courses/
➡️ Join this channel to get access to perks: / @leilagharani
👕☕ Get the Official XelPlus MERCH: xelplus.creator-spring.com/
🎓 Not sure which of my Excel courses fits best for you? Take the quiz: www.xelplus.com/course-quiz/
🎥 RESOURCES I recommend: www.xelplus.com/resources/
🚩Let’s connect on social:
Instagram: / lgharani
LinkedIn: / xelplus
Note: This description contains affiliate links, which means at no additional cost to you, we will receive a small commission if you make a purchase using the links. This helps support the channel and allows us to continue to make videos like this. Thank you for your support!
#googlesheets #query
Get access to the complete Google Sheets Masterclass here 👉 www.xelplus.com/course/google-sheets/
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!
Thank you! We're friends with similar interests - specially that we all love to learn.
Another excellent video. I’ve been using the Query function since 2015. This is an excellent quick overview. Well done.
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 🙏.
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
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.
All your tutorials Leila are great, clear and to the point, thank you !
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 CZcams. Your experience and knowledge is exemplary.
Glad it was helpful, Nadeem!
Wow, this is great! I have recently started diving into Google Sheets, and this video is super helpful and clear. Thanks!
you have a great illustrating power, whatever i am currently doing in my business, every credit goes to you Leila,
I was really overwhelmed by the query function, but you made it simple to understand. Thanks so much for this video!
This is so powerful and your presentation style makes it look way too easy... thanks Leila, you rock!💥
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.
You are my rescue! Thank you So much for your amazing work!
Leila ma'am, you are spreading your knowledge in a great way. Thanks for your efforts
Great tutorial helped me understand the query function easily, which I was finding challenging at first.
سپاس سرکار خانم قرانی، مفید بود.
Great explanation! Thank you a lot!!!
Thank you so much! Great video. Finally got around to tackling this issue )
Very good Leyla, congratulation!
Really helpful and clear! Thanks a lot!
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.
Wow, thank you Munim!
Nice!!! This was the very first watching video about query :)
i learned more from you than my college prof. Great vid!
Great! Thank you Leila
Very Powerful Function!
This has made my daily life so much easier!!
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..
Happy to hear that, David!
Hi Leila. Very interesting and powerful function. Thanks for the examples to get started. Thumbs up!!
You are so welcome Wayne! Thank you.
Thank u very much madam. Your video is very easy to understand difficult areas of excell and google sheets. God bless u.
Google sheet has some more special features than Excel. Thanks Leila for great video, as always! 👍😍
You're welcome 😊
Thanks a lot, so helpful!
Leila, you are the best. Thank you!
Thank you too!
Excellent introduction to Query. Thanks
I clearly am guilty of underestimating google sheets. Wow powerful function. Thanks for sharing Leila!!
Glad it was helpful! There are quite a few hidden gems in sheets.
This is helpful...
Thank you Leila!
I'm so glad! 🙏
Brilliant explaination, so clear
I like Google sheets Query function trying more time making a more sense thank you Leila.
You will be more surprised when using the keywords "format", "pivot", "label", "limit".
Try it!
Thank you so much for this tutorial. You saved me!
Great to hear!
Leila you always create amazing and helpful videos. 👍👍👍
Thank you! 😃
👍👍👍 huge fan of your knowledge
This video was awesome!
Thank you for sharing your knowledge!!! You have a very clear and organized presentation! I salute you Mam!
It's my pleasure
Təşəkkür edirəm Leila!!
Always a valuable video. Happy to see that 0 dislike. Perfecto
Amazing video!!!! Many thanks! just a question: does it have window functions like for example sum(sales) over (partition by scenario order by App)
Great video, Leila. Thank you.
Is it a viable option to create a table area within a Google Sheet to set up various "what if" options in terms of input of various query variables for a certain set of data?
Changes to inputs could then be quickly made by changing the variables in the table area.
And, from a practical perspective, how far could you go with this methodology in terms of not just input variables for the various query clauses, but mathematical and boolean operators used in the query function as well, if at all possible?
Good job! Keep it up!
You're the best, hands down. Smashing the subscribe button
Welcome aboard, Chad!
Thanks again for teaching something new ... your teaching skill is too good ...
So nice of you!
This Video Saves my day awesome
Amazing work leila,I have seen all other google sheet videos on youtube but none looks wonderful like this
Wow, thank you!
Super useful thank you
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?
I will say query function
Magic function. Enjoyed :) Thank you
Glad you enjoyed it!
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.
Hi Ms Leila, really informative video, thank you!
I have a question, if you please, in this query function, how do you select the column BY?
This one is awesome basic understanding
Thank you Leila. And happy new year
Happy new year!
Mein Gott, so viele Sachen 😅 dankbar, dass ich dein Google sheets Kurs gekauft hatte 👍🏼
😊
I love this.
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.
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.
I found this video very helpful ❤
Great Thanks
Thanks you so much
it is most useful video and enhance my knowledge. Thank you mam
It's my pleasure, Dipak.
Hi Leila, this video is super useful!! Thank you. Do you know if there is any chance to do the same in Excel?
super cool this is 🎉
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?
What a fantastic video! My brain hurts but I followed most... You will be seeing more of me!
Glad you like it! Welcome aboard :)
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...
That's great! I'm glad the videos are helpful.
@@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!
Great video
💕💕💕💕💕 Love your vdo
Most helpful person on CZcams
I appreciate that! Thank you.
Simple and under standing 🧍♂️ 👌
That's great to hear.
you are the legend
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
True 🐱👤
Amazing tricks
One more wonder by Leila.👍
Haha I love that part at 0:24 really cool gif insert. :)
😁
Nice!
Hi Leila, love your content.
Can you do a video about social network graph in excel?
Thanks and for the sharing Teacher Leila
My pleasure!
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
Glad it was helpful!
Wonderful video thanks 👍
Glad you enjoyed it
who else read ”Quiero function”? happy new year ty for all the vids
Nice video... Learned something new today thanks...😊😊😊
My pleasure 😊
well done
thanks..
Thanks
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 :)
Thanks for sharing your tips, James!
Thanks!
Thank you!
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.
Wow that’s powerful and easy, if you already know sql. Thanks
You're welcome!
Excellent madam
Thank You Leila ...for your help and Congratulations for your new achivement .... many more to come....Had a quick question on Query ....I have data in which one column has number format as " AB12234" when I use query function it's gives put as " " can you please provide resolution for this .... thank you
Tks for the video Leila!
As usual very explained!
Is there in Google sheets something as Power Query in order to clean unstructured data?
BigQuery seems to be the Power Query alternative. I haven't had a close look yet though....
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..
Great Video, how do I sort a column month-wise in ascending order?
powerful and complicated formula
complicated???