Google Sheets Advanced Tutorial HD

Google Sheets Advanced Tutorial For ad free training and certificates please join Learnit Anytime: https://www.learnitanytime.com Exercise Files: https://bit.ly/3udealu Enroll in our live, instructor-led Google Sheets classes: https://bit.ly/3zT2PcO For Private Group Trainings please visit: https://www.learnit.com/private-group-classes-workshops 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 #GoogleSheets (C) 2021 Learnit, Inc. Any illegal reproduction of this content will result in immediate legal action.