Uploaded September 2025 | Updated September 2026, 1 week ago
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: 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
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: 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
