Google Sheets Tutorial for Beginners

Video Description

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: https://youtu.be/I4T-FGZo7zo - Sample Workbook Used in Video: https://docs.google.com/spreadsheets/d/1cA5v_v6KBrz_2scR78HBgfKr7jBVxfizJKSHtwLxQOE/edit?usp=sharing ⌚ 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: https://youtube.com/playlist?list=PLlKpQrBME6xLGL3Ty_1Wbd3nTZ_q_OKFQ 📩 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: https://www.linkedin.com/in/kevinstratvert/ - Discord: https://bit.ly/KevinStratvertDiscord - Twitter: https://twitter.com/kevstrat - Facebook: https://www.facebook.com/Kevin-Stratvert-101912218227818 - TikTok: https://www.tiktok.com/@kevinstratvert - Instagram: https://www.instagram.com/kevinstratvert/ 🙏 REQUEST VIDEOS https://forms.gle/BDrTNUoxheEoMLGt5 🔔 SUBSCRIBE ON YOUTUBE https://www.youtube.com/user/kevlers?sub_confirmation=1 🙌 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