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: https://bit.ly/3UwekAu
Google Sheets Advanced Topics course: https://bit.ly/3tpxDj2
Google Sheets Functions, Formulas, and Charts course: https://bit.ly/3UNI9vV
📚 RESOURCES
Google Sheets Start Page: http://sheets.google.com/
Google Sheets New Blank Spreadsheet: http://sheets.new/
How to use Google Forms video: • Google Forms Tutorial
Sample Workbook Used in Video: https://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 Products
📩 NEWSLETTER
Get the latest high-quality tutorial and tips and tricks videos emailed to your inbox each week: https://kevinstratvert.com/newsletter/
🔽 CONNECT WITH ME
Official web site: http://www.kevinstratvert.com
LinkedIn: / kevinstratvert
Discord: https://bit.ly/KevinStratvertDiscord
Twitter: / kevstrat
Facebook: / kevin-stratvert-101912218227818
TikTok: / kevinstratvert
Instagram: / kevinstratvert
🙏 REQUEST VIDEOS
https://forms.gle/BDrTNUoxheEoMLGt5
🔔 SUBSCRIBE ON YOUTUBE
https://www.youtube.com/user/kevlers?...
🙌 SUPPORT THE CHANNEL
Hit the THANKS button in any video!
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)
#stratvert #googlesheets #googlecloudskillbadge #googlecloudskillsboost
Auf dieser Seite können Sie das Online-Video Google Sheets Tutorial for Beginners mit der Dauer stunde minuten sekunde in guter Qualität ansehen, das der Benutzer Kevin Stratvert 14 November 2022 hochgeladen hat, den Link mit Freunden und Bekannten teilen, dieses Video wurde auf Youtube bereits 1,406,551 Mal angesehen und es wurde von 24 tausend den Zuschauern gefallen. Viel Spaß beim Betrachtenden Zuschauern gefallen!
