Google Sheets Tutorial for Beginners
Video Overview & Insights
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.
Continue learning Google Sheets with FREE Official Training offered by Google:
✅ Google Sheets Getting Started course: https://bit.ly/3UwekAu
✅ Google Sheets Advanced Topics course: https://bit.ly/3tpxDj2
✅ Google Sheets Functions, Formulas, and Charts course: https://bit.ly/3UNI9vV
This video is sponsored by Google.
🏫 FREE TRAINING OFFERED BY GOOGLE
This voice sounds like a news reporter or an ad for tech... engaging and somewhat too clean. Saving this video to watch later
- Google Sheets Getting Started course: https://bit.ly/3UwekAu
- Google Sheets Advanced Topics course: https://bit.ly/3tpxDj2
ive used spreadsheets since 2005 and i learnt a lot from this, ty
i wish there was a recommended "102" video of things to be aware that exist
- Google Sheets Functions, Formulas, and Charts course: https://bit.ly/3UNI9vV
📚 RESOURCES
Video hay, cảm ơn bạn!
- Google Sheets Start Page: http://sheets.google.com/
- Google Sheets New Blank Spreadsheet: http://sheets.new/
I can’t even get through the stupid “captcha” even after downloading and probably paying for the Google captcha phone app. Sheets won’t even let me into the certification coirse
- How to use Google Forms video: https://youtu.be/I4T-FGZo7zo
- Sample Workbook Used in Video: https://docs.google.com/spreadsheets/d/1cA5v_v6KBrz_2scR78HBgfKr7jBVxfizJKSHtwLxQOE/edit?usp=sharing
Solid content as always.
⌚ TIMESTAMPS
00:00 Introduction
A yo why is your profile pic a random smiling black man.
00:46 Official Google Sheets training
01:43 What is Google Sheets
This is really cool and needs consistent practice 🥺🥺🥹❤️❤️
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
I cant see this button explore in my goole sheet, it this only for premium ?
13:42 Conditional formatting
15:07 Hide columns & rows
thank you, and have a great idea.
15:57 Insert columns & rows
16:57 Freeze columns & rows
Thank you so much. You made it so easy to understand ❤
17:42 Column stats
19:01 Explore
thanks pal.. going to nail that job
19:54 Addition
21:52 Subtraction
22:13 Multiplication
22:35 Division
Google Sheets feels like you’re in the cockpit and the plane is falling somewhere unknown.
22:54 Functions
23:40 SUM function
Kevin, you have been a great help. Thank you.
25:53 Relative & absolute references
28:20 Named ranges
thanks my brother
29:32 VLOOKUP function
31:57 Multiple worksheets
33:57 Sort & filter
35:30 Filter views
Kevins and his obsession with cookies 😂.well this channel was recommended by chatgpt
36:39 Charts
39:09 Pivot tables
Great tutorial !
42:49 Create a new form
44:23 Share & collaborate with others
i dont have explore in my google sheet i dont know why maybe i have just windows 10 hhhh
47:24 Version history
48:02 Publish, email, & print
Thanks
48:31 Wrap up
📺 RELATED VIDEOS
- Playlist with all my videos on Google Products: https://youtube.com/playlist?list=PLlKpQrBME6xLGL3Ty_1Wbd3nTZ_q_OKFQ
Explore button no longer there
📩 NEWSLETTER
- Get the latest high-quality tutorial and tips and tricks videos emailed to your inbox each week: https://kevinstratvert.com/newsletter/
Thanks for this very nice and easy to follow tutorial.
🔽 CONNECT WITH ME
- Official web site: http://www.kevinstratvert.com
You are a great teacher -awesome. Thank you.
- LinkedIn: https://www.linkedin.com/in/kevinstratvert/
- Discord: https://bit.ly/KevinStratvertDiscord
thanks a lot kevin😉😉
- Twitter: https://twitter.com/kevstrat
- Facebook: https://www.facebook.com/Kevin-Stratvert-101912218227818
This video absolutely blew my expectations away!
- TikTok: https://www.tiktok.com/@kevinstratvert
- Instagram: https://www.instagram.com/kevinstratvert/
Such a great video for someone like me new to spreadsheets- thank you so much ❤
🙏 REQUEST VIDEOS
https://forms.gle/BDrTNUoxheEoMLGt5
This man waisted 3 minutes of the video talking about things we already know
🔔 SUBSCRIBE ON YOUTUBE
https://www.youtube.com/user/kevlers?sub_confirmation=1
🙌 SUPPORT THE CHANNEL
- Hit the THANKS button in any video!
i can't find the explore button, so i used the shortcut but still nothing showed up, what is wrong with my google sheets
- Amazon affiliate link: https://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)
@kevinstratvert ....thank you so much,
#stratvert #googlesheets #googlecloudskillbadge #googlecloudskillsboost
Ako lang talaga ang di nka gets🤣
More User Perspectives
13:53 what do you highlight with on windows. I know you highlight with shift key on mac.
@Cadlan-y2bThank you so much for providing this tutorial! It helped me a lot :)
@رحابهاشم-ق4ثbtw, why mine don't have an option for explore? thanks
@MingPal17this is really helpful, thank you
@StoriesWorthWritingThis is one of the most thorough; yet wonderfully paced instructional videos I have ever watched. I am new to Google Workspace because I am doing a portfolio since I am exploring new career options. This allows me to follow along and to understand Google Sheets in a way that I never did Microsoft Excel. This has taken all the anxiety away from doing a sample for my portfolio using Google Sheets. Thanks!
@softlyrelentlessBrilliant ❤
@ShefaliYadav-n4gWow I’m so behing never even heard of google sheets trying to apply for a data entry part time and they want Google Sheets
@rosac8168Thank you for sharing!
@Sara.7378Hey Kevin, I use Google Sheets but Smart Fill (example Months did not work in my case) Do you know why?
@SarahMiledHow do I add/subtract in google sheets?
Say, I have various numbers in collumn A, and I want to add the number 50 to each number. How do I do this?
Explore tool is no longer available, btw your tutorial is a top notch compared to others and easy to follow.
@chrisreyes2736Great tutorial 👍
Appreciate
great tutorial bro! tahnks
@muhammadariffahmi2024Excel or google sheets either of them
@strongkind198