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: [ Ссылка ]
- Google Sheets Advanced Topics course: [ Ссылка ]
- Google Sheets Functions, Formulas, and Charts course: [ Ссылка ]
📚 RESOURCES
- Google Sheets Start Page: [ Ссылка ]
- Google Sheets New Blank Spreadsheet: [ Ссылка ]
- How to use Google Forms video: [ Ссылка ]
- Sample Workbook Used in Video: [ Ссылка ]
⌚ 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: [ Ссылка ]
📩 NEWSLETTER
- Get the latest high-quality tutorial and tips and tricks videos emailed to your inbox each week: [ Ссылка ]
🔽 CONNECT WITH ME
- Official web site: [ Ссылка ]
- LinkedIn: [ Ссылка ]
- Discord: [ Ссылка ]
- Twitter: [ Ссылка ]
- Facebook: [ Ссылка ]
- TikTok: [ Ссылка ]
- Instagram: [ Ссылка ]
🙏 REQUEST VIDEOS
[ Ссылка ]
🔔 SUBSCRIBE ON YOUTUBE
[ Ссылка ]
🙌 SUPPORT THE CHANNEL
- Hit the THANKS button in any video!
- Amazon affiliate link: [ Ссылка ] (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
Google Sheets Tutorial for Beginners
Теги
kevin stratvertgoogle sheetssheetsgoogle sheets formulasgoogle sheets functionsgoogle sheets tutorialgoogle sheets tutorial for beginnersgoogle sheetgoogle sheet tutorialsheetgooglehow to use google sheetsgoogle spreadsheet tutorialgoogle sheet formulagoogle sheets formulagoogle spreadsheet formulasvlookupsumpivot tablepivot tableschartschartgoogle spreadsheetspreadsheethow to use google sheetspreadsheet tutorialspreadsheetsexcel