Discover more practical Google Sheets tricks like the ones in this video by joining our full "Google Sheets Masterclass" here 👉 www.xelplus.com/course/google-sheets/
Very nice video indeed. Three (3) great things I learned from here: 1) the scrolling table chart, 2) the open-ended references which allow me to account for future data, and 3) the dynamic filter functions!
Leila. I used google sheet instead of desktop excel because I used a stock macro pull and could just refresh instantly. Each time sheet was opened stock data was live. Thanks so much for your tips on all these. I use MS tricks at work even though I do IBM mainframe coding. Excel is very big as a validator and data extractor
Never seen someone explain sheet like she did well done I use excel its hard to me to change to sheets but i will try to learn it in the summer nice job
Hello Mam ... I have started using google sheets recently for monitoring stocks ... explored the functions which are available through your excel videos [using office 365] ... I am indebted to you for teaching me virtually ... thanks a lot and God Bless You
Great information ma'am. As i am going through every other video, that you have posted, so much to learn. "Thank you" is such a small word, but still thanks a lot. Huge Respect and love from INDIA.
Then you might like what I’m doing: I use IMPORTXML to data scrape sample sentences and synonyms from the web for a given word in a foreign language. It’s incredibly powerful!
Leila, re: embedding a sheet to a web page...can this be embedded into a members site behind a log in? That way it’s still private except to those with the log in? Is that correct?
the data validation - getting a calendar to display helped me fix this so I can do equivalent of the CTRL+; on Android mobile ... which is very helpful for one sheet ...
how can we create an automatic table in googlesheet like in Microsoft excel? I think we can only broader the data but can't put table. Please suggest me. :(
Loved the video but not practical for personal use. I’m not saying anything bad, you are great at explaining. I just wish I knew formulas so I could make my own spreadsheet. Thank you.
Really helpful... Now I look at google sheets as a step up from excel except keyboard shortcuts to use menu functions like Alt + H + H = Color Basically it's like while using Google spreadsheets I am again back to using mouse alot ! Which I believe affects overall time taken to complete a task :p
Tip no. 3 is very useful since we work in Google drive so we can create a link and share it to the clients so that they can access the data without login into drive👍
You are a Ninja, and I really like the way you Teach, I need to learn #1 how to make a Search Box, using an Separate Search Sheet, create a box, =QUERY(IMPORTRANGE "ITEMS URL...But I need to return a List with a few Columns Model Number, Company, Description, Quantity, Location Code, This is the IMS format I am working with. Next I need to learn how to use 3 separate Sheets one check in Sheet to use a Cellphone to automatically scan QR codes into a Check in Sheet and the Check IN sheet will Automatically update the inventory on the Masterlist Sheet, and I need to Create a Check out Sheet to Scan QR codes with the Check out Sheet and that will automatically update or SUBTRACT from the inventory on the Master Sheet. :D (I love you baby) :D
Hi, Thank you for the video. Would you please assist me here. I have a situation where I wanted to subtract the respective row value from grand total in a pivot by using calculated field. Is it possible?
Discover more practical Google Sheets tricks like the ones in this video by joining our full "Google Sheets Masterclass" here 👉 www.xelplus.com/course/google-sheets/
The "Excel Queen" has conquered the "Rival" too, and we are benefitted in the process! Best tips! 👌 Thank you! 😊👍
Very nice video indeed. Three (3) great things I learned from here: 1) the scrolling table chart, 2) the open-ended references which allow me to account for future data, and 3) the dynamic filter functions!
This gives a me a good reason to shift from excel to sheets. Impressive tips.
I used Google sheets for some time, still found tips I didn't know. Great job and thanks!
Glad it was helpful!
Thanks you very much! I am from myanmar.
@Rehan Ahmed Informative & Entertainment Jajajajajaja
Leila. I used google sheet instead of desktop excel because I used a stock macro pull and could just refresh instantly.
Each time sheet was opened stock data was live. Thanks so much for your tips on all these. I use MS tricks at work even though I do IBM mainframe coding. Excel is very big as a validator and data extractor
Never seen someone explain sheet like she did well done
I use excel its hard to me to change to sheets but i will try to learn it in the summer nice job
Solid!!! Can't wait to see you doing Google Data Studio
That would be great. I'm getting deep into Data Studio, but there just aren't the same kind of google-able supports out there yet.
Publishing the document to our web site would be very helpful and convenient. Thank you so much!
The "Publish to Web" feature is absolutely awesome- EXACTLY what I've been needing for a particular project of mine. Thanks Leila!
Glad it was helpful!
Hello Mam ... I have started using google sheets recently for monitoring stocks ... explored the functions which are available through your excel videos [using office 365] ... I am indebted to you for teaching me virtually ... thanks a lot and God Bless You
नध
Thanks! As a newbie, do you know if I can track birthday rewards using Google Sheets?
wow! The scrolling table chart blew my mind! Jaw-dropping feature! Thank you!
I learn something NEW everytime I watch your video. Thank you!!!!!!
Great information ma'am. As i am going through every other video, that you have posted, so much to learn. "Thank you" is such a small word, but still thanks a lot. Huge Respect and love from INDIA.
Leila, you do an amazing job of conveying information in a simple and easy to follow manner. You are the best!
Your videos are always awesome! They add so much value. Keep it up!
Great video. No time wasted. Just features. Thank you.
Thank you Leila - I use Sheets a lot but did not know about several of these features.
Glad you found something new, Andy.
Fantastic Leila! you helped me to switch completely to g-sheets, especially that files do NOT count against my quota size. Thanx a lot
This one is worth keeping around. Just happens that 90 percent of these I need for a project right now. Well done!
I use Google Sheets primarily to mass-(Google) translate from one language to others.
Thanks for the tips.
Then you might like what I’m doing: I use IMPORTXML to data scrape sample sentences and synonyms from the web for a given word in a foreign language. It’s incredibly powerful!
Thanks Leila,it's very informative 🎉
How do i "importhtml" from live or dynamic multiple pages?
Always informative and helpful. Thanks 🙏
Awesome video packed with useful tips! Thank you
I'm new to google sheets. You always make it easy to learn, thank you.
Thanks a lot. Very well explained and demonstrated. Great examples.
Glad you liked it.
Amazing... Good learning... And what do you make to excel?
Really good 👍👍👍
Awesome tips. Just the right level and straight to the point 😃
Tremendous, great
Love you
Very useful video
Google Sheet 👍
Thank you for great video. We have started to use in our hotel finance department . We dont send daily excel files/reports anymore :)
Leila, re: embedding a sheet to a web page...can this be embedded into a members site behind a log in? That way it’s still private except to those with the log in? Is that correct?
Brilliant! Thanks!
Yes osm features, i learnt some tricks its amazing thnks laila
Very helpful, thank you
the data validation - getting a calendar to display helped me fix this so I can do equivalent of the CTRL+; on Android mobile ... which is very helpful for one sheet ...
Very wonderful. I hardly use google sheets but you are making me take a 2nd look. It's potentials are amazing. Thanks for sharing this
Very good explanation and very useful to me. I am new to google sheet but you made easy to understand. Thank you very much
how can we create an automatic table in googlesheet like in Microsoft excel? I think we can only broader the data but can't put table. Please suggest me. :(
Wow, this video was so helpful! Thank you for sharing your knowledge and expertise on this topic
Open ended cell references and column stats tips were really good one.
Great video, very informative. I am starting to make the transition into Google sheets instead of Excel, so thank you again for the tips.
Very useful functions, thanks for this videos
🤔 I'm starting to love Google Sheets. 🤫
Thank you for showing us these hacks! It's going to be very helpful in my law firm and other organizations.
This video is a goldmine
Thank you... This was quite informative. I will watch few more videos about google sheets on your channel... #Quality_Content
Woah! I thought I was decent
This is very helpful!
Loved the video but not practical for personal use. I’m not saying anything bad, you are great at explaining. I just wish I knew formulas so I could make my own spreadsheet. Thank you.
Really helpful... Now I look at google sheets as a step up from excel except keyboard shortcuts to use menu functions like Alt + H + H = Color
Basically it's like while using Google spreadsheets I am again back to using mouse alot ! Which I believe affects overall time taken to complete a task :p
P0uuu
Thanks your video. It helps me a lot ❤️
Great video. Had no idea all the powerful yet simple functions. Tks!
Thank you! Really useful!
OMG, I didn't knew the true worth of me. Almost all the tips I knew. You are awesome. Thank you
That's great!
Hi,
Is it possible to get Google Sheet filename in cell with formula?
Thank you! Please explain how to copy text from image through google lens and paste it in google sheets in same rows and columns .
Amazing tricks, thank you for shared it!!!
Tip no. 3 is very useful since we work in Google drive so we can create a link and share it to the clients so that they can access the data without login into drive👍
Ms Gharani is just fantastic !
Very informative
😊
Awesome. Love it!
fantastic presentation
Great learning video
Thank you! Cheers!
Great info!
Thank you so much. this tutorial helped me a lot. 😊😊
Happy to hear it was helpful!😊
Thanks Leila, great tips
Most welcome, Chris.
is there anything similar on excel? would be nice have same video but frpm excel
Thank you so much for your videos. You have been an immense help!
Awesome video! Thank you!
Thanks! very useful tips...
Amazing video Leila - great tips and many features I was not aware of. Thanks!!!
Importhtml... what about tables that use
1:07 HOLY SH...!!!!!!!!! THANKS YOU FOR DISCOVERING THIS TO ME!!!
I need to use the table graph more ahem m often. It really is very useful for the user and keeps the data protected. Thanks!
Is there anyway to change the Logo (home button) once you publish a sheet?
what is the shotcut for ctrl+ [ in google sheets?
Thank you Leila Gharani! You are Brilliant!
Is there a condition precedent and condition dependant pointers in google sheet?
Excellent and informative Leila. And always beautiful to watch🙂!
so simple but AMAZING!!
Really useful, Thanks!
You are a Ninja, and I really like the way you Teach, I need to learn #1 how to make a Search Box, using an Separate Search Sheet, create a box, =QUERY(IMPORTRANGE "ITEMS URL...But I need to return a List with a few Columns Model Number, Company, Description, Quantity, Location Code, This is the IMS format I am working with. Next I need to learn how to use 3 separate Sheets one check in Sheet to use a Cellphone to automatically scan QR codes into a Check in Sheet and the Check IN sheet will Automatically update the inventory on the Masterlist Sheet, and I need to Create a Check out Sheet to Scan QR codes with the Check out Sheet and that will automatically update or SUBTRACT from the inventory on the Master Sheet. :D (I love you baby) :D
Great video thanks 🙂
Amazing video Leila😊
Thank you! 😄
Wooow this content is amazing🤩! I just came to your channel, and I'm already a loyal follower, thanks a lot! 🙌
Awesome! Thank you!
This is awesome!!!!
Awesome teacher
Hi,
Thank you for the video. Would you please assist me here. I have a situation where I wanted to subtract the respective row value from grand total in a pivot by using calculated field. Is it possible?
Excellent, thanks ma'am
Amazzzing..! your videos are really good
Thank you so much 😀
Can we use googlefinance function in excel?
Very helpful tips
Can you add the chart to a seprate sheet?
Thank you su much for this excellent tips
Pretty good. Thanks
Nice presentation
Leila this video is amazing.
Can you please make some videos on google sheet shortcuts?
Thanks for making this video