Welcome to ONLC Training Centers


Google Sheets On-Demand: Google Sheets Introduction Course Outline

 (1 day)
Special Note to New Hampshire Residents
This course has not yet been approved by the New Hampshire Department of Education. Please contact us for an update on when the class will be available in New Hampshire.

***Note: This is an On-Demand, Self-Study Class, 1 day of content, 6-months unlimited access, $195***
You may take this course at any time, there are no set dates. This On-Demand (self-study) training course includes expert lectures and demonstrations that cover the same content that is included in our instructor-led (ILT) class.(Applicable State and
Local taxes may be added for On-Demand purchases, depending on your location.)

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.

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.

What You Need to Take this Training
You may access the course from any device, provided you have internet access.

Do You Still Prefer a Live, Instructor-led Class?
Already know On-Demand, Self-Study training is not right for you? We also offer this same course content in a live, instructor-led format. For more details, click on the link below:
Google Sheets Introduction

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

GGA1SH

Attend hands-on, instructor-led Google Sheets On-Demand: 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

Price:$195

Need a price quote?

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

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