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

Introduction

Getting organized with Google Sheets
Importing exercise files to Google Sheets

Getting Started with Google Sheets

What is Google Sheets
Accessing Google Sheets with your account
Navigating Google Sheets

Creating and Managing Spreadsheets

Creating, naming, and saving a spreadsheet
Copying and re-naming a spreadsheet
Moving a spreadsheet
Deleting a spreadsheet
Importing spreadsheets from Excel and OpenOffice
Importing data files

Editing Spreadsheets

Entering and editing cell data
Inserting, deleting, and clearing rows and columns
Moving or copying rows, columns, and cells
Editing with Find and Replace
Working with multiple sheets
Creating a series of numbers, letters, or dates
Inserting images or hyperlinks

Viewing Spreadsheets

Freezing rows and columns
Hiding rows, columns, and sheets
Using filters and creating filter views
Sorting data on a spreadsheet

Formatting, Printing, and Publishing Spreadsheets

Formatting cells, rows, and columns
Using conditional formatting
Printing a spreadsheet

Working with Spreadsheet Data

See the Sum, Average, Min, Max, or Count
Using formulas and functions
Using IF and nested functions in formulas
Creating charts and graphs
Using pivot tables
Using the VLOOKUP function

Collaborating with Google Sheets

Sharing a spreadsheet with other people
Collaborating and commenting on a spreadsheet
Working with spreadsheet revisions

Conclusion

Additional resources