Play all

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

Description:

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.

Google Sheets Advanced Tutorial

Learnit Training

Add to list

#Business #Business Software #Google Workspace #Google Sheets #Data Science #Data Analysis #Data Visualization #Spreadsheets #Pivot Tables #Macros #VLOOKUP

0:00 / 0:00