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 TH-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!!!!!
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.
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 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!
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!💙💎
Ü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.
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 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!
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!
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
Kevin, you are my FAVORITE TH-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!
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.
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
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
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 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..
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!
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.
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!!!👍🏃🏿♀️🗽
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 TH-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!!!!!
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.
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!
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.
I do not think anyone could teach this any clearer. THANK YOU!
Agree! This is the best tutorial on Google Sheets I've found.
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!
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!💙💎
Ü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.
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 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
Wow, this must've been a ton of work. Good to know this is out there.
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!
Thanks Kevin! I've got my first big boy job coming up and this video is a lifesaver.
Super helpful as I'm growing in my company. Mastering sheets is my goal for this year! Thank you for this
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!
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
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
Thank you Kevin! You are one of the best instructors in youtube
Love how your tone is so comforting and makes it easier to understand.
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!
Highly underrated. Wonderful breakthrough and explaintation.
Much simpler to use than MS Excel sheets , amazing
Kevin, you are my FAVORITE TH-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!
You... Are unbeatable Kevin. Keep that great work up.
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.
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.
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
Excellent work as usual, Kevin! I learned a lot!
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
Google's tutorials gave me a headache. Thank you for all you do!
Bravo! Thank you so much for the video. You are a wonderful teacher!
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.
This is soo useful...very detailed and well explained. Thank you!
Kevin is such a great teacher. Thank you.
So perfect. Thanks for sharing.
One of the best tutorials out there!
Thank you!
Im from Germany and not that good in english. I full understand the video. Very clear and with good explanations. Liked it
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!
Yay, thank you just for fun learned the google sheets basics! Keep it up man, we love you!
Thank you so much Kevin! All the best.
Wow! Thanks Kevin. This was quite a comprehensive beginner tutorial.
man!!! you really good at explaining things ... keep up the good work and thank you
This is awesome! I appreciate the fact that you don't presume knowledge of Excel.
This was very Helpful
VA
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.
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.
Great teacher. Thanks for such clear explanation.
Thank you so much for the very informative Video. I am so motivated to start using Google Sheets
And Kevin you are incredibly professional in your teaching , thank you so much
Wow, thank you!
Great video, We at chartmat love google sheets and you can build apps and dashboards from it.
😉
Thanks Kevin, you are such a good teacher(tutor), from Kenya.
This has been really helpful
I’ve been looking all over for this! Thanks my brother 🙏
Extremely nice video, I have learned a lot, especially about collaboration and using Google Forms. I am not only like but subscribing too
thanks for sharing your knowledge on how to use the google sheet
You are such an amazing trainer
Simple and easy to follow😊 thanks!
thanks for the video, extremely helpful.
did google get rid of the explore button though?
You make everything easy
Kevin, you are the best! :) I adore your videos.
going into details one by one, great Kevin👏👏
You just made my life SO much more easier!!! Thank you so much!
Excellent tutorial ❤❤
Learned alot from this video. Thank you so much
Much better than the official Coursera Google Sheets course
Thanks so much. This is way better than the first one. I was a bit confused
Well done Thank you much 👍👍👍
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.
The video is interesting and intriguing. Explanations are clear and interesting
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..
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 being a great teacher and simplifying this for us!
thank you sir for sharing your golden knowledge... very nice.. love it
Bonjour Kevin,
Thank you for your video.
Toujours au Topppp
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.
Pretty easy Kevin, thanks so much for your video🥰
This is topnotch presentation, Kev. Thank you buddy.
This is so great and detailed! Thank you so much @Kevin Stratvert! You make learning smooth and very well understood! You are amazing!🙌❤🤗
Very informative! Thanks!
This is amazing ❤❤❤
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!!!👍🏃🏿♀️🗽
Impressive, thanks for sharing... can you please guide how to apply password on google sheets?? thanks
Thank you so much for this video
So detailed and helpful,💯
Thank you, Kevin I started using Sheets a while back now ❤️❤️❤️❤️❤️❤️👍👍👍👍👍⭐⭐⭐⭐⭐
Thank you so much for such a nice way of explanation
Thank you Kevin 😊🙏... You make my confuse brain be enlightenment 🤣🤣😁👍👍
Your teaching is the best ❤❤❤
Very very helpful 👏🏾
So informative dudeee😍😍😍☺☺
This is so good you deserve every view! Your teaching method is very easy to understand and your voice is very friendly
Great video. You are very didactic. Thank you so much.
I liked your videos. your are a great instructor
This was exactly what i was looking for! Thank you for this great tutorial!
Thanks, I've learned a lot!
Love your tutorials@ first, I like your voice, second, very easy terms to understand and technics, third, you show different styles. Thank you👍
Thank you, your clip explain so clear and very easy to understand.