🥷 Master Google Sheets: Beginner's Fast Track

Welcome to Google Sheets! This video is a comprehensive beginner's course to Google Sheets, starting at the very beginning. When you're ready to move on, check out the many other tutorials we have on our channel. A good place to start is our basic guides covering some common formulas: https://www.youtube.com/playlist?list=PL8N8dF6K6B3NykPuAe9zS_iUhVPhvZtKw 0:00 Welcome 0:13 Creating a Google Sheets Spreadsheet 0:32 Create from a Template 1:00 Basic Google Sheet Management (Delete, Renaming, Move to Folder) 2:33 Overview of Menus 5:42 Toolbar 6:10 How to Share / Manage Access 7:03 Tab/Sheet Overview 7:48 Tab / Sheet Protection 9:05 Move / Hide / Show Tabs 9:37 Rows & Columns (Freezing, Resizing & Insert/Delete) 11:09 Entering Data & Using Auto-Fill to Save Time 12:55 Formatting Data (adding background and font colors, alternating rows) 15:20 Number Format (Currency, Dates, etc.) 16:29 Links - How to Add 17:01 Find & Replace 17:43 Checkboxes 18:05 Dropdowns 19:29 Dates and Date Picker 20:43 First formulas - cell references & math 23:23 Percentages 24:13 Don't Mix Numbers & Text 25:15 Moving a data table 25:52 Copy/Paste a Data Table 26:56 Inserting / Deleting Columns / Rows 28:09 Hide Gridlines 28:17 Adding Borders 29:55 Adding Data Table Title/Header 31:13 Intro to Formulas - Subtotals 34:39 Sparklines 35:16 Charts 37:44 Paint Format 38:33 Monthly Growth Rate formula 39:18 Adding Metrics/Stats Section 40:36 Named Ranges 42:19 Filter Tool 44:11 Quick Stats 44:42 Column Stats 44:53 Comments 46:05 Notes 46:57 Version History 48:35 Google Form 50:30 Tying Form Responses into Data Table 52:05 Sumifs 55:58 Updating Google Form to Sales Entry 58:55 Creating Expenses Table 1:00:44 Creating Sales Table 1:01:18 Setting Column Types on a Table 1:02:32 Filling in Sales Summary from Tables 1:04:29 Creating Pivot Tables & Charts 1:08:36 Conclusion