Google Sheets Essential Training (2021)

Course details

Learn how to organize and analyze data in Sheets, the popular spreadsheet tool from Google. Instructor Sally Norred starts with a tour of the Sheets interface, then shows how to enter and work with data. Sally demonstrates the formatting and formula/function features, shows off the collaboration tools in Sheets, and provides smart ways to make your data work for you. Whether you’re new to spreadsheets or you’re a longtime Excel user looking for ways to share and collaborate, this web-based spreadsheet offering from Google may be just the app for you.

Concepts

0. Introduction

01 - Get organized with Google Sheets
02 - Importing exercise files to Google Sheets

1. Getting Started with Google Sheets

03 - What is Google Sheets
04 - Accessing Google Sheets with your account
05 - Navigating Google Sheets

2. Creating and Managing Spreadsheets

06 - Creating, naming, and saving a spreadsheet
07 - Copying and renaming a spreadsheet
08 - Moving a spreadsheet
09 - Deleting a spreadsheet
10 - Importing spreadsheets from Excel and OpenOffice
11 - Importing data files

3. Editing Spreadsheets

12 - Entering and editing cell data
13 - Inserting, deleting, and clearing rows and columns
14 - Moving or copying rows, columns, and cells
15 - Working with multiple sheets
16 - Creating a series of numbers, letters, or dates
17 - Inserting images and hyperlinks

4. Viewing Spreadsheets

18 - Freezing rows and columns
19 - Hiding rows, columns, and sheets
20 - Using filters and creating filter views
21 - Sorting data on a spreadsheet

5. Formatting, Printing, and Publishing Spreadsheets

22 - Formatting cells, rows, and columns
23 - Using conditional formatting
24 - Printing a spreadsheet

6. Working with Spreadsheet Data

25 - See the Sum, Average, Min, Max, or Count
26 - Using formulas and functions
27 - Using IF and nested functions in formulas
28 - Creating charts and graphs
29 - Using pivot tables

7. Collaborating with Google Sheets

30 - Sharing a spreadsheet with other people
31 - Collaborating and commenting on a spreadsheet
32 - Working with spreadsheet revisions

Conclusion

33 - Additional resources