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:42)
- Accessing Google Sheets (2:49)
- Navigating in Cells and Menus (2:27)
- Keyboard Shortcuts (2:40)
- Editing Cell Contents (2:32)
- Templates (2:22)
- Using Explore (3:14)
- Opening and Saving Sheets (2:39)
- Using Google Drive with Google Sheets (2:33)
- Showing and Using the Formula Bar and Gridlines (1:59)
- Basic Formulas (3:09)
- Using Autofill to Copy Formulas (1:40)
- Using Autofill to Create Redundant Data (2:11)
- Simple Formulas (3:16)
- Formulas with Absolute References (4:53)
- Cut, Copy, and Paste (2:53)
- Inserting Rows and Columns (2:44)
- Wrapping Text, Rotating, and Aligning Cells (2:48)
- Cell Formatting (3:01)
- Hiding Rows and Columns (3:58)
- Freeze Panes and Full Screen View (2:06)
- Spell Check and Printing (3:12)
- Sharing and Emailing Sheets (2:46)
- Publishing to Web (1:52)
- Conclusion (1:35)