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!
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.
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 RUclips. Your experience and knowledge is exemplary.
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..
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 🙏.
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.
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
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 :)
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.
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 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!
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?
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!
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
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)
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.
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?
Thank you for the shared knowledge! I've tried that function and found it will be very helpful for my work. But I found a problem that cost me some hours and I could't solve it. In a Select query with where function I can't filter by date. I wanted the date column to be equal to today and it gave me parse error all the times. This is my formula: =QUERY('Example Data'!$A$2:$I$7, "select A where E=today()")
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
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.
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.
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 RUclips. Your experience and knowledge is exemplary.
Glad it was helpful, Nadeem!
I was really overwhelmed by the query function, but you made it simple to understand. Thanks so much for this video!
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!
Another excellent video. I’ve been using the Query function since 2015. This is an excellent quick overview. Well done.
All your tutorials Leila are great, clear and to the point, thank you !
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 🙏.
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.
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!
i learned more from you than my college prof. Great vid!
you have a great illustrating power, whatever i am currently doing in my business, every credit goes to you Leila,
This is so powerful and your presentation style makes it look way too easy... thanks Leila, you rock!💥
This has made my daily life so much easier!!
Leila ma'am, you are spreading your knowledge in a great way. Thanks for your efforts
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!
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
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!
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!
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.
it is most useful video and enhance my knowledge. Thank you mam
It's my pleasure, Dipak.
Google sheet has some more special features than Excel. Thanks Leila for great video, as always! 👍😍
You're welcome 😊
سپاس سرکار خانم قرانی، مفید بود.
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!
You are my rescue! Thank you So much for your amazing work!
Thank u very much madam. Your video is very easy to understand difficult areas of excell and google sheets. God bless u.
Thanks again for teaching something new ... your teaching skill is too good ...
So nice of you!
Most helpful person on RUclips
I appreciate that! Thank you.
Wow, this is great! I have recently started diving into Google Sheets, and this video is super helpful and clear. Thanks!
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.
What a fantastic video! My brain hurts but I followed most... You will be seeing more of me!
Glad you like it! Welcome aboard :)
This Video Saves my day awesome
Always a valuable video. Happy to see that 0 dislike. Perfecto
Mein Gott, so viele Sachen 😅 dankbar, dass ich dein Google sheets Kurs gekauft hatte 👍🏼
😊
You're the best, hands down. Smashing the subscribe button
Welcome aboard, Chad!
Amazing work leila,I have seen all other google sheet videos on youtube but none looks wonderful like this
Wow, thank you!
Hi Leila. Very interesting and powerful function. Thanks for the examples to get started. Thumbs up!!
You are so welcome Wayne! Thank you.
👍👍👍 huge fan of your knowledge
Great tutorial helped me understand the query function easily, which I was finding challenging at first.
Excellent introduction to Query. Thanks
Thank you for sharing your knowledge!!! You have a very clear and organized presentation! I salute you Mam!
It's my pleasure
Magic function. Enjoyed :) Thank you
Glad you enjoyed it!
Really helpful and clear! Thanks a lot!
Brilliant explaination, so clear
awesome video, easy to understand, how to add UPPER on the specific Select Column, thank you
Glad it was helpful!
Leila, you are the best. Thank you!
Thank you too!
Leila you always create amazing and helpful videos. 👍👍👍
Thank you! 😃
who else read ”Quiero function”? happy new year ty for all the vids
Thanks and for the sharing Teacher Leila
My pleasure!
Very Powerful Function!
Very helpful, thank you.
This one is awesome basic understanding
Thank you so much! Great video. Finally got around to tackling this issue )
This is helpful...
Thank you Leila!
I'm so glad! 🙏
Good job! Keep it up!
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
Great explanation! Thank you a lot!!!
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!
This video was awesome!
Simple and under standing 🧍♂️ 👌
That's great to hear.
I found this video very helpful ❤
Great! Thank you Leila
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 🐱👤
💕💕💕💕💕 Love your vdo
Super useful thank you
I love this.
Haha I love that part at 0:24 really cool gif insert. :)
😁
Thank you so much for this tutorial. You saved me!
Great to hear!
CAN YOU PLEASE MAKE VIDEOS ON GOOGLE'S APPSCRIPTS FROM BEGINNERS TO ADVANCED LEVEL
Try this apps script webApp series ruclips.net/video/zbH-6r2QjP4/видео.html
Very good Leyla, congratulation!
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)
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" )
you are the legend
Nice video... Learned something new today thanks...😊😊😊
My pleasure 😊
Thank u so much Ma'am👌👌...would you able to make videos on applicatio symbols used in coding😅😅
Təşəkkür edirəm Leila!!
One more wonder by Leila.👍
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.
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?
Please make a video showing his to import a file with more than a 1,000,000 rows in GS?
Thanks a lot, so helpful!
Thank you Leila. And happy new year
Happy new year!
Thanks you so much
Wow that’s powerful and easy, if you already know sql. Thanks
You're welcome!
Excellent madam
super cool this is 🎉
Wonderful explanation, i love this
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?
Great Thanks
Great video
Amazing video!!!! Many thanks! just a question: does it have window functions like for example sum(sales) over (partition by scenario order by App)
Thank you for the shared knowledge! I've tried that function and found it will be very helpful for my work. But I found a problem that cost me some hours and I could't solve it. In a Select query with where function I can't filter by date. I wanted the date column to be equal to today and it gave me parse error all the times. This is my formula: =QUERY('Example Data'!$A$2:$I$7, "select A where E=today()")
Did you try using today() in a separate cell and then referring E=Declared cell?
@@rahuljain92 It was long ago but as far as I remember I tried it. Finally I did my job but using the function "filter()" where "today ()" works.
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
Hi Leila, this video is super useful!! Thank you. Do you know if there is any chance to do the same in Excel?
thanks for your lessons! Im looking for a solution in GOOGLE SHEET how to repeat one line N times, where N is dynamic. Can you explain it, please?
well done
Wonderful video thanks 👍
Glad you enjoyed it
powerful and complicated formula
complicated???
Thanks