Google Sheets Advanced Tutorial

Start
Introduction
Single and Multi-Level Sorting
Filtering Records in a List
Search Filter and Filter by Condition
Custom Filter Views
Inserting Data Charts
Formatting and Editing Chart Elements
Adding and Removing Data from Charts
Inserting Sparklines
Alternating Colored Rows
Alternating Colors Button
Creating a Pivot Table
Creating a Pivot Chart
Filtering Within Pivot Tables Using Slicers
Using the IF Function
Introduction to Nesting Functions
VLOOKUP Function
Using the IFERROR Function
Creating and Applying Names in a Worksheet
Summary-Based Functions SUMIFS and AVERAGEIF
Text Functions Left, Right, Mid, Concatenate, and Split Text-To-Columns
Sharing and Managing Permissions
Macros
Conclusion