Google Sheets Advanced Tutorial

Google Sheets Advanced Tutorial 2023 Update 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://https://learnitanytime.com/p/exercise-files-google-sheets-advanced-tutorial-2023 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, real-time collaboration, and more. Manuals: https://bit.ly/30xZb59 Username: manuals Password: password Start 0:00 Introduction 0:09 List, Format, and Sort 0:46 Multi-Column Sort 3:13 Filters 5:21 Conditional Filters and Filtered Views 8:18 Creating Charts 11:57 Editing Charts 14:49 Removing and Deleting Chart Data 18:04 Sparklines 20:30 Formatting with Alternating Row Colors 23:09 Pivot Tables 24:22 Pivot Charts 28:36 Named Ranges 31:16 IF Functions 36:05 Nested Functions 39:10 VLOOKUP 42:15 SUMIF and AVERAGEIF 45:43 SUMIFS 49:42 AVERAGEIFS 52:19 IFERROR 54:49 LEFT and RIGHT 57:12 CONCATENATE 59:49 Sharing Files 1:01:53 Real-Time Authoring 1:03:38 Google Sheets Add-Ons 1:05:37 Introduction to Google Apps Scripts 1:07:32 Conclusion 1:09:50 #googlesheets #googlesheetstutorial #googleworkspace #googleworkspacetutorial (C) 2023 Learnit, Inc. Any illegal reproduction of this content will result in immediate legal action.