Google Sheets Advanced Tutorial

Google Sheets Advanced Tutorial

For certificates, exams, and badges, join our Patreon community: https://www.patreon.com/learnittraining

Start 0:00
Introduction 0:03
Single and Multi-Level Sorting 0:11
Filtering Records in a List 3:47
Search Filter and Filter by Condition 7:32
Custom Filter Views 10:07
Inserting Data Charts 13:15
Formatting and Editing Chart Elements 14:58
Adding and Removing Data from Charts 22:48
Inserting Sparklines 25:11
Alternating Colored Rows 30:46
Alternating Colors Button 34:08
Creating a Pivot Table 35:30
Creating a Pivot Chart 44:21
Filtering Within Pivot Tables Using Slicers 46:48
Using the IF Function 49:12
Introduction to Nesting Functions 57:13
VLOOKUP Function 1:00:39
Using the IFERROR Function 1:08:01
Creating and Applying Names in a Worksheet 1:11:02
Summary-Based Functions SUMIF(S) and AVERAGEIF 1:13:02
Text Functions Left, Right, Mid, Concatenate, and Split Text-To-Columns 1:19:41
Sharing and Managing Permissions 1:24:52
Macros 1:28:14
Conclusion 1:34:23

Видео Google Sheets Advanced Tutorial канала Learnit Training