Google Sheets Advanced Tutorial
Get Ad-Free Training by becoming a member today!
/ @learnittraining
Exercise Files: 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:
www.learnitanytime.com
Enroll in our live, instructor-led Google Sheets classes:
bit.ly/3zT2PcO
For Private Group Trainings please visit:
www.learnit.com/private-group...
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.