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