Google Sheets Full Course Tutorial

Get Ad-Free Training by becoming a member today!
https://www.youtube.com/channel/UCqyBfm_H9ugGirk1ufYA2YA/join

Join Learnit Anytime for ad-free training, exams, certificates, and exclusive content:
https://www.learnskillsdaily.com

Exercise Files: https://tinyurl.com/5ca4cmnn

Who it’s for: This Google Sheets Full Course is for anyone who wants a complete start-to-finish walkthrough of Google Sheets—from brand-new beginners who need help getting comfortable with the interface and entering data, to learners who want to build real spreadsheets and then level up into intermediate and advanced skills like managing multi-tab workbooks, charting, sharing/collaboration, and more powerful analysis tools.

What it is: Google Sheets is a cloud-based spreadsheet application from Google that lets you organize data, perform calculations, build charts, and collaborate with others in real time from any device with internet access. It works similarly to traditional spreadsheet programs, but because it is part of Google Workspace, your files are saved online automatically and can be easily shared for viewing, commenting, or editing. Google Sheets is commonly used for tasks like budgeting, tracking information, analyzing data, creating reports, managing projects, and building simple data-driven workflows for work, school, or personal use.

What you’ll learn: You’ll learn the full Google Sheets workflow: what Sheets is and how to start files from Drive/templates, navigate the interface, enter and format data, copy/paste and autofill, build formulas and core functions (including absolute references), and make spreadsheets look professional with formatting, borders, alignment, themes, and printing/export options—then move into intermediate topics like multi-sheet workbooks/tabs, sorting and filtering, freeze panes, charts/graphics, sharing permissions and protecting ranges, and finally advanced topics like advanced functions (logical/lookup/text/date), pivot tables, macros for automation, and using Google Forms to collect data directly into Sheets.

Start 0: 00
Introduction 0: 08
Opening Google Sheets 1: 43
Importing 4: 30
Interface – 7: 37
Interface – B 9: 32
File Menu 11: 23
Create-Save-Help 14: 06
Help 15: 23
Entering Data 15: 38
Navigating 20: 57
Navigating and Data Selection 24: 08
Copy Paste 25: 55
Data Types 27: 52
Format Values 29: 38
Auto Fill 31: 14
Insert Links 34: 13
Formulas – A 35: 23
Formulas – B 38: 49
Order of Operations 40: 21
Creating Basic Formulas 44: 34
Creating More Formulas 45: 18
Cell References 51: 40
Functions 55: 19
Formula and Function Practice 56: 27
Formatting 56: 58
Formatting more 1: 00: 55
Paint Format 1: 03: 00
Practice Formatting 1: 04: 33
Formatting Rows 1: 04: 41
Formatting Column Width 1: 05: 59
Insert Note 1: 06: 54
Checkboxes 1: 07: 53
Theme 1: 09: 05
Beginner Conclusion 1: 09: 50
Advanced Introduction 1: 12: 03
Practice File 1: 13: 11
Import Practice File 1: 13: 34
Zoom 1: 14: 37
Tabs 1: 15: 52
Hide Tab 1: 21: 17
Sorting 1: 22: 33
More Sorting 1: 24: 06
More Sorting and Practice 1: 26: 24
Filter 1: 27: 23
Freeze 1: 30: 30
Printing 1: 32: 54
Find and Spell 1: 36: 09
Download 1: 37: 16
PDF 1: 40: 00
Share 1: 40: 12
More Share 1: 41: 58
Charts 1: 42: 48
More Charts 1: 49: 42
More Chart Features 1: 53: 36
Chart Practice 1: 54: 13
Images and Drawings 1: 55: 27
Linking 2: 00: 09
Protect Sheets and Ranges 2: 04: 10
More Protect Sheets 2: 05: 02
Protect Sheets and Ranges Practice 2: 05: 41
Version History 2: 06: 16
Accessiblity 2: 09: 42
Named Ranges 2: 10: 05
Intermediate Conclusion 2: 12: 21
Advanced Introduction 2: 14: 40
Using Logical Statements 2: 16: 58
AND OR 2: 17: 55
IF 2: 22: 14
OR IF Practice 2: 25: 29
Formatting 2: 25: 53
Nested IF 2: 27: 14
SUMIF and more 2: 27: 14
VLOOKUP 2: 31: 18
VLOOKUP performed 2: 33: 14
VLOOKUP performed more 2: 36: 10
HLOOKUP 2: 37: 38
INDEX and MATCH 2: 41: 16
Split Text to Columns 2: 43: 25
CONCAT and more 2: 45: 42
CONCAT practice 2: 47: 25
LEFT and more 2: 48: 03
UPPER 2: 52: 51
LOWER and PROPER 2: 53: 45
LEN 2: 54: 51
Data Cleanup 2: 55: 53
Date Functions 2: 57: 06
More Date Functions 2: 59: 26
Named Functions 3: 00: 18
Data Validation 3: 01: 07
Conditional Formatting 3: 02: 25
Group 3: 04: 11
Merge Cells 3: 05: 01
Pivot Tables 3: 06: 41
More Pivot Tables 3: 07: 39
Slicer 3: 09: 11
Macro 3: 10: 45
More Macro 3: 14: 23
Scripts 3: 17: 00
Tables 3: 18: 21
Forms 3: 20: 03
Building a Form 3: 24: 06
Testing a Form 3: 31: 20
Summary of Forms 3: 33: 04
Conclusion 3: 34: 02

#sheets #tutorial #googleworkspace

UshopWell.com

The Premiere Online Marketplace

Google Sheets Full Course Tutorial