This was a GREAT tutorial! He spoke SLOWLY and clearly and explained things so well. Some videos they race through it! This one was perfect. Thank you, Benjamin!
I also liked that you include the gear used for the video in the description, what to watch next and that you specify in which minute you start talking about a certain topic. Pretty helpful and organized. I really liked it and will check your courses. Thanks once again!
I love the way you deliver the discussion in this video..You have the perfect pacing for us beginners and whats great is you have subtitles so we could catch up..Thank you very much..I hope to see more of your Tutorials..Thank you from Cebu, Philippines..
This is the ultimate google sheets tutorial for beginner. The tutorial is not too long but still very thorough and included with really well done example. Now I become interested to try and learn more about google sheets. I recommend this to those who just started using google sheets, this is a very valuable insight. Thanks for the great tutorial, good job!!!
Very good at teaching- speaks slowly and gently that not only any novice can follow the tutorial. but even someone with a v. poor concentration like me can do so from beginning to end. Top marks- I 'm in...subscribing!
😍 Wow. Falling in love with data ALL over again. Blessings to you and excited to learn more. Also, what a beautiful storyline: clear and straight to the point. Bravo. Peace and Namasté 🙏🏿 💜 ✨ 🦄 🌈 💛
You are an EXCELLENT teacher -- thank you I could actually understand what you are doing and i think I could do it myself after your fantastic clear instruction -- THANK YOU SO MUCH
Fantastic video to help you get started on google sheets! This is exactly what I needed! I started a sheet and practiced along with the directions and everything worked perfectly.
I apologize if this sounds rude, but you're voice sounds exactly like the one on computer skills in the 1st grade. It brought back bad memories of me being really bored trying to learn how to type with a cover on my keyboard XD! Thanks for the video! I learned a lot!
Thanks for the great information, Benjamin. I am new to Google Sheets and I was frustrated with attempting to add comments in a shared document. I am quite sure that now I will be able to tackle it with a bit more knowledge than about an hour ago!!
Thank You so much Benjamin very well put together and it was done on a Mac Good I just need to learn how to get Numbers into Google Sheets. Thanks again Mate.
Nice and professional...easy to follow...as a newbie the only problem i can't solve is changing my main currency to Canadian and being able to shift between Canada and US currency...my system is set to British Pounds and can't seem to change this setting to be Canadian (permanent) and subset American Dollars...Thanks Benjamin!
I'd convinced myself that learning Google Sheets was a waste of time (despite having to learn it for the L1 exam), since I have not, to any significant extent, used data (nor had I planned to use it) in my teaching. But your clear, patient explanations made learning the basics of Sheets a genuine pleasure, and now I'm wondering how I might use data to benefit those I teach.
Love this!! You just saved me so many hours of frustration!! Thank You!! Question: Is there a series of google sheet videos that pick up where you left off? I visited your webpage and subscription page and I don't think I'm ready for that deep of a dive yet. Thank YOU!!
This was very helpful. I'm new to google and sheets. I've used excel but not to range you described. Going ion interviews and I believe this will really help me navigate thru.
Great video Benjamin! May I know what tools you use to create the video eg. screen recorder. The visual clarity is waayyyyyyyyyyyyyyyyyyyyyyy better than many of the tutorials I have seen.
Thank you Edward! This is my first 4K video using a new Dell monitor, along with ScreenFlow for recording. Are you happy with the zoom-level? I’m thinking of experimenting by zooming in a little more so that text is larger, but this will probably come down to personal preference.
@@LovesData Thanks Benjamin! I think the zoom-level is great. I can read all the text while using RUclips default view! No need to squint my eyes. Agreed with what you said at the end of the day it boils down to personal preference. Keep these videos coming!
Thank you! Just a little confused ... how would one separate for example colors..... Like I want to pull up only the gold... then bronze ect. thank you
Thank you so much for this! It helped me prepare for a test I have to take for a virtual job interview. Is there a resource written somewhere I can reference for the different types of formulas used in this video? I am also confused as to what values and members are? I am autistic and have ADD/ADHD so I struggle to concentrate and just want to make sure I get this right. Thanks!
You are a great teacher! Quick question: I have a 1000 rows of short facts and each row has to reference a photo. Eg. Cell B4: Dung beetles navigate by the light of the Milky Way. Cell B6: Photo of Dung Beetle. How can I insert this reference image in Googe Sheets, and is it possible to insert a reference pic for each row? If that's not possible is there a way to link the cells to a source file containing all these pics. Note: our game developers require this for programming a game of mind-blowing facts. Thank you.
Very good information...sir I have one query, I have completed some task on 22nd may, after some time I have checked this task completed date the completed task date automatically changed accordingly the current date...so please tell me how can I fix this problem..
I sense you are well knowlegible to advise on this predictiment. My 'sheet contains 8 colmns., however, I only want to display 5, on a Chart. Is there some Formatting/Shortcut option, I could use to achieve this? Thanks!
Grazie Benjamin! Helpful and enjoyable video. A question. At the 14:40 mark, when you Validate the Emails, you referring to Google sheets to verify the emails. I tried to put a clearly fictitious email from a friend and the result was TRUE. I guess at this point Google Sheet is only able to detect the syntax of the email. For an ex. if an email is missing the @ or .com etc. Thanks again. Massimo
Hello, I hope you are doing well. I am wondering if you can conditionally freeze rows and columns (freezing for only a certain range of rows/columns), and then pass on the 'freeze property' to another row/columns that is sitting below and will stay frozen for another range. Let me know, thanks.
Dear Sir, I need your help in google sheet, how to insert blank row formula/automatically between data in google sheet. For Example : I have my working data on google sheet with 7 columns a thousand rows and in my 4th column has a city's name and I want to insert a blank row after the city's name change in my google sheet. Excel has that option to select the whole sheet and insert a blank row but I am a new user of google sheet and it's difficult for me for my work. I hope you help me for this matter
THANK YOU for talking calmly and slowly. Man, I have been through so many videos where I just cannot follow along. (I have a turtle brain. LOL)
This was a GREAT tutorial! He spoke SLOWLY and clearly and explained things so well. Some videos they race through it! This one was perfect. Thank you, Benjamin!
I also enjoyed and followed easily. Thanks!
I also liked that you include the gear used for the video in the description, what to watch next and that you specify in which minute you start talking about a certain topic. Pretty helpful and organized. I really liked it and will check your courses. Thanks once again!
That's great to hear Andrea! Thank you for letting me know and subscribing!
I love the way you deliver the discussion in this video..You have the perfect pacing for us beginners and whats great is you have subtitles so we could catch up..Thank you very much..I hope to see more of your Tutorials..Thank you from Cebu, Philippines..
i like how to teach, very precise, easy to follow instructions/steps...and your voice is soothing and calming..
True.
This is the ultimate google sheets tutorial for beginner.
The tutorial is not too long but still very thorough and included with really well done example.
Now I become interested to try and learn more about google sheets.
I recommend this to those who just started using google sheets, this is a very valuable insight.
Thanks for the great tutorial, good job!!!
This was a helpful video. Thank you. Your voice and pace are just what I need. I still have some questions, so I will look them up!
Excellent video! I was able to practice along with him speaking and it’s easy to understand him and he doesn’t go too fast.
Thanks for this. So many companies are now going to Google Sheets from Excel files. It's nice to watch an easy-to-follow tutorial.
Thank you, so smooth teaching and useful guides.
Very good at teaching- speaks slowly and gently that not only any novice can follow the tutorial. but even someone with a v. poor concentration like me can do so from beginning to end. Top marks- I 'm in...subscribing!
Thank you for creating this! That was extremely helpful in not only learning the tools, but in preparation for the Google Ed Level 1 Exam.
I enjoyed this beginner tutorial to assist me in receiving the job I want.
😍 Wow. Falling in love with data ALL over again. Blessings to you and excited to learn more. Also, what a beautiful storyline: clear and straight to the point. Bravo.
Peace and Namasté
🙏🏿 💜 ✨ 🦄 🌈 💛
This was very helpful and direct with a great pace to learn quickly.Thank you!
That’s great! Thank you for watching.
You are an EXCELLENT teacher -- thank you I could actually understand what you are doing and i think I could do it myself after your fantastic clear instruction -- THANK YOU SO MUCH
This video is pretty helpful for anyone! Thank you so much.
My pleasure Andrea!
Fantastic video to help you get started on google sheets! This is exactly what I needed! I started a sheet and practiced along with the directions and everything worked perfectly.
thanks - didn't know the drag down to lock row 1 - that's useful !
I apologize if this sounds rude, but you're voice sounds exactly like the one on computer skills in the 1st grade. It brought back bad memories of me being really bored trying to learn how to type with a cover on my keyboard XD! Thanks for the video! I learned a lot!
Thanks for the great information, Benjamin. I am new to Google Sheets and I was frustrated with attempting to add comments in a shared document. I am quite sure that now I will be able to tackle it with a bit more knowledge than about an hour ago!!
Thanks for letting me know. I’m so glad it was helpful!
b0 i5ö1, qğm
1
Thank You so much Benjamin very well put together and it was done on a Mac Good I just need to learn how to get Numbers into Google Sheets. Thanks again Mate.
Just stumbled on your site. Excellent and thank you v much for taking the time to pass on your knowledge. Hope I can use it wisely!
Appreciated the clear language and explanation.
The way you explain is very easy to understand. Thanks so much.
Very very helpful and your voice is soothing as well.
So good,and clear Im a novice so you were so perfect for me to follow.
This was an awesome video! Thank you for putting it together. I feel a lot more tech savvy today.
Nice and professional...easy to follow...as a newbie the only problem i can't solve is changing my main currency to Canadian and being able to shift between Canada and US currency...my system is set to British Pounds and can't seem to change this setting to be Canadian (permanent) and subset American Dollars...Thanks Benjamin!
I'd convinced myself that learning Google Sheets was a waste of time (despite having to learn it for the L1 exam), since I have not, to any significant extent, used data (nor had I planned to use it) in my teaching. But your clear, patient explanations made learning the basics of Sheets a genuine pleasure, and now I'm wondering how I might use data to benefit those I teach.
Thanks for watching and I'm glad you found it helpful!
Love this!! You just saved me so many hours of frustration!! Thank You!! Question: Is there a series of google sheet videos that pick up where you left off? I visited your webpage and subscription page and I don't think I'm ready for that deep of a dive yet. Thank YOU!!
Thanks for sharing mate. Im going to use it as a template for personal and business purposes
Fantastic presentation. You have the perfect voice for tutorials.
Thank you so much Florence!
This was very helpful. Well explained! Thank you .
This was very helpful. I'm new to google and sheets. I've used excel but not to range you described. Going ion interviews and I believe this will really help me navigate thru.
Really great Instructions. Really helped thank you
Excellent thank you.
Good job Benjamin. Hope more videos of Google sheets from you. Thanks alot.
Thank you so much Vinodkumar. I’ll add your suggestion to my list of requests. Thanks for watching!
Thank you. Very simplified tutorial
Great video Benjamin! May I know what tools you use to create the video eg. screen recorder. The visual clarity is waayyyyyyyyyyyyyyyyyyyyyyy better than many of the tutorials I have seen.
Thank you Edward! This is my first 4K video using a new Dell monitor, along with ScreenFlow for recording. Are you happy with the zoom-level? I’m thinking of experimenting by zooming in a little more so that text is larger, but this will probably come down to personal preference.
@@LovesData Thanks Benjamin! I think the zoom-level is great. I can read all the text while using RUclips default view! No need to squint my eyes. Agreed with what you said at the end of the day it boils down to personal preference. Keep these videos coming!
Thank you for a great tutorial!
Thank you! Just a little confused ... how would one separate for example colors..... Like I want to pull up only the gold... then bronze ect. thank you
Thank you so much for this! It helped me prepare for a test I have to take for a virtual job interview. Is there a resource written somewhere I can reference for the different types of formulas used in this video? I am also confused as to what values and members are? I am autistic and have ADD/ADHD so I struggle to concentrate and just want to make sure I get this right. Thanks!
Thank you, Benjamin! It was a great job!
Great tutorial! Very clear and easy to follow even for beginners like myself! Thank you .
You are just awesome! So calm and gave clear instructions! Thank you very much
THIS WAS BRILLIANT!
That was great LD! I was dreading Sheets and this was just what I needed. Excellent.
New Subbie from Philadelphia PA!!!
Wow you are such a soothing teacher.
I instantly subscribed!
Do you have an ASMR channel?!
lmaooo! This IS the ASMR channel. I'mma have to play these videos as I sleep for subliminal learning, teehee 😁
super helpful! Thanks!
Great to hear! Glad you liked it!
Thanks for your excellent tutorial .
Thank you, this was very helpful and I look forward to your channel!
Awesome! Thanks for watching!
Good tutorial, easy to learn and comprehensive for basic google sheets lessons. Can we request to make part 2, 3, nth?
It is precise and easy to digest👍
This is very helpful. Thank u so much
You are a great teacher! Quick question: I have a 1000 rows of short facts and each row has to reference a photo. Eg. Cell B4: Dung beetles navigate by the light of the Milky Way. Cell B6: Photo of Dung Beetle. How can I insert this reference image in Googe Sheets, and is it possible to insert a reference pic for each row? If that's not possible is there a way to link the cells to a source file containing all these pics. Note: our game developers require this for programming a game of mind-blowing facts. Thank you.
Excellent tutorial !
Just finished watching. Thank you! Very informative.
Thank you. I loved the video
Easy to follow, well described and helpful. Thank you!
I’m so glad you liked it Dexter!
Awesome Tutorial! so easy to follow and understand!
Super helpful, wonderfully presented! Thank you.
thanks Benjamin- today i have watched you first video and went on your chhenal it is so helpfull, again thanks
Thanks so much for watching. I'm so glad my videos are helpful!
Very good information...sir I have one query, I have completed some task on 22nd may, after some time I have checked this task completed date the completed task date automatically changed accordingly the current date...so please tell me how can I fix this problem..
Great information, very thankful to you for this. Have a wonderful day
This is super helpful thank you
This was super helpful. Thank you! You're awesome!
This is amazing and super helpful. Thank you!
I'm glad you liked it Suman!
Thank you Ben, very informative.
That’s great to hear Niel, thank you for watching!
Very well explained a topic that has always been intimidating to me
Well presented and easy to understand
Great teaching technique and presentation.
Thank you!!
I sense you are well knowlegible to advise on this predictiment. My 'sheet contains 8 colmns., however, I only want to display 5, on a Chart.
Is there some Formatting/Shortcut option, I could use to achieve this? Thanks!
Grazie Benjamin! Helpful and enjoyable video. A question. At the 14:40 mark, when you Validate the Emails, you referring to Google sheets to verify the emails. I tried to put a clearly fictitious email from a friend and the result was TRUE. I guess at this point Google Sheet is only able to detect the syntax of the email. For an ex. if an email is missing the @ or .com etc. Thanks again. Massimo
It’s only validating syntax. You’d need a third-party service to determine deliverability.
Grazie
Thank you, this was a great help!
That’s great! Thanks for letting me know!
Hello, I hope you are doing well. I am wondering if you can conditionally freeze rows and columns (freezing for only a certain range of rows/columns), and then pass on the 'freeze property' to another row/columns that is sitting below and will stay frozen for another range. Let me know, thanks.
Excellent explanation! Great job!
Very well explained, slowly and each section reviewed, actually for beginners. thank you
Nicely presented✅thank You so much.
Could not find: How to put SHORT-CUT, to SprdSht file, icon on Desktop. Would you please help? Thanks!
That was awesome! Thank you very much!!!
In splitting names, how do I copy and paste the formula for all of the rows?
Dear Sir,
I need your help in google sheet, how to insert blank row formula/automatically between data in google sheet.
For Example :
I have my working data on google sheet with 7 columns a thousand rows and in my 4th column has a city's name and I want to insert a blank row after the city's name change in my google sheet.
Excel has that option to select the whole sheet and insert a blank row but I am a new user of google sheet and it's difficult for me for my work.
I hope you help me for this matter
Great video! Thanks man, you have a new sub!
thanks!! this was very very helpful !!
I want the colum titles to be seen even as I make entries on line 30 etc... how do I do this?
It helps a lot.Thanks!
wow wow this was super helpful!! Thank you so much.
Really well made video - thank you!
Very informative, Excellent!!!
very helpful
Can you tell me how to label legend in charts on ipad
how do I get all the same names together. I have a ss which has same names several times
Thanks . I learned a lot.
Great Job Ben!
Thank you so much Daniel!
THANK YOU!
What is the keyboard shortcut referenced at 14:05?
It is helpful. Thank you.
That’s great to hear Florence. Thanks for watching!
Thank you
Thanks for watching!