Google Sheets Advanced Tutorial

Master advanced Google Sheets techniques in this comprehensive 1 hour 35 minute tutorial. Dive into sorting, filtering, and custom filter views to efficiently organize data. Create and customize charts, sparklines, and pivot tables for insightful data visualization. Learn essential functions like IF, VLOOKUP, and IFERROR, along with text manipulation techniques. Explore data analysis with SUMIF(S) and AVERAGEIF functions. Discover how to share spreadsheets, manage permissions, and automate tasks using macros. Perfect for anyone looking to enhance their data management and analysis skills using Google's powerful spreadsheet application.

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