Autoplay
Autocomplete
Previous Lesson
Complete and Continue
Google Sheets Essentials
Introduction
Introduction To The Google Sheets Essentials Course (1:42)
Join The Course Community
How This Course Is Structured And Templates
November 2021 Google Sheets Menu Updates
Fundamentals
Introduction To Google Sheets (7:50)
Working With Sheets (4:36)
Rows, Columns And Cells (9:25)
Sharing Files (8:58)
Publish To The Web (2:36)
Collaboration And Integration (13:51)
Find And Replace (7:18)
Offline And Version History (5:52)
Protect Sheets (11:28)
Functions
Formula Syntax For European Users
Relative And Absolute referencing (11:39)
Starter Functions (12:59)
IF Function Part I (7:22)
IF Function Part II (10:41)
Working Across Multiple Sheets With ImportRange (14:20)
Vlookup Function Part I (7:20)
Vlookup Function Part II (8:46)
Working With Data
Data Types (7:45)
Dealing With Whitespaces (3:27)
Splitting Data Into Multiple Columns (9:18)
Combining Columns Of Data (4:42)
Sorting Data (5:24)
Filtering Data (10:12)
Duplicates (12:28)
Working With Excel Files (6:02)
Importing Data (3:07)
Formatting
Formatting 101 (7:39)
Alternating Rows (5:00)
Conditional Formatting Part I (8:12)
Conditional Formatting Part II (10:23)
Conditional Formatting Across Rows (10:38)
10 Tips To Make Your Google Sheets Look Great (15:34)
Pivot Tables
Introduction To Pivot Tables (13:38)
Pivot Table Fundamentals (10:27)
Pivot Table Advanced Features (9:45)
Charts
Bar And Column Charts (9:37)
Line Charts (6:10)
Pie Charts (9:54)
Combo Charts (6:43)
Forecasting Charts (3:22)
Custom Chart Labels (10:09)
Next Steps And Resources
A small ask from me...
Refer A Friend
Next Steps And Resources
Dealing With Whitespaces
Lesson content locked
If you're already enrolled,
you'll need to login
.
Enroll in Course to Unlock