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
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.
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!
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 ...
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?
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
Hello! Great tutorial. Question- I have a sheet that column B drop down menu indicates resolved as an option. How do I get the “resolved” rows to populate on a new sheet named “Resolved”? (Sheet for ongoing, duplicate request, development issue etc) I’d also like to include a timeline. A form is submitted with a date, I’d like the response (resolved, ongoing, under investigation) to be timestamped with a date count for each drop down option Example - google form submitted Jan 1,2021. Question/comments are reviewed by admin team ( this is where another date can be entered) When the submission is either resolved, cancelled etc I’d like a date count to reflect the date submitted, the date is was reviewed and the date is was closed to count the actual business days from entry to completion (or cancelled etc) to be reflected in a column This to provide the form lifetime. From beginning to end *there are complaints that form submissions are taking too long to get a response
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👍
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. :(
Leila Gharani, hi! Thank you for your useful videos! Could you please let me know whether there is a tool [simillar to Arixcel to Excel] in Google sheets that will help me to analyse all the cells in the specified scope and group them into Inputs (having only dependents and no precedents)? Thank you in advance!
That if thou shalt confess with thy mouth the Lord Jesus, and shalt believe in thine heart that God hath raised him from the dead, thou shalt be saved. 10 For with the aheart man bbelieveth unto righteousness; and with the mouth confession is made unto csalvation.
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?
I am a finance guy & I use both Excels in my daily work. In Microsoft Excel sheet, we can paste the copied data by pressing Enter. But in Google Sheets, we have to use Control + V. Is there any option in Google Sheets to paste the date by pressing only Enter button ?
I m not a specilist but when I see the formula s , I have the feeling that google sheet is easier to learn than exce"l? AM I correct? Can you make a video with the advantage to use google sheet please?
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! 😊👍
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!
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!
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
This gives a me a good reason to shift from excel to sheets. Impressive tips.
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
Leila, you do an amazing job of conveying information in a simple and easy to follow manner. You are the best!
Fantastic Leila! you helped me to switch completely to g-sheets, especially that files do NOT count against my quota size. Thanx a lot
Publishing the document to our web site would be very helpful and convenient. Thank you so much!
Thanks! As a newbie, do you know if I can track birthday rewards using Google Sheets?
Great video. No time wasted. Just features. Thank you.
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
I learn something NEW everytime I watch your video. Thank you!!!!!!
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.
Awesome tips. Just the right level and straight to the point 😃
This one is worth keeping around. Just happens that 90 percent of these I need for a project right now. Well done!
Thank you Leila - I use Sheets a lot but did not know about several of these features.
Glad you found something new, Andy.
Great video, very informative. I am starting to make the transition into Google sheets instead of Excel, so thank you again for the tips.
I'm new to google sheets. You always make it easy to learn, thank you.
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
नध
wow! The scrolling table chart blew my mind! Jaw-dropping feature! Thank you!
Your videos are always awesome! They add so much value. Keep it up!
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
Wow, this video was so helpful! Thank you for sharing your knowledge and expertise on this topic
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.
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!
Open ended cell references and column stats tips were really good one.
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 a lot. Very well explained and demonstrated. Great examples.
Glad you liked it.
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 ...
Thank you for showing us these hacks! It's going to be very helpful in my law firm and other organizations.
Great video. Had no idea all the powerful yet simple functions. Tks!
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?
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
Brilliant! Thanks!
Thank you! Please explain how to copy text from image through google lens and paste it in google sheets in same rows and columns .
🤔 I'm starting to love Google Sheets. 🤫
Hi,
Is it possible to get Google Sheet filename in cell with formula?
Hello! Great tutorial. Question- I have a sheet that column B drop down menu indicates resolved as an option. How do I get the “resolved” rows to populate on a new sheet named “Resolved”? (Sheet for ongoing, duplicate request, development issue etc)
I’d also like to include a timeline.
A form is submitted with a date, I’d like the response (resolved, ongoing, under investigation) to be timestamped with a date count for each drop down option
Example - google form submitted Jan 1,2021.
Question/comments are reviewed by admin team ( this is where another date can be entered)
When the submission is either resolved, cancelled etc I’d like a date count to reflect the date submitted, the date is was reviewed and the date is was closed to count the actual business days from entry to completion (or cancelled etc) to be reflected in a column
This to provide the form lifetime. From beginning to end
*there are complaints that form submissions are taking too long to get a response
Amazing tricks, thank you for shared it!!!
This video is a goldmine
Thank you for great video. We have started to use in our hotel finance department . We dont send daily excel files/reports anymore :)
Amazing video Leila - great tips and many features I was not aware of. Thanks!!!
Thanks so much.pretty straightforward. Love 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👍
Thank you so much for your videos. You have been an immense help!
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. :(
Awesome video packed with useful tips! Thank you
I have created a Finance module from Google sheet. Its great to learn new things.
Today i learnt A Date feature. 👍👍
Always informative and helpful. Thanks 🙏
Thank you! Really useful!
so simple but AMAZING!!
Amazing... Good learning... And what do you make to excel?
Thanks Leila, great tips
Most welcome, Chris.
Thank you Leila Gharani! You are Brilliant!
OMG, I didn't knew the true worth of me. Almost all the tips I knew. You are awesome. Thank you
That's great!
Very useful functions, thanks for this videos
Leila this video is amazing.
Can you please make some videos on google sheet shortcuts?
Thanks Leila,it's very informative 🎉
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!
You are a genius. So many useful tips with perfect explanations. Thank you!
Thanks for watching, Kurt!
That first tip was exciting. Thanks Leila
Tremendous, great
Love you
Very useful video
Google Sheet 👍
Excellent and informative Leila. And always beautiful to watch🙂!
1:07 HOLY SH...!!!!!!!!! THANKS YOU FOR DISCOVERING THIS TO ME!!!
Thanks your video. It helps me a lot ❤️
Thanks a lot for the video !! Looks easier when you explains it . I love it
Glad to hear that, Jorge!
Leila Gharani, hi! Thank you for your useful videos! Could you please let me know whether there is a tool [simillar to Arixcel to Excel] in Google sheets that will help me to analyse all the cells in the specified scope and group them into Inputs (having only dependents and no precedents)? Thank you in advance!
Thank you so much. this tutorial helped me a lot. 😊😊
Happy to hear it was helpful!😊
Yes osm features, i learnt some tricks its amazing thnks laila
I would have added the QUERY function too. I use it all the time, even over Filter quite often. So much moree versatile, and powerful.
I
That if thou shalt confess with thy mouth the Lord Jesus, and shalt believe in thine heart that God hath raised him from the dead, thou shalt be saved. 10 For with the aheart man bbelieveth unto righteousness; and with the mouth confession is made unto csalvation.
Thanks! very useful tips...
Ms Gharani is just fantastic !
Awesome. Love it!
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
This is amazing! Thanks so much for sharing!
Great learning video
Thank you! Cheers!
Really good 👍👍👍
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?
HELLO Leila, great video as always. Can you do a video on how to pull stock data from differents websites, thanks
Great tutorial, thank you !
This is incredible, Leila! Thank you so much!
You're so welcome!
Wooow this content is amazing🤩! I just came to your channel, and I'm already a loyal follower, thanks a lot! 🙌
Awesome! Thank you!
Always thought Google sheets inferior to Excel, but now I can give it a try 👍
ङणत्अं
Great job! I am going through it again.
Great info!
Excellent tutorial !
Importhtml... what about tables that use
Thanks Leila for sharing, keep it up!
This is awesome!!!!
I am a finance guy & I use both Excels in my daily work. In Microsoft Excel sheet, we can paste the copied data by pressing Enter. But in Google Sheets, we have to use Control + V. Is there any option in Google Sheets to paste the date by pressing only Enter button ?
Super helpful a specific, well done and thank you :)
You're very welcome!
Thank you su much for this excellent tips
All time favourite: data validation
I m not a specilist but when I see the formula s , I have the feeling that google sheet is easier to learn than exce"l? AM I correct? Can you make a video with the advantage to use google sheet please?
Pretty good. Thanks