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.)
Overview
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.
Prerequisites
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-
Gmail
Basic Interface:
Folder/Label List
Mail Pane
Chat Pane
Compose Window
Window Behavior
Basic Fields
Formatting
Spellcheck
Working with Labels
System Labels
Stars
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
Filters with Labels
Filters Built off Searches
Advanced Options
Right Side Chat
Preview Pane
Canned Responses (Templates)
Undo Send
Signature
Out Of Office Message
Forwarding
Google Contacts
Basic Interface
Labels
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
Comments
Revision History
Google Apps
Creating Documents:
Using Shared Documents
Chat
Comments
Analytics
Sheets:
Basic Interface
Formatting
Permissions per Sheet/cell range
Notification Rules
Docs
Basic Interface
Formatting
Outline
Suggesting Mode
Slides
Basic Interface
Formatting
Commenting
Importing Powerpoint Decks
Forms
Form Creation and use
-Google Docs-
The basics
Creating a new document
Finding your way around a Google Doc
What are in the menus?
File
Edit
View
Format
Add-ons
Help
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
Left
Centre
Right
Justify
Manually adding a page break
Ruler
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
Printing
Total pages and sheets of paper
Destination
Pages
Copies
Options
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
Outline
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
Comments
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
Dictionary
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
Capitalization
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
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
GGS110