Google Sheets Full Course - Google Sheets Advanced Tutorial

Google Sheets Advanced Tutorial Get Ad-Free Training by becoming a member today! https://www.youtube.com/channel/UCqyBfm_H9ugGirk1ufYA2YA/join Join Learnit Anytime for ad-free training, exams, certificates, and exclusive content: https://www.learnitanytime.com Exercise Files: https://tinyurl.com/425rhbw2 Who it's for: Anyone looking to gather, format, and interpret data in a spreadsheet. What it is: Google Sheets is Google’s free, web-based spreadsheet application that mirrors the magic of Microsoft Excel, with some standout features and key differences as well. What you'll learn: First, students will be shown how to navigate the app. Then, they’ll learn the basics like creating and sharing spreadsheets. Next, they’ll learn how to calculate data with functions and formulas, as well as how to filter and sort all their data. Finally, users will get some hands-on time with popular features like Pivot Tables, AutoFill, VLOOKUP, Macros, and more. 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 Learnit is no longer associated with this channel/video. (C) 2025 Bomberry Productions Any illegal reproduction of this content will result in immediate legal action.