Google Sheets Tutorial for Beginners
ฝัง
- เผยแพร่เมื่อ 2 มิ.ย. 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 TH-cam
th-cam.com/users/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 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
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.
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 ??
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!
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.
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.
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.
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!
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!
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
Thank you for being a great teacher and simplifying this for us!
Thank you, Kevin I started using Sheets a while back now ❤️❤️❤️❤️❤️❤️👍👍👍👍👍⭐⭐⭐⭐⭐
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!
Wow, this must've been a ton of work. Good to know this is out there.
Wow! Thanks Kevin. This was quite a comprehensive beginner tutorial.
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!
Much simpler to use than MS Excel sheets , amazing
Yay, thank you just for fun learned the google sheets basics! Keep it up man, we love you!
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.
Google's tutorials gave me a headache. Thank you for all you do!
Awesome! Super helpful and it started with the basics (just what I needed).
Thanks Kevin! I've got my first big boy job coming up and this video is a lifesaver.
Highly underrated. Wonderful breakthrough and explaintation.
I’ve been looking all over for this! Thanks my brother 🙏
man!!! you really good at explaining things ... keep up the good work and thank you
I absolutely love your videos, very informative, clear, and easy to understand. thank God for you, continue doing a great job.
You are literally the best teacher ever. You're teaching style is perfect for following along with thank you
Hi Kevin...long since have been following your videos. Thank you so much. Doing great job 👏
You... Are unbeatable Kevin. Keep that great work up.
Thank you Kevin! You are one of the best instructors in youtube
This was exactly what i was looking for! Thank you for this great tutorial!
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!
this was a wonderful learning experience Kevin. thank you so much
This is awesome! I appreciate the fact that you don't presume knowledge of Excel.
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 Kevin. Learned a lot of new things and time for me to apply it!
This is just what I needed. Thank you Kevin !
Thank you so much Kevin! All the best.
Very informative and complete! Thank you for this video!
absolutely loved the way you explain this!
Thank you for making this! I really learned alot.
Thanks, I've learned a lot!
This is so good you deserve every view! Your teaching method is very easy to understand and your voice is very friendly
One of the best tutorials out there!
You are such an amazing trainer
Kevin, you are the best! :) I adore your videos.
Wow, this video was so helpful! Thank you for sharing your knowledge and expertise on this topic
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.
What an awesome training!!! Thank you!!
Bravo! Thank you so much for the video. You are a wonderful teacher!
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.
Excellent work as usual, Kevin! I learned a lot!
Kevin your awesome!!! You make it so easy to learn and understand!
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
Great video, We at chartmat love google sheets and you can build apps and dashboards from it.
😉
Very helpful thank you.
I learned so much. Thank you for uploading this.
Bonjour Kevin,
Thank you for your video.
Toujours au Topppp
I'm really bad at all of this sort of stuff but this video was very straightforward and easy to understand. Thank you :)
This was helpful, thanks brotha!
It really helps. Amazing teacher.
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!
Very informative! Thanks!
Wow Kevin, this video is absolutely incredible!❤
Thank you, this video is so helpful for beginners!
Im from Germany and not that good in english. I full understand the video. Very clear and with good explanations. Liked it
great stuff.learned so much ..thank you for making such a useful video.
Awesome information!!!! Very well presented!!! Thank you so much!!!!!!
great stuff Kevin!! really appreciate it! 👍👍
No problem 👍
Thank you!
So perfect. Thanks for sharing.
Amazing tutorial honestly! No more can be said! Incredible! Subscribed and dropped a like! Keep going
Excellent presentation Kevin, you earned a new subscriber.
Thank you so much. You are a life saver
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!
Learned alot from this video. Thank you so much
Love it, helps so much thanx heaps Kevin 🥰🙏
Kevin, It was a perfect video for beginners.
That was amazing
I definitely learned lots of things
Thank you
Thank you very much, this was a peace of work well done here!! Thank you, once again from Portugal!
Thank you Kevin!
Great tutorial will sure learn alot from your videos. Many thanks
Well presented suiting my current needs. Thanks
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
Thanks sir....Simple and very easy to follow 👍
Thanks for the video ☺️
kevin thank you, this is awesome.
And Kevin you are incredibly professional in your teaching , thank you so much
Wow, thank you!
Very helpful. Thank you so much.
Clear tutorial, thank you
You are so informative, all of your videos.
Thank you so much Kevin.
thanks, Kevin this video was helpful.
Thank you for sharing such valuable info. Great help, easy to understand
thank you so much! i appreciate your hard work. This video is very detailed and also help me a lot.