Welcome to ONLC Training Centers


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

Formatting your data
Changing to currency format
Changing to percentages
Accounting and financial formats

Functions and formulas are your friends!
So, what are Google Sheet formulas?
What are functions?

Controlling rows and columns (part 1)
Changing row size of rows and columns
Selecting the whole row or column
Inserting a row or column
Deleting a row or column
Inserting specific cells
Deleting specific cells
Splitting text into columns

Controlling rows and columns (part 2)
Selecting multiple rows or columns
Deleting unwanted rows and columns
Hiding and unhiding rows and columns
Freezing rows and columns
Grouping rows and columns

Cell references - Absolute & relative

Moving, copying & pasting data
Moving cells
Copying and pasting cells
Paste special
Quick sequential numbers

Moving beyond one sheet
Renaming sheets
Adding colors to the sheet tabs
Duplicating sheets
Adding sheets
Deleting sheets
Moving sheets
Moving the tabs to find a particular sheet
Hiding sheets
Sheet tab menu
Adding references to other sheets

Sharing, printing and downloading
Printing sheet(s)
Controlling what to print
Scale
Margins
Custom page breaks
Formatting
Headers and footers
Downloading a spreadsheet in different formats
Emailing a spreadsheet
Sharing a spreadsheet

Filtering your data
Filter - By value
Filter - By condition
Filter View
Duplicating a filter

Conditional Formatting & Custom Formulas
Conditions
Custom formula

Sorting your data
Randomize range

Merging cells
Merge all
Merge vertically and horizontally

Notes and comments
Adding notes
Editing a note
Deleting a note
Adding comments
Replying to a comment
Resolving a comment
Editing a comment
Deleting a comment
Comments - Tab info
Assigning actions via Comments

Sparklines
Inserting basic sparklines (line graphs)
Adding extra options to your sparklines
Line graphs
Changing sparkline chart type

Creating charts (part 1)
Creating and inserting a simple chart
Data
Chart types
Stacking Data
Range
X-Axis and Series
Rows and Columns
Customize your chart
Chart Style
Chart & Axis Titles
Series
Legend
Horizontal Axis
Vertical Axis

Creating charts (part 2)
Adding a new series to a chart
Creating charts with two different scales
Editing the title, subtitle and axis titles

Alternating colors

Adding Links
Linking a sheet
Linking a specific cell
Linking to a range of cells
Linking to an external site

The Explore tool
Insert a chart
Editing the data range
Asking questions about your data
Quickly formatting your data

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

View outline in Word

XGA1SH

Attend hands-on, instructor-led Google Sheets Introduction training classes at ONLC's more than 300 locations. Not near one of our locations? Attend these same live classes from your home/office PC via our Remote Classroom Instruction (RCI) technology.

For additional training options, check out our list of Courses and select the one that's right for you.

Microsoft Gold Partner
Class Dates
(click date for class times)
(click Enroll for locations)

Fee:  $295

Savings options:

 CEA Apps Saver
Need a price quote?

Follow the link to our self-service price quote form to generate an email with a price quote.

Email Alert

Receive an email when this class is available as "Ready to Run" or "Early Notice" status.

Attend from your office or home

If you have high-speed internet and two computers you can likely take this class from your office or home.

Need a class for a group?

We can deliver this class for a private group at your location. Follow the link to request more information.

Attend computer classes from ONLC Training Centers Request a copy via mail

GENERAL INFO

Class Format
Class Policies
Student Reviews

Bookmark and Share


HAVE QUESTIONS?
First Name

Last Name

Company

Phone

Email

Location

Question/Comment



ONLC TRAINING CENTERS
800-288-8221
www.onlc.com