Autoplay
Autocomplete
Previous Chapter
Complete and Continue
Google Sheets Advanced (Old Version)
Course
Introduction (0:08)
Single and Multi-Level Sorting (3:35)
Filtering Records in a List (3:45)
Search Filter and Filter by Condition (2:35)
Custom Filter Views (3:08)
Inserting Data Charts (1:42)
Formatting and Editing Chart Elements (7:50)
Adding and Removing Data from a Chart (2:22)
Inserting Sparkline (5:35)
Alternating Colored Rows (3:21)
Alternating Colors Button (1:22)
Creating a Pivot Table (8:50)
Creating a Pivot Chart (2:26)
Filtering within Pivot Tables Using Slicers (2:24)
Using the IF Function (8:01)
Introduction to Nesting Functions (3:25)
VLOOKUP Function (7:22)
Using the IFERROR Function (3:01)
Creating and Applying Names in a Worksheet (1:59)
Summary-Based Functions SUMIF(S) and AVERAGEIF (6:39)
Text Functions Left, Right, Mid, Concatenate and Split Text-To-Columns (5:10)
Sharing and Managing Permissions (3:22)
Macros (6:08)
Conclusion (0:10)
Text Functions Left, Right, Mid, Concatenate and Split Text-To-Columns
Chapter content locked
If you're already enrolled,
you'll need to login
.
Enroll in Course to Unlock