Description

Google Sheets is a powerful tool to organize information and perform calculations, integrated directly into Google Drive. This course will demonstrate the basic functions of Google Sheets, including entering information, sorting the information using formulas to perform basic calculations, and integrating with other spreadsheets. Many of these features will work similarly to other spreadsheet programs such as Microsoft Excel. With what you learn here, you’ll be well on your way to using the basic features of Sheets.

Assumptions

Participants in this course should have some basic familiarity with using Google Drive. Passing familiarity with Excel will be useful, but not required.

Required Participant Prep Work

None

Agenda

Participants in this session will complete a series of hands-on exercises covering the following skills:

Why Use Sheets?
Creating New Sheets

Converting from Excel

Sheets workbook overview:

Cells
Rows and columns
A1 notation
Sheets

Entering information to cells

Manually
Drag-to-fill

Deleting and/or clearing cells:

Clearing contents
Deleting groups of cells
Deleting entire rows/columns

Data Types/Formats

General
Text
Number
Date
Currency

Sorting Data
Formulas
Sharing Sheets

Protecting Cells
Cell history

Charts

Creating Charts
Editing and Formatting Charts
Multiple Data Types

Pivot Tables

Creation
Editing

Explore

Outcomes

After completing this module, participants will be able to:

Explain key benefits of using Google Sheets
Create Google Sheets documents
Use formulas and auto-fill
Share Sheets with others
Protect parts of sheets from changing
Create Charts
Bring external data into Google Sheets

Instructor Prep Work

Module Design
Course Materials
Communication

Handled through HR or Plant Ops

Support Map

Additional Online Help--GCF LearnFree
Customer Service Desk

Browser not supported