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!

@LeilaGharani

3 жыл бұрын

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.

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 was really overwhelmed by the query function, but you made it simple to understand. Thanks so much for this video!

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'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.

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

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

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

Really helpful and clear! Thanks a lot!

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

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

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

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 KZread. Your experience and knowledge is exemplary.

@LeilaGharani

3 жыл бұрын

Glad it was helpful, Nadeem!

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.

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

This has made my daily life so much easier!!

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

Great explanation! Thank you a lot!!!

Very Powerful Function!

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

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?

Excellent introduction to Query. Thanks

Great! Thank you Leila

Very good Leyla, congratulation!

Brilliant explaination, so clear

Nice!!! This was the very first watching video about query :)

Thanks a lot, so helpful!

This video was awesome!

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

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

@LeilaGharani

3 жыл бұрын

Great to hear!

This is helpful... Thank you Leila!

@LeilaGharani

3 жыл бұрын

I'm so glad! 🙏

Leila, you are the best. Thank you!

@LeilaGharani

3 жыл бұрын

Thank you too!

I found this video very helpful ❤

Super useful thank you

This Video Saves my day awesome

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

This one is awesome basic understanding

👍👍👍 huge fan of your knowledge

Amazing video!!!! Many thanks! just a question: does it have window functions like for example sum(sales) over (partition by scenario order by App)

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

@LeilaGharani

3 жыл бұрын

You're welcome 😊

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

@trongpham9999

3 жыл бұрын

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

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

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

@LeilaGharani

3 жыл бұрын

You are so welcome Wayne! Thank you.

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

@LeilaGharani

3 жыл бұрын

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

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?

Thanks you so much

Magic function. Enjoyed :) Thank you

@LeilaGharani

Жыл бұрын

Glad you enjoyed it!

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

@LeilaGharani

3 жыл бұрын

Thank you! 😃

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

2 жыл бұрын

Happy to hear that, David!

Hi Leila, this video is super useful!! Thank you. Do you know if there is any chance to do the same in Excel?

I love this.

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

3 жыл бұрын

Wow, thank you Munim!

Good job! Keep it up!

Great Thanks

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

@LeilaGharani

3 жыл бұрын

So nice of you!

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

@LeilaGharani

3 жыл бұрын

It's my pleasure

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

super cool this is 🎉

Simple and under standing 🧍‍♂️ 👌

@LeilaGharani

2 жыл бұрын

That's great to hear.

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..

Thank you Leila. And happy new year

@LeilaGharani

3 жыл бұрын

Happy new year!

Amazing tricks

Great video

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?

One more wonder by Leila.👍

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

@LeilaGharani

2 жыл бұрын

Welcome aboard, Chad!

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

@LeilaGharani

3 жыл бұрын

😁

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

@LeilaGharani

3 жыл бұрын

Wow, thank you!

you are the legend

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

@LeilaGharani

3 жыл бұрын

😊

Great Video, how do I sort a column month-wise in ascending order?

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

@LeilaGharani

3 жыл бұрын

It's my pleasure, Dipak.

Can you use this function with data from a different google sheet? IF so, how do you select the range you want to import?

Thanks and for the sharing Teacher Leila

@LeilaGharani

Жыл бұрын

My pleasure!

Most helpful person on KZread

@LeilaGharani

3 жыл бұрын

I appreciate that! Thank you.

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.

💕💕💕💕💕 Love your vdo

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

@LeilaGharani

3 жыл бұрын

Glad you like it! Welcome aboard :)

thanks..

Wonderful video thanks 👍

@LeilaGharani

3 жыл бұрын

Glad you enjoyed it

well done

Thanks

Nice!

Hi Leila, love your content. Can you do a video about social network graph in excel?

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

3 жыл бұрын

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!

@LeilaGharani

2 жыл бұрын

Thank you!

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

9 ай бұрын

Glad it was helpful!

Excellent madam

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

@LeilaGharani

3 жыл бұрын

My pleasure 😊

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.

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

@LeilaGharani

20 күн бұрын

Glad it was helpful!

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

@LeilaGharani

3 жыл бұрын

You're welcome!

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

2 жыл бұрын

I will say query function

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

3 жыл бұрын

True 🐱‍👤

Hi Leila, i’m wondering if it is possible to use query sum based on horizontal month. I have a detailed sheet of total purchase from all suppliers for the year. Col A is the list of supplier B3:M3 is Jan to dec I would like to build a monthly report for sales and purchase in a separate sheet using query+importrange, also with months horizontally. In other word i need to sum(Col) matching the month name. Is it possible?

Can you use QUERY to match a cell with dropdown options?

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

3 жыл бұрын

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

@2JSinc

3 жыл бұрын

@@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!