Google Sheets Tutorial for Beginners
HTML-код
- Опубликовано: 11 июл 2024
- In this step-by-step tutorial, learn how to use Google Sheets. Google Sheets is completely free to use, and you can use it to get insights from your data. We begin with the absolute basics of how you can even get started in Sheets. Once we cover the basics, we advance to entering formulas and functions, inserting charts, using pivot tables, collecting data from a form, and so much more. By the end of this video, you'll be proficient in using Google Sheets.
This video is sponsored by Google.
🏫 FREE 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
📚 RESOURCES
- Google Sheets Start Page: sheets.google.com/
- Google Sheets New Blank Spreadsheet: sheets.new/
- How to use Google Forms video: • Google Forms Tutorial
- Sample Workbook Used in Video: docs.google.com/spreadsheets/...
⌚ TIMESTAMPS
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
📺 RELATED VIDEOS
- Playlist with all my videos on Google Products: • How to use Google Prod...
📩 NEWSLETTER
- Get the latest high-quality tutorial and tips and tricks videos emailed to your inbox each week: kevinstratvert.com/newsletter/
🔽 CONNECT WITH ME
- Official web site: www.kevinstratvert.com
- LinkedIn: / kevinstratvert
- Discord: bit.ly/KevinStratvertDiscord
- Twitter: / kevstrat
- Facebook: / kevin-stratvert-101912...
- TikTok: / kevinstratvert
- Instagram: / kevinstratvert
🙏 REQUEST VIDEOS
forms.gle/BDrTNUoxheEoMLGt5
🔔 SUBSCRIBE ON RUclips
ruclips.net/user/kevlers?...
🙌 SUPPORT THE CHANNEL
- Hit the THANKS button in any video!
- Amazon affiliate link: amzn.to/3kCP2yz (Purchasing through this link gives me a small commission to support videos on this channel -- the price to you is the same)
#stratvert #googlesheets #googlecloudskillbadge #googlecloudskillsboost - Наука
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 RUclips Music effectively, How to use Google maps effectively
@@rushabh542336:50
omg hes jus tryna help ppl @@rushabh5423
Me 😢I'm very scared 😱
thanks Kevin
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’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
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!
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 laid out and simple intructions. thanks. i love the chapters, makes it so easy to come back and double check any questions i have.
Love how your tone is so comforting and makes it easier to understand.
Thank you for being a great teacher and simplifying this for us!
Awesome! Super helpful and it started with the basics (just what I needed).
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.
Excellent work as usual, Kevin! I learned a lot!
I’ve been looking all over for this! Thanks my brother 🙏
Kevin, you are my FAVORITE RUclips 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!
This has been really helpful
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, Kevin I started using Sheets a while back now ❤️❤️❤️❤️❤️❤️👍👍👍👍👍⭐⭐⭐⭐⭐
You... Are unbeatable Kevin. Keep that great work up.
This is just what I needed. Thank you Kevin !
Hi Kevin...long since have been following your videos. Thank you so much. Doing great job 👏
One of the best tutorials out there!
man!!! you really good at explaining things ... keep up the good work and thank you
Thank you Kevin! You are one of the best instructors in youtube
Much simpler to use than MS Excel sheets , amazing
Thanks Kevin. Learned a lot of new things and time for me to apply it!
I absolutely love your videos, very informative, clear, and easy to understand. thank God for you, continue doing a great job.
This was exactly what i was looking for! Thank you for this great tutorial!
absolutely loved the way you explain this!
this was a wonderful learning experience Kevin. thank you so much
Wow, this must've been a ton of work. Good to know this is out there.
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
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.
What an awesome training!!! Thank you!!
Very informative and complete! Thank you for this video!
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!
Kevin your awesome!!! You make it so easy to learn and understand!
Bravo! Thank you so much for the video. You are a wonderful teacher!
Thanks Kevin! I've got my first big boy job coming up and this video is a lifesaver.
This was helpful, thanks brotha!
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.
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.
I learned so much. Thank you for uploading 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!
Thank you so much Kevin! All the best.
Thank you for making this! I really learned alot.
Thanks, I've learned a lot!
Highly underrated. Wonderful breakthrough and explaintation.
Wow Kevin, this video is absolutely incredible!❤
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 video was so helpful! Thank you for sharing your knowledge and expertise on this topic
Very informative! Thanks!
You just made my life SO much more easier!!! Thank you so much!
As always your videos are very straigh forward, very easy to understand, I have knowlegde of excel and with this tutorial I was easily able to catch up with most of the things needed to start working with google worsheets. Thank you for your dedication making this wonderful videos.
Thanks man!! This was quite helpful.
Awesome information!!!! Very well presented!!! Thank you so much!!!!!!
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!
Love it, helps so much thanx heaps Kevin 🥰🙏
Kevin, you are the best! :) I adore your videos.
Bonjour Kevin,
Thank you for your video.
Toujours au Topppp
Thank you, this video is so helpful for beginners!
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!
It really helps. Amazing teacher.
great stuff.learned so much ..thank you for making such a useful video.
Kevin, It was a perfect video for beginners.
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.
Clear tutorial, thank you
Thank you Kevin. I have learned a lot in this video.
So perfect. Thanks for sharing.
Many thanks Kevin!
Thank you very much, this was a peace of work well done here!! Thank you, once again from Portugal!
kevin thank you, this is awesome.
You are so informative, all of your videos.
This is awesome! I appreciate the fact that you don't presume knowledge of Excel.
Well presented suiting my current needs. Thanks
Thank you so much Kevin.
You are such an amazing trainer
Thank you Kevin!
That was amazing
I definitely learned lots of things
Thank you
Learned alot from this video. Thank you so much
Excellent presentation Kevin, you earned a new subscriber.
Thank you so much. You are a life saver
Very helpful. Thank you so much.
Great tutorial will sure learn alot from your videos. Many thanks
thanks, Kevin this video was helpful.
This is so good you deserve every view! Your teaching method is very easy to understand and your voice is very friendly
Very helpful thank you.
Thanks sir....Simple and very easy to follow 👍
You are so helpful and you teach so easily.
Amazing tutorial honestly! No more can be said! Incredible! Subscribed and dropped a like! Keep going
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.
thank you so much! i appreciate your hard work. This video is very detailed and also help me a lot.
Thank you!
I'm really bad at all of this sort of stuff but this video was very straightforward and easy to understand. Thank you :)
Thank you for sharing such valuable info. Great help, easy to understand
great stuff Kevin!! really appreciate it! 👍👍
No problem 👍
Very very helpful 👏🏾
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.
Thanks for the video ☺️
Thank you so much!
I love your video!
Thank you for making this video and sharing it with us all!
It will make my job a lot earier.
God Bless You!