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

📚 RESOURCES

⌚ 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

📩 NEWSLETTER

🔽 CONNECT WITH ME

🙏 REQUEST VIDEOS

🔔 SUBSCRIBE ON YOUTUBE

🙌 SUPPORT THE CHANNEL
- Hit the THANKS button in any video!

#stratvert #googlesheets #googlecloudskillbadge #googlecloudskillsboost

[KevinStratvert]

Continue learning Google Sheets with FREE Official Training offered by Google:

[angelcmercado]

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.

[debbiansimpson]

I do not think anyone could teach this any clearer. 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 😂

[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!

[Sasha]

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!

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

[sindylowry]

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

[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!

[noahwinberry]

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!

[djoetma]

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

[lloydyu]

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

[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!

[jamiewarr]

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.

[KimaniWaNdirangu]

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

[vishnusuraj]

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

[alanakhan]

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

[LoiseKihara]

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.

[midori]

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.

[Quran.And.Science]

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