Master the concepts in Google Sheets Tutorial for Beginners presented by Kevin Stratvert. This full video course has a total duration of 49:11 minutes with crystal clear HD video and audio quality. Access this full online lesson on any desktop PC, Mac, tablet, or smartphone.
Looking for comprehensive guides, code examples, or step-by-step walkthroughs for Google Sheets Tutorial for Beginners? Enjoy instant video playback and interactive course recommendations to help you master new skills quickly. Check out related tutorials and recommended courses below TutorTube.
Course Description & Lesson Notes
Official 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
🌐 Web & Search Guide Notes (DuckDuckGo, Yahoo & Bing):
Discover how to understand Google Sheets Tutorial For Beginners with this comprehensive video tutorial guide. In this detailed walkthrough, you will learn essential skills for Google Sheets Tutorial For Beginners.
Mastering Google Sheets Tutorial For Beginners is essential for modern technical workflows and software skills. Follow along with top-rated video tutorials from industry experts today on TutorTube.
Watch Google Sheets Tutorial For Beginners full video tutorial and step-by-step course guide with high quality video and audio details on TutorTube.
Watch carefully to master this topic efficiently on TutorTube.
🎓 Lesson Overview & Learning Outcomes:
Welcome to the step-by-step video guide for Google Sheets Tutorial for Beginners taught by Kevin Stratvert. This tutorial provides a comprehensive walkthrough designed to take you from foundational principles to practical implementation.
💡 Key Topics Covered in This Course:
- Core Fundamentals & Setup: Understanding the workspace, essential tools, and initial setup for Google Sheets Tutorial for Beginners.
- Step-by-Step Practical Demonstration: Hands-on implementation guided by Kevin Stratvert with real-world examples.
- Best Practices & Key Shortcuts: Time-saving workflows, keyboard shortcuts, and industry-standard recommendations.
- Troubleshooting & Common Pitfalls: How to avoid common beginner errors and optimize your workflow for peak efficiency.
📋 Recommended Prerequisites & Study Notes:
No prior advanced experience is required. Follow along with the video player above on any desktop computer, tablet, or mobile device. Pause and rewind at key steps to practice along with the instructor.
Explore more related video tutorials, course modules, and topic guides on TutorTube.