Google Sheets Introduction Course Outline

(1 day)Overview
This one-day class will show you how to create, edit, share, and print documents with Google Sheets. The class is recommended for users who would like to get to know Google Sheets in more depth or who are converting to G Suite from another office suite such as Microsoft Office.

Special Note to New Hampshire Residents
This course has not yet been approved by the State's Department of Education. Please contact us to get an update as to when the class should be available in New Hampshire.

Prerequisites
To ensure your success in this course, you should have end-user computer skills, including being able to start programs, switch between programs, locate saved files, close programs, and access websites using a web browser.

Who Should Not Attend
If you have never used a spreadsheet program before, you should not take this class. The class is fast-paced and assumes you understand the basic spreadsheet concepts. You know how to do things in Microsoft Excel--now you just need to learn how to do the same things in Google Sheets.

Course Outline

The Basics
How to create a Google Sheet
Finding your way around a Google Sheet
Adding data onto the sheet

Cell formatting
Adding cell borders
Filling the cells with colours
Changing the position of the data in the cells (justification)
Putting the data in bold
Changing the font, font size, and selecting text wrap
Text rotation

Data Validation
Setting up data validation to check for a valid for a date
Checking data meets a ‘numbers’ criteria and rejecting invalid entries
Setting up a “list of items” validation
Setting up a “list from a range” validation
Open-ended lists
Drop-down menu in alphabetical order
Creating a drop-down list which can be added to