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:25)
- Start Page (1:41)
- Interface (1:36)
- Search the Menus (2:05)
- Navigating and Selecting Cells (2:45)
- Entering and Editing Data (3:11)
- Explore (5:13)
- Performing Simple Calculations (2:53)
- Saving (1:07)
- Introduction to Google Drive (3:18)
- Building Basic Formulas (3:40)
- Using Simple Functions (4:46)
- Copying Formulas and Functions with AutoFill (4:25)
- Relative vs Absolute Reference (6:14)
- Inserting Rows and Columns (3:27)
- Moving, Copying, and Pasting Data (2:56)
- Using AutoFill to Complete a Series of Values (3:12)
- Cell Formatting - Align, Text Rotation, Text Wrapping (4:12)
- Formatting Worksheet Data and Using Cell Design (3:10)
- Using Sheets Templates (1:32)
- Inserting, Deleting, Renaming, Moving, and Copying Worksheets (2:46)
- Freeze Panes (2:55)
- Currency Formatting (0:50)
- Hiding Rows and Columns (2:05)
- Spell Check (1:20)
- Using the Full-Screen View (0:54)
- Printing (1:36)
- Download Options (0:45)
- Publishing Sheets to the Web (1:05)
- Sending Google Sheets as Emails (1:53)
- Conclusion (0:12)