Completed
Start
Class Central Classrooms beta
YouTube videos curated by Class Central.
Classroom Contents
Google Sheets Advanced Tutorial
Automatically move to the next video in the Classroom when playback concludes
- 1 Start
- 2 Introduction
- 3 Single and Multi-Level Sorting
- 4 Filtering Records in a List
- 5 Search Filter and Filter by Condition
- 6 Custom Filter Views
- 7 Inserting Data Charts
- 8 Formatting and Editing Chart Elements
- 9 Adding and Removing Data from Charts
- 10 Inserting Sparklines
- 11 Alternating Colored Rows
- 12 Alternating Colors Button
- 13 Creating a Pivot Table
- 14 Creating a Pivot Chart
- 15 Filtering Within Pivot Tables Using Slicers
- 16 Using the IF Function
- 17 Introduction to Nesting Functions
- 18 VLOOKUP Function
- 19 Using the IFERROR Function
- 20 Creating and Applying Names in a Worksheet
- 21 Summary-Based Functions SUMIFS and AVERAGEIF
- 22 Text Functions Left, Right, Mid, Concatenate, and Split Text-To-Columns
- 23 Sharing and Managing Permissions
- 24 Macros
- 25 Conclusion
