Google Sheets Essential Training

Course details

Learn how to analyze and organize 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, and provides smart ways to make your data work for you.

Learning objectives
Recognize the basic functionality and interface elements of Google Sheets.
Describe how to enter and work with data in Sheets.
Format and personalize your spreadsheets.
Create formulas and functions to manipulate and process your data.
Use workflow tips and tricks to boost your efficiency.

Concepts

0. Introduction

01 - Getting 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 re-naming 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 - Editing with Find and Replace
16 - Working with multiple sheets
17 - Creating a series of numbers, letters, or dates
18 - Inserting images or hyperlinks

4. Viewing Spreadsheets

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

5. Formatting, Printing, and Publishing Spreadsheets

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

6. Working with Spreadsheet Data

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

7. Collaborating with Google Sheets

32 - Sharing a spreadsheet with other people
33 - Collaborating and commenting on a spreadsheet
34 - Working with spreadsheet revisions

Conclusion

35 - Additional resources