Hello guys, Welcome to Africa's Largest Video Search Engine, and you are watching Google Sheets Advanced Tutorial. and this video is uploaded by Learnit Training at 2020-12-18T10:00:10-08:00. We are just promoting this video only for entertainment and educational purpose only. I hop you like our Video Search Engine. [t0B0Tgz0b-0]
| Name | Google Sheets Advanced Tutorial |
| Video Uploader | Video From Learnit Training |
| Upload Date | This Video Uploaded At 18-12-2020 18:00:10 |
| Video Discription | Google Sheets Advanced Tutorial Get Ad-Free Training by becoming a member today! https://www.youtube.com/channel/UCqyBfm_H9ugGirk1ufYA2YA/join Exercise Files: https://bit.ly/3udealu 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. For ad free training and certificates please join Learnit Anytime: https://www.learnitanytime.com 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. [t0B0Tgz0b-0] |
| Category | Education |
| Tags | Google Sheets | Google Sheets Tutorial | Google Sheets Advanced | Google Sheets Advanced Tutorial | Sheets Tutorial | Sheets Advanced | Sheets Advanced Tutorial | Free Sheets Tutorial | Free Sheets Advanced Tutorial | Free Google Sheets Tutorial | Free Google Sheets Advanced Tutorial | Sheets |
