Who it's for: Anyone looking for a free way 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.
Available in
days
days
after you enroll
- Introduction (0:08)
- Single and Multi-Level Sorting (3:35)
- Filtering Records in a List (3:45)
- Search Filter and Filter by Condition (2:35)
- Custom Filter Views (3:08)
- Inserting Data Charts (1:42)
- Formatting and Editing Chart Elements (7:50)
- Adding and Removing Data from a Chart (2:22)
- Inserting Sparkline (5:35)
- Alternating Colored Rows (3:21)
- Alternating Colors Button (1:22)
- Creating a Pivot Table (8:50)
- Creating a Pivot Chart (2:26)
- Filtering within Pivot Tables Using Slicers (2:24)
- Using the IF Function (8:01)
- Introduction to Nesting Functions (3:25)
- VLOOKUP Function (7:22)
- Using the IFERROR Function (3:01)
- Creating and Applying Names in a Worksheet (1:59)
- Summary-Based Functions SUMIF(S) and AVERAGEIF (6:39)
- Text Functions Left, Right, Mid, Concatenate and Split Text-To-Columns (5:10)
- Sharing and Managing Permissions (3:22)
- Macros (6:08)
- Conclusion (0:10)