Welcome to ONLC Training Centers

G Suite On-Demand: Basics (Google Apps Overview, Google Docs, Google Sheets)

Microsoft Gold Partner


Need a price quote?

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

G Suite On-Demand: Basics (Google Apps Overview, Google Docs, Google Sheets) Course Outline

***Note: This is an On-Demand, Self-Study Class, days of content, 6-months unlimited access, $295***
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) classes.(Applicable State and Local taxes may be added for On-Demand purchases, depending on your location.)

Google Apps will acquaint you with the basic use of Gmail and Google Docs. Google Docs & Google Sheets will show you how to create, edit, share, and print documents. This course is recommended for users who would like to get to know Gmail and Apps, Google
Docs, and Google sheets in more depth or who are converting to G Suite from another office suite such as Microsoft Office.

Basic email and document creation knowledge is required. 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.If you have never used a word processor before, you should not take this class.

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 links below:
Google Apps Overview with Gmail, Drive, Docs & Sheets
Google Docs Introduction
Google Sheets Introduction

Course Outline

-Google Apps Overview-

Basic Interface:
Folder/Label List
Mail Pane
Chat Pane

Compose Window
Window Behavior
Basic Fields

Working with Labels
System Labels
Importance Markers
Inbox Views with Pre-Built Labels
Sent Mail
All Mail
Creating and Ordering your own labels

Finding Mail
Conversation View
Search Box
Advanced Searching
Search Operators

Automating Mail
Filters with Labels
Filters Built off Searches

Advanced Options
Right Side Chat
Preview Pane
Canned Responses (Templates)
Undo Send
Out Of Office Message

Google Contacts
Basic Interface

Google Calendar
Basic Interface
Other Calendars
Calendar Sharing
Meeting Creation
Calendar Options

Google Drive
Basic Interface:
Folder Pane
File Pane
Info Pane
Info and Activity
View Options

Adding Files
Uploading Files
Creating new Files
Google Docs
MS Office Docs

Sharing Files
Permission Levels
Google Docs Versus uploaded files

Advanced Options
Revision History

Google Apps
Creating Documents:
Using Shared Documents

Basic Interface
Permissions per Sheet/cell range
Notification Rules

Basic Interface
Suggesting Mode

Basic Interface
Importing Powerpoint Decks

Form Creation and use

-Google Docs-
The basics
Creating a new document
Finding your way around a Google Doc
What are in the menus?
What's on the Toolbar

How to make your text look better
How to select the text
How to change the font
Adding more fonts
Changing the font size
Adding bold, italics and underlining
Changing the font color
Highlighting your text
Adding strike-through
Adding superscript and subscript

Setting up the page
Page setup
Changing the page orientation
Changing the size of the page
Changing the colour of the paper
Changing the page margins
Changing the alignment of the text
Manually adding a page break
Adding columns

Getting to grips with tables
Inserting a table
Deleting a table
Adding information to a table Inserting rows & columns
Deleting rows & columns
Column width & row height
Distribute rows and columns
Vertical & horizontal alignment of cells
Horizontal alignment
Vertical alignment
Cell background color
Table borders
Changing all the borders
Changing specific borders
Merging and unmerging rows & columns
Table alignment
Cell padding

Making bulleted & numbered lists
Making basic lists (bulleted and numbered)
Numbered list
Bulleted list
Making sub-lists
Other list formats
Numbered lists
Bulleted lists
Adding space to lists
More bullets
Restart numbering

Working with images
Inserting images
Upload from computer
Resizing the image
Adding a border and changing its properties
Cropping an image
Rotating an image
Changing the image properties
Replacing an image
Positioning an image in a text
In line
Wrap text
Break text

Total pages and sheets of paper
More settings
Open PDF in Preview
Page preview icons

Inserting headers, footers, and page numbers
Inserting headers and footers
Inserting page numbers and page counts

Inserting links, drawings & lines
Inserting hyperlinks
Inserting drawings
Inserting a horizontal line

Spelling, personal dictionary & word count
Word count

Paragraph styles (Headings)
What are they?
Using a default paragraph style
Setting a paragraph style
Setting the default styles
Borders and shading
Table of contents

Sharing, emailing, and downloading
Downloading a document
Emailing a document
Email collaborators
Email as attachment
Sharing a document

Adding comments and suggestions
Comment notifications
Sending actions via comments
Document modes: Editing, suggesting, viewing
Accepting and rejecting all suggested edits

Working with another language
Translating a document
Using a different language

Inserting special characters & mathematical equations
Inserting special characters
Finding special characters
Adding mathematical equations

Voice typing and voice control
Voice typing
Correcting your text
Formatting your document

Version history
How to name a version history
How to show only named version histories

Explore and Dictionary
Explore tool

Connecting charts & slides to Docs
Adding a chart to a Google Doc
Adding a chart from a spreadsheet
Inserting slides into a Doc

Extra useful tools
Opening files from within Docs
Creating new files from within Docs
Doc templates
Make a copy of the current document
Organize (moving from within Docs)
Starring the file
Full screen
Find and replace
Adding information to and from Google Keep

-Google Sheets-

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
Custom page breaks
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
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

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
Chart types
Stacking Data
X-Axis and Series
Rows and Columns
Customize your chart
Chart Style
Chart & Axis Titles
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


Attend hands-on, instructor-led G Suite On-Demand: Basics (Google Apps Overview, Google Docs, Google Sheets) 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 G Suite Courses and select the one that's right for you.


Class Format
Class Policies
Student Reviews

Bookmark and Share

First Name

Last Name