Autoplay
Autocomplete
Previous Chapter
Complete and Continue
Google Sheets Advanced
Exercise Files - Download Before Starting the Course
Exercise Files
Course
Introduction (0:37)
List, Format, and Sort (2:27)
Multi-Column Sort (2:07)
Filters (2:57)
Conditional Filters and Filtered Views (3:39)
Creating Charts (2:51)
Editing Charts (3:15)
Removing and Deleting Chart Data (2:25)
Sparklines (2:39)
Formatting with Alternating Row Colors (1:13)
Pivot Tables (4:13)
Pivot Charts (2:40)
Named Ranges (4:49)
IF Functions (3:04)
Nested Functions (3:05)
VLOOKUP (3:28)
SUMIF and AVERAGEIF (3:59)
SUMIFS (2:36)
AVERAGEIFS (2:30)
IFERROR (2:23)
LEFT and RIGHT (2:36)
CONCATENATE (2:04)
Sharing Files (1:44)
Real-Time Authoring (1:59)
Google Sheets Add-Ons (1:55)
Introduction to Google Apps Scripts (2:17)
Conclusion (0:41)
CONCATENATE
Chapter content locked
If you're already enrolled,
you'll need to login
.
Enroll in Course to Unlock