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.
Exercise Files - Download Before Starting the Course
Available in
days
days
after you enroll
Course
Available in
days
days
after you enroll
- Introduction (0:37)
- List, Format, and Sort (2:27)
- Multi-Column Sort (2:07)
- Filters (2:57)
- Conditional Filters and Filtered Views (3:39)
- Creating Charts (2:51)
- Editing Charts (3:15)
- Removing and Deleting Chart Data (2:25)
- Sparklines (2:39)
- Formatting with Alternating Row Colors (1:13)
- Pivot Tables (4:13)
- Pivot Charts (2:40)
- Named Ranges (4:49)
- IF Functions (3:04)
- Nested Functions (3:05)
- VLOOKUP (3:28)
- SUMIF and AVERAGEIF (3:59)
- SUMIFS (2:36)
- AVERAGEIFS (2:30)
- IFERROR (2:23)
- LEFT and RIGHT (2:36)
- CONCATENATE (2:04)
- Sharing Files (1:44)
- Real-Time Authoring (1:59)
- Google Sheets Add-Ons (1:55)
- Introduction to Google Apps Scripts (2:17)
- Conclusion (0:41)