Continue learning Google Sheets with FREE Official Training offered by Google: ✅ Google Sheets Getting Started course: bit.ly/3UwekAu ✅ Google Sheets Advanced Topics course: bit.ly/3tpxDj2 ✅ Google Sheets Functions, Formulas, and Charts course: bit.ly/3UNI9vV
Hi Kevin Please don't Make Content on Google Products I why I am saying this? Because your I use Microsoft Products whatever is in Microsoft 365. And making Switch to any other products is Very Costly(costly in time Becoming expert And learning Curve). And I expect you make videos on Microsoft Products Only Because Biggest reason you have 14 years of experience in Microsoft. And if you're Making Videos on Google products I would Like to learn About Google on How to use Google search effectively, how to use UA-cam Music effectively, How to use Google maps effectively
I’m a pretty slow learner when it comes to stuff like this. However, you have help me immensely to feel more motivated to continue learning. You are a great teacher and your speed is perfect. Straight forward and no silly stuff. Keep up the good job.
This is one of the BEST tutorials on Google Sheets out there. I watched four others before settling on this one. I found myself overwhelmed and confused watching the others. Five minutes into this one, I was immediately engaged. And Kevin explains every single step and answers every single question I've had -- in such a clear and concise manner. Can't thank you enough.
Yes He does and he takes his time and talks slow and thoroughly and you able to keep up and follow his tutorial. Keep up the great work. I used to get so stressed because I did not know where and how to start, but this video has been a lifesaver. I created a spreadsheet in under 5 minutes. Thanks Kevin!!!!!
So many hidden gems in there! I use sheets a lot and thought I had a handle on it, but learned so much more from your clear and easy to follow presentation. Thank you!
its been Years since I learned Excel in college, and I havent used it since. This was not only a good refresher, but also a very good tutorial for first time users. You are a lifesaver for me progressing in my new role as a branch manager at my company. If you can teach this 48 yr. old, anyone will understand it.Thank you so much Kevin.
All of this was amazing. Such a comprehensive, straightforward tutorial. I'm excited to try vlookup, pivot tables, various filters / functions, and more! Thanks so much!
@@KevinStratvert hello I am trying yo get to accountant career and they told me to start learning spread sheets alone is that effective without any power excel or power point previous background ??
I have been using MS spread sheets and I have never realized there is also Google sheets (I believe I have seen it but never really look into it). It seems to me the Google sheets is much simpler and more user friendly. It does the same thing as the MS spread sheets and it is free! I'm thinking might be I can drop the MS 360 now since I mainly use its spread sheets. Thank you so much for sharing!
Üniversitede Excel'i öğrendiğimden bu yana yıllar geçti ve o zamandan beri kullanmadım. Bu sadece iyi bir bilgi tazelemesi değil, aynı zamanda ilk kez kullananlar için çok iyi bir eğitimdi. Şirketimde şube müdürü olarak yeni görevimde ilerlerken benim için bir cankurtaransın. Eğer bunu 48 yıl öğretebilirsen. yaşlı, bunu herkes anlayacaktır. Çok teşekkür ederim Kevin.
I thought I'd picked up most of the basics just by fiddling around and doing some class work sheets here and there. I have never been happier to be wrong! This will save me so much time formatting and calculating. Thank you!
I am recommeding your videos to my students in college, MBA and Ph.D. levels. As I teach to students in the creative industries, a video on using google sheets for finance planning and control for people in the creative industries may open your horizons further. Thanks for this resource. Well done!
You're such a great teacher. Kevin! This tutorial was both detailed yet easy to understand. I am self-training to be a VA and these are some of the tools I'll be needed to learn and apply in my next career. Thank you.
Thanks Kelvin, I started a new job position as a Finance Officer but I tried to find the best Accounting Software to records our transaction, here everything is clear now. I will continue to learn more advance via your Class in this channel
I'm on my second walkthrough of this, and I was afraid I didn't retain all the info but then I started entering the info that's needed before you did, so let's say i've retained a decent amount of the info, thanks again Kevin!
Kevin, you are my FAVORITE UA-cam training guy! When I need to learn, I look for your videos first. Just when I was really getting into Excel and loving it, I find I need to learn the GSuite for a possible new job. Looking forward to viewing your training videos. You always keep it interesting!
Thanks Kevin . I know the basics of google sheets but I discovered a lot of hidden gems while watching your videos. You are great teacher. Greetings from Manila, Philippines
Wow, this was an absolute masterpiece of a tutorial! 🙌 You managed to cover every aspect of Google Sheets in such a simple and easy-to-understand way without making it overwhelming. The chapter divisions were a brilliant touch-they made navigating the video so smooth! Your teaching style is clear, concise, and incredibly helpful. Thank you for taking the time to create such high-quality content-you're truly a gem in the world of tutorials!💙💎
I am about to join a project using G tools and learning this. You’re very helpful thank you. I assume Excel is pretty much similar to this, especially functions
I LOVE YOUR EXPLANATIONS!! It's so easy to understand. I used to be intimidated by the thought of using Google Sheets but this actually made me very interested in using it! Thank you!
Thank you for this fabulous beginner presentation on how to use Google Sheets! It's incredible! I love how easily you move around Sheets and voice the directives. I'll be watching a few more times to fully grasp all you've explained, and I'll need to open up a Google sheet to practice, too. Most definitely, I'll be registering for the free Google trainings you've listed below. Bless you!
Thankyou so much! you helped me a lot, i just started exploring googlesheets and this is one of the video that I really recommend, definitely worth the watch.
For beginners? Wow can't wait to be a power user!!! Well made and explained tutorial and sheets seems much easier than Excel. I'm struggling with formulas but I'll get there.
I enjoyed this video. The conversation tone was positive and moved along well. As an additional thought, I am going to check to see if you have anything on how to make an advanced recipe planner and grocery list for the week. I'd really like to see more on how to interlink multiple sheets to specific cells.
Wow. This was a very interesting and exciting Tutorial. It has definitely put the “can’t” out of the picture. Everything was very well explained and at a pace that is highly recommended and appreciated. Thank you very very much. Kudos!!!👍🏃🏿♀️🗽
This is so crazy I mean whenever I search about something your channel blow up like you do every single thing that I'm searching for and I need to subscribe good luck..
Continue learning Google Sheets with FREE Official Training offered by Google:
✅ Google Sheets Getting Started course: bit.ly/3UwekAu
✅ Google Sheets Advanced Topics course: bit.ly/3tpxDj2
✅ Google Sheets Functions, Formulas, and Charts course: bit.ly/3UNI9vV
Hi Kevin Please don't Make Content on Google Products I why I am saying this? Because your I use Microsoft Products whatever is in Microsoft 365. And making Switch to any other products is Very Costly(costly in time Becoming expert And learning Curve). And I expect you make videos on Microsoft Products Only Because Biggest reason you have 14 years of experience in Microsoft.
And if you're Making Videos on Google products I would Like to learn About Google on How to use Google search effectively, how to use UA-cam Music effectively, How to use Google maps effectively
@@rushabh542336:50
omg hes jus tryna help ppl @@rushabh5423
Me 😢I'm very scared 😱
thanks Kevin
I’m a pretty slow learner when it comes to stuff like this. However, you have help me immensely to feel more motivated to continue learning. You are a great teacher and your speed is perfect. Straight forward and no silly stuff. Keep up the good job.
Kind of calm, comforting and understand what we want to understand
This is one of the BEST tutorials on Google Sheets out there. I watched four others before settling on this one. I found myself overwhelmed and confused watching the others. Five minutes into this one, I was immediately engaged. And Kevin explains every single step and answers every single question I've had -- in such a clear and concise manner. Can't thank you enough.
Yes He does and he takes his time and talks slow and thoroughly and you able to keep up and follow his tutorial. Keep up the great work. I used to get so stressed because I did not know where and how to start, but this video has been a lifesaver. I created a spreadsheet in under 5 minutes. Thanks Kevin!!!!!
So many hidden gems in there! I use sheets a lot and thought I had a handle on it, but learned so much more from your clear and easy to follow presentation. Thank you!
I do not think anyone could teach this any clearer. THANK YOU!
Agree! This is the best tutorial on Google Sheets I've found.
Who else here cause you lied to your job about being able use Excel and now they want you to use it 😂
😂😂
😂😂😂
😂😂
relatable…
Not me, just here because I am curious.
its been Years since I learned Excel in college, and I havent used it since. This was not only a good refresher, but also a very good tutorial for first time users. You are a lifesaver for me progressing in my new role as a branch manager at my company. If you can teach this 48 yr. old, anyone will understand it.Thank you so much Kevin.
All of this was amazing. Such a comprehensive, straightforward tutorial. I'm excited to try vlookup, pivot tables, various filters / functions, and more! Thanks so much!
Of course! Glad it helped!
@@KevinStratvert hello I am trying yo get to accountant career and they told me to start learning spread sheets alone is that effective without any power excel or power point previous background ??
Well said. I couldn't agree more. Amazingly helpful tutorial.
I have been using MS spread sheets and I have never realized there is also Google sheets (I believe I have seen it but never really look into it). It seems to me the Google sheets is much simpler and more user friendly. It does the same thing as the MS spread sheets and it is free! I'm thinking might be I can drop the MS 360 now since I mainly use its spread sheets. Thank you so much for sharing!
Üniversitede Excel'i öğrendiğimden bu yana yıllar geçti ve o zamandan beri kullanmadım. Bu sadece iyi bir bilgi tazelemesi değil, aynı zamanda ilk kez kullananlar için çok iyi bir eğitimdi. Şirketimde şube müdürü olarak yeni görevimde ilerlerken benim için bir cankurtaransın. Eğer bunu 48 yıl öğretebilirsen. yaşlı, bunu herkes anlayacaktır. Çok teşekkür ederim Kevin.
I thought I'd picked up most of the basics just by fiddling around and doing some class work sheets here and there. I have never been happier to be wrong! This will save me so much time formatting and calculating. Thank you!
same here! thought I knew quite some skills but still learned so many
I am recommeding your videos to my students in college, MBA and Ph.D. levels. As I teach to students in the creative industries, a video on using google sheets for finance planning and control for people in the creative industries may open your horizons further. Thanks for this resource. Well done!
Well laid out and simple intructions. thanks. i love the chapters, makes it so easy to come back and double check any questions i have.
Wow, this must've been a ton of work. Good to know this is out there.
You're such a great teacher. Kevin! This tutorial was both detailed yet easy to understand. I am self-training to be a VA and these are some of the tools I'll be needed to learn and apply in my next career. Thank you.
Thanks Kelvin, I started a new job position as a Finance Officer but I tried to find the best Accounting Software to records our transaction, here everything is clear now. I will continue to learn more advance via your Class in this channel
Love how your tone is so comforting and makes it easier to understand.
I'm on my second walkthrough of this, and I was afraid I didn't retain all the info but then I started entering the info that's needed before you did, so let's say i've retained a decent amount of the info, thanks again Kevin!
Kevin, you are my FAVORITE UA-cam training guy! When I need to learn, I look for your videos first. Just when I was really getting into Excel and loving it, I find I need to learn the GSuite for a possible new job. Looking forward to viewing your training videos. You always keep it interesting!
Thank you Kevin! You are one of the best instructors in youtube
Thanks Kevin . I know the basics of google sheets but I discovered a lot of hidden gems while watching your videos. You are great teacher. Greetings from Manila, Philippines
Thanks so much Kevin for your videos. They're really helpful. I passed my Computer User Skills Tests..
Hello I’m preparing too for my tests! I will continue following Kevin. Thank you!
Much simpler to use than MS Excel sheets , amazing
Thanks Kevin! I've got my first big boy job coming up and this video is a lifesaver.
Wow, this was an absolute masterpiece of a tutorial! 🙌 You managed to cover every aspect of Google Sheets in such a simple and easy-to-understand way without making it overwhelming. The chapter divisions were a brilliant touch-they made navigating the video so smooth! Your teaching style is clear, concise, and incredibly helpful. Thank you for taking the time to create such high-quality content-you're truly a gem in the world of tutorials!💙💎
Kevin is such a great teacher. Thank you.
I learn so much from all your tutorials. Thank you.
Good stuff. I've been using G-Sheets for years both personally and professionally but still picked up a few little tricks from this tutorial.
You... Are unbeatable Kevin. Keep that great work up.
Yay, thank you just for fun learned the google sheets basics! Keep it up man, we love you!
Wow! Thanks Kevin. This was quite a comprehensive beginner tutorial.
Bravo! Thank you so much for the video. You are a wonderful teacher!
This is soo useful...very detailed and well explained. Thank you!
One of the best tutorials out there!
Highly underrated. Wonderful breakthrough and explaintation.
man!!! you really good at explaining things ... keep up the good work and thank you
Thank you so much Kevin! All the best.
This was such a fun hands-on video/project, i'm gonna add this work to my portfolio as i'm in the process of learning data analytics :)
Thanks Kevin!
I am about to join a project using G tools and learning this. You’re very helpful thank you.
I assume Excel is pretty much similar to this, especially functions
Thank you for being a great teacher and simplifying this for us!
This is awesome! I appreciate the fact that you don't presume knowledge of Excel.
Excellent work as usual, Kevin! I learned a lot!
Im from Germany and not that good in english. I full understand the video. Very clear and with good explanations. Liked it
Google's tutorials gave me a headache. Thank you for all you do!
And Kevin you are incredibly professional in your teaching , thank you so much
Wow, thank you!
I LOVE YOUR EXPLANATIONS!! It's so easy to understand.
I used to be intimidated by the thought of using Google Sheets but this actually made me very interested in using it! Thank you!
Wow!! Wish he had been my teacher in school. (But hitting the pause while I tried it myself was helpful) Awesome and super clear. Thank you so much.
Video Chapters for quick review:
00:00 - Introduction
00:46 - Official Google Sheets training
01:43 - What is Google Sheets
02:24 - How to get Google Sheets
03:30 - Start page
04:30 - Top bar
06:26 - Cells, columns, & rows
07:30 - Zoom level
07:46 - Enter data & smart fill
10:04 - Format numbers
11:01 - Adjust column widths & row heights
12:24 - Move columns & rows
12:57 - Alternating colors
13:42 - Conditional formatting
15:07 - Hide columns & rows
15:57 - Insert columns & rows
16:57 - Freeze columns & rows
17:42 - Column stats
19:01 - Explore
19:54 - Addition
21:52 - Subtraction
22:13 - Multiplication
22:35 - Division
22:54 - Functions
23:40 - SUM function
25:53 - Relative & absolute references
28:20 - Named ranges
29:32 - VLOOKUP function
31:57 - Multiple worksheets
33:57 - Sort & filter
35:30 - Filter views
36:39 - Charts
39:09 - Pivot tables
42:49 - Create a new form
44:23 - Share & collaborate with others
47:24 - Version history
48:02 - Publish, email, & print
48:31 - Wrap up
I’ve been looking all over for this! Thanks my brother 🙏
Thanks Kevin, you are such a good teacher(tutor), from Kenya.
Bonjour Kevin,
Thank you for your video.
Toujours au Topppp
Thank you for this fabulous beginner presentation on how to use Google Sheets! It's incredible! I love how easily you move around Sheets and voice the directives. I'll be watching a few more times to fully grasp all you've explained, and I'll need to open up a Google sheet to practice, too. Most definitely, I'll be registering for the free Google trainings you've listed below. Bless you!
Great video, We at chartmat love google sheets and you can build apps and dashboards from it.
😉
Kevin, you are the best! :) I adore your videos.
This was exactly what i was looking for! Thank you for this great tutorial!
Thankyou so much! you helped me a lot, i just started exploring googlesheets and this is one of the video that I really recommend, definitely worth the watch.
This is so great and detailed! Thank you so much @Kevin Stratvert! You make learning smooth and very well understood! You are amazing!🙌❤🤗
this was a wonderful learning experience Kevin. thank you so much
going into details one by one, great Kevin👏👏
For beginners?
Wow can't wait to be a power user!!!
Well made and explained tutorial and sheets seems much easier than Excel.
I'm struggling with formulas but I'll get there.
You just made my life SO much more easier!!! Thank you so much!
This is so good you deserve every view! Your teaching method is very easy to understand and your voice is very friendly
I am a visual learner. I am also auditory. I am just letting this tutorial wash over me in my 'abalone in a tide pool' method of learning. Thank you.
This has been really helpful
You are such an amazing trainer
Thank you!
I absolutely love your videos, very informative, clear, and easy to understand. thank God for you, continue doing a great job.
I enjoyed this video. The conversation tone was positive and moved along well. As an additional thought, I am going to check to see if you have anything on how to make an advanced recipe planner and grocery list for the week. I'd really like to see more on how to interlink multiple sheets to specific cells.
Thank you so much for the very informative Video. I am so motivated to start using Google Sheets
Thank you, Kevin I started using Sheets a while back now ❤️❤️❤️❤️❤️❤️👍👍👍👍👍⭐⭐⭐⭐⭐
Learned alot from this video. Thank you so much
This is topnotch presentation, Kev. Thank you buddy.
Simple and easy to follow😊 thanks!
Wow. This was a very interesting and exciting Tutorial. It has definitely put the “can’t” out of the picture. Everything was very well explained and at a pace that is highly recommended and appreciated. Thank you very very much. Kudos!!!👍🏃🏿♀️🗽
Thanks so much. This is way better than the first one. I was a bit confused
This was very Helpful
VA
Much better than the official Coursera Google Sheets course
Thanks, I've learned a lot!
I hate google sheet, but because of this, I love doing it now.. Thank you best ever
You make everything easy
Very informative! Thanks!
This is so crazy I mean whenever I search about something your channel blow up like you do every single thing that I'm searching for and I need to subscribe good luck..
This is just what I needed. Thank you Kevin !
thanks for the video, extremely helpful.
did google get rid of the explore button though?
Thank you Kevin. I have learned a lot in this video.
Thank you so much. You are a life saver
Extremely nice video, I have learned a lot, especially about collaboration and using Google Forms. I am not only like but subscribing too
I'm really bad at all of this sort of stuff but this video was very straightforward and easy to understand. Thank you :)
Love your tutorials@ first, I like your voice, second, very easy terms to understand and technics, third, you show different styles. Thank you👍
Hi Kevin...long since have been following your videos. Thank you so much. Doing great job 👏
I learned so much. Thank you for uploading this.
The video is interesting and intriguing. Explanations are clear and interesting
thank you sir for sharing your golden knowledge... very nice.. love it
Another great video always wondered how to use Google sheets thought it was excel
It's similar but there are some notable differences.
It really helps. Amazing teacher.
Thank you very much, this was a peace of work well done here!! Thank you, once again from Portugal!
Thank you for making this! I really learned alot.
Take love from Bangladesh 🇧🇩
Well presented suiting my current needs. Thanks
You are so helpful and you teach so easily.