Google Sheets Tutorial for Beginners

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 KZbin
kzbin.info?...
🙌 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

[@KevinStratvert]

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

[@rushabh5423]

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 KZbin Music effectively, How to use Google maps effectively

[@NatesGransanti-hm1vy]

​@@rushabh542336:50

[@eucellaeryanyue303]

omg hes jus tryna help ppl @@rushabh5423

[@Mia92247]

Me 😢I'm very scared 😱

[@nirvanatork2524]

thanks Kevin

[@angelcmercado2022]

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.

[@amanpalestina9664]

Kind of calm, comforting and understand what we want to understand

[@williamericashby]

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!

[@PrDannyRomero]

Who else here cause you lied to your job about being able use Excel and now they want you to use it 😂

[@joakimboateng]

😂😂

[@animate9612]

😂😂😂

[@toyaallure88]

😂😂

[@waterbudgie]

relatable…

[@I_love_space.]

Not me, just here because I am curious.

[@MrBobbyantonio]

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.

[@Sasha0927]

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]

Of course! Glad it helped!

[@endrisk1513]

@@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 ??

[@JulianaKucko]

Kevin, you are my FAVORITE KZbin 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!

[@sindylowry82]

Thank you for being a great teacher and simplifying this for us!

[@lloydyu24]

Love how your tone is so comforting and makes it easier to understand.

[@noahwinberry2475]

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!

[@charlie5116]

same here! thought I knew quite some skills but still learned so many

[@KimaniWaNdirangu]

Wow! Thanks Kevin. This was quite a comprehensive beginner tutorial.

[@menchiedelosreyes5591]

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

[@Paulie8K]

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.

[@mohammedibrahem2233]

Much simpler to use than MS Excel sheets , amazing

[@PotatoLoverAndAFujoshi]

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!

[@djoetma]

Wow, this must've been a ton of work. Good to know this is out there.

[@jamiewarr7196]

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.

[@vishnusuraj9914]

Thank you, Kevin I started using Sheets a while back now ❤️❤️❤️❤️❤️❤️👍👍👍👍👍⭐⭐⭐⭐⭐

[@kimpliny]

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!

[@Cnelsoncan]

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!

[@alanakhan4050]

Awesome! Super helpful and it started with the basics (just what I needed).

[@CaseyFaris]

Excellent work as usual, Kevin! I learned a lot!

[@rololoy2]

I’ve been looking all over for this! Thanks my brother 🙏

[@Illjustwait]

Thanks Kevin! I've got my first big boy job coming up and this video is a lifesaver.

[@bahodursadikov2493]

Yay, thank you just for fun learned the google sheets basics! Keep it up man, we love you!

[@DOAsesh]

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!

[@midori4352]

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.

[@ilyasdri6982]

man!!! you really good at explaining things ... keep up the good work and thank you

[@Patienze]

Thank you Kevin! You are one of the best instructors in youtube

[@princessreid3903]

I absolutely love your videos, very informative, clear, and easy to understand. thank God for you, continue doing a great job.

[@Jesstravels247]

This was exactly what i was looking for! Thank you for this great tutorial!

[@priyankasingh8759]

Hi Kevin...long since have been following your videos. Thank you so much. Doing great job 👏

[@EmekaAmuta]

this was a wonderful learning experience Kevin. thank you so much

[@mitchellyula4447]

Thanks Kevin. Learned a lot of new things and time for me to apply it!

[@marthabruce1853]

This is just what I needed. Thank you Kevin !

[@Quran.And.Science]

You... Are unbeatable Kevin. Keep that great work up.

[@b.n_coaching]

Very informative and complete! Thank you for this video!

[@patrickmeehan6856]

This is awesome! I appreciate the fact that you don't presume knowledge of Excel.

[@takenneth]

Thank you for making this! I really learned alot.

[@yasinrc7579]

absolutely loved the way you explain this!

[@ebonydarknessdementiaraven4610]

I'm really bad at all of this sort of stuff but this video was very straightforward and easy to understand. Thank you :)

[@wintermorillo6567]

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.

[@Lance-Dela-Cruz]

One of the best tutorials out there!

[@IceyWolf69]

Highly underrated. Wonderful breakthrough and explaintation.

[@shayshay7578]

Kevin your awesome!!! You make it so easy to learn and understand!

[@marcovelastegui9252]

Bravo! Thank you so much for the video. You are a wonderful teacher!

[@rojeanlopez1678]

Thank you so much Kevin! All the best.

[@DOAsesh]

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!

[@kennethacuna9996]

This is so good you deserve every view! Your teaching method is very easy to understand and your voice is very friendly

[@HildaCV]

What an awesome training!!! Thank you!!

[@laasya_swamy]

You just made my life SO much more easier!!! Thank you so much!

[@andrealuengo7705]

Thanks, I've learned a lot!

[@ruthsmith122]

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.

[@BrookeT9462]

I learned so much. Thank you for uploading this.

[@yan_ki9597]

This has been really helpful

[@RealEkhlas]

It really helps. Amazing teacher.

[@rakibulsitab]

Wow, this video was so helpful! Thank you for sharing your knowledge and expertise on this topic

[@mishealyse]

Google's tutorials gave me a headache. Thank you for all you do!

[@bassjarvis11]

This was helpful, thanks brotha!

[@ibro6240]

Thank you, this video is so helpful for beginners!

[@marzheavenz4449]

Thank you Kevin. I have learned a lot in this video.

[@mohammedibrahem2233]

And Kevin you are incredibly professional in your teaching , thank you so much

[@KevinStratvert]

Wow, thank you!

[@christophernixon5295]

Very informative! Thanks!

[@alosimeon29]

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.

[@Cyfix15]

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

[@videostok2452]

Bonjour Kevin, Thank you for your video. Toujours au Topppp

[@jaredoirere4746]

Well presented suiting my current needs. Thanks

[@stephenbrown9400]

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.

[@CNM3]

Excellent presentation Kevin, you earned a new subscriber.

[@OfficialJustinRahman]

Very helpful thank you.

[@daliamohamed4548]

That was amazing I definitely learned lots of things Thank you

[@sabamaaood7198]

You are such an amazing trainer

[@nowornevernever5860]

Learned alot from this video. Thank you so much

[@trml16ecb]

Kevin, It was a perfect video for beginners.

[@silverghostxx]

Wow Kevin, this video is absolutely incredible!❤

[@MinhNguyen-mk7cc]

Thank you!

[@Scalp269]

Awesome information!!!! Very well presented!!! Thank you so much!!!!!!

[@sirmarky9991]

You are so helpful and you teach so easily.

[@athiranvijayakumar1990]

great stuff.learned so much ..thank you for making such a useful video.

[@tresfelando3035]

Thanks sir....Simple and very easy to follow 👍

[@user-ze3bf9ee5v]

Thank you so much. You are a life saver

[@richardnnamdi3414]

Great tutorial will sure learn alot from your videos. Many thanks

[@wllymchng]

Clear tutorial, thank you

[@paulocamacho2976]

Thank you very much, this was a peace of work well done here!! Thank you, once again from Portugal!

[@tasnime4598]

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..

[@user-gv2jb8lm8k]

Kevin, you are the best! :) I adore your videos.

[@desm2467]

Many thanks Kevin!

[@lovemoonkiss]

Thank you so much Kevin.

[@7FigExec]

So perfect. Thanks for sharing.

[@Oluwafunmmilola]

Thanks so much Kevin for your videos. They're really helpful. I passed my Computer User Skills Tests..

[@zofiarado5786]

Hello I’m preparing too for my tests! I will continue following Kevin. Thank you!

[@EliInk]

Very helpful. Thank you so much.

[@woudychapman1232]

Thank you so much!

[@johnmanivong3222]

Thank you Kevin!

[@AKSourGod]

Very very helpful 👏🏾

[@ms.caramelkaojidaisy3694]

thank you so much! i appreciate your hard work. This video is very detailed and also help me a lot.

[@go-learn]

great stuff Kevin!! really appreciate it! 👍👍

[@KevinStratvert]

No problem 👍

[@2136thenatureboy1]

You are so informative, all of your videos.

[@tuitnensi]

Love it, helps so much thanx heaps Kevin 🥰🙏

[@RealEkhlas]

Thanks for the video ☺️

[@AllYay]

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.