Google Apps Essentials Training: Docs, Slides, Sheets

Google Apps Essentials Training: Docs, Slides, Sheets

Course Length: 1 day
Delivery Methods: Multiple delivery options
Course Benefits
  • Learn to get your free Google account and set up for instant access to your documents.
  • Learn to upload and use the documents you've already created with Microsoft Office.
  • Learn to use Google Spreadsheet to create charts to display spreadsheet data.
  • Learn to master Google Docs' easy, powerful document-editing and formatting tools.
  • Learn to insert images into your documents and presentations.
  • Learn to share documents securely with your colleagues.
  • Learn to back up your documents offline and edit them when you don't have an internet connection.
Available Delivery Methods
Public Class
Public expert-led online training from the convenience of your home, office or anywhere with an internet connection. Guaranteed to run .
Private Class
Private classes are delivered for groups at your offices or a location of your choice.
Course Overview

This Google Essentials Apps training will empower your team to work with the different Apps included in the Google Apps suite for businesses. This course will teach your team how to effectively set up and use Gmail, Google Calendar and Google Docs.

Course Outline
  1. Getting Started with Google Drive
  2. Starting Word Processing
    1. Creating Your First Document
      1. Naming the Document
      2. Entering Text
      3. Saving the Document
    2. Introducing Formatting
      1. Using the Formatting Toolbar
      2. Using Keyboard Shortcuts
    3. Printing a Document
      1. Inserting Headers and Footers
      2. Inserting Page Breaks
      3. Checking Your Spelling
      4. Choosing Your Print Settings
      5. Exporting and Printing the Document
    4. Deleting a Document
  3. Formatting Documents
    1. Formatting a Document
    2. Working with Templates
      1. Creating a New Document from a Template
      2. Saving a Document as a Template
    3. Importing and Exporting Documents
      1. Importing Documents
      2. Exporting a Document
    4. Doing Research
      1. Using a Dictionary, Thesaurus, or Encyclopedia
      2. Searching the Web from Your Document
    5. Working Offline
      1. Downloading and Installing Gears
      2. Activating Gears
      3. Using Gears to Work Offline
      4. Tweaking Your Offline Settings
  4. Taking Your Docs to the Next Level: Lists, Tables, and Insertions
    1. Working with Lists
      1. Creating a List
      2. Editing a List
    2. Adding Tables to a Document
      1. Creating a Table
      2. Editing a Table
    3. Inserting and Editing Images
      1. Getting an Image into Your Document
      2. Editing Images
      3. Deleting an Image
    4. Working with Hyperlinks and Bookmarks
      1. Inserting a Hyperlink
      2. Editing a Hyperlink
      3. Inserting a Bookmark
      4. Creating a Table of Contents
      5. Editing a Table of Contents
  5. Sharing and Collaborating on Documents
    1. Sharing a Document
      1. Step 1: Choose Sharers and Set Permissions
      2. Step 2: Send an Optional Email Invitation
      3. Receiving a Document-Sharing Notification
      4. Changing a Document's Ownership
      5. Emailing All Viewers/Collaborators
      6. Removing Sharing
    2. Other Ways to Share a Document
      1. Emailing a Document
      2. Publishing a Document on the Web
    3. Collaborating on a Document
      1. Collaboration and Offline Editing
      2. Using Color-Coded Comments
    4. Working with a Document's Revision History
      1. Viewing Revisions
      2. Comparing Versions
  6. Introducing Spreadsheets
    1. Spreadsheet Basics
      1. What Is a Spreadsheet?
      2. What Can a Cell Contain?
      3. What Makes a Good Spreadsheet Design?
    2. Creating Your First Google Docs Spreadsheet
      1. Selecting Cells and Entering Data
      2. Saving a Spreadsheet
    3. Creating a New Spreadsheet from a Template
    4. Formatting a Spreadsheet
      1. Formatting Numbers
      2. Formatting Dates and Times
      3. Formatting Appearance
      4. Creating Formatting Rules
      5. Working with Multiple Sheets
    5. Working with Data
      1. Importing Data into Google Docs
      2. Exporting Data from Google Docs
      3. Exporting as an XLS or ODS File
      4. Entering Data
      5. Clearing Data
      6. Working with Rows and Columns
      7. Sorting Data
    6. Printing and Deleting Spreadsheets
      1. Printing a Spreadsheet
      2. Deleting a Spreadsheet
  7. Spreadsheets: Formulas and Charts
    1. Working with Spreadsheet Formulas
      1. What Is a Formula?
      2. Creating Formulas: The Basics
      3. Supercharging Your Formulas with Functions
    2. Getting the Big Picture with Charts, Graphics, and Gadgets
      1. Kinds of Charts
      2. Creating a Chart
      3. Editing a Chart
      4. Putting an Image into Your Spreadsheet
      5. Editing an Image
      6. Google Docs Spreadsheets and Google Gadgets
      7. Editing a Gadget
  8. Sharing and Collaborating on Spreadsheets
    1. Sharing Spreadsheets
      1. Publishing a Spreadsheet on the Web
      2. Embedding a Spreadsheet in Your Web Site or Blog
      3. Inviting Others to Share a Spreadsheet
    2. Collaborating on Spreadsheets
      1. Working Simultaneously
      2. Chatting as You Work
      3. Commenting on a Spreadsheet
      4. Receiving Notifications
    3. Creating a Form to Gather Data
      1. Creating a New Spreadsheet by Designing a Form
      2. Creating a Form for an Existing Spreadsheet
      3. Emailing a Form
      4. Embedding a Form in a Web Page or Blog
      5. Editing a Form
      6. Editing a Form's Confirmation Message
      7. Analyzing Form Data
      8. Disabling or Deleting a Form
    4. Working with a Spreadsheet's Revision History
  9. Introducing Presentations
    1. What's a Presentation?
      1. Why Use Google Docs for Presentations?
      2. Some Pointers for Designing a Presentation
    2. Your First Presentation
      1. Starting from Scratch
      2. Naming Your Presentation
      3. Getting an Existing Presentation into Google Docs
      4. Adding a New Slide
      5. Selecting a Slide and Inserting Text
      6. Saving a Presentation
    3. Giving Your Slides Pizzazz
      1. Adding Some Style with a Theme
      2. Giving Your Slides a Custom Background
      3. Formatting Text
      4. Adding Images, Shapes, and Videos
      5. Moving and Resizing Elements
      6. Arranging Elements on a Slide
      7. Revealing Elements One by One
      8. Deleting an Element
    4. Working with Slides
      1. Importing Slides
      2. Copying a Slide
      3. Moving a Slide
      4. Adding Speaker Notes
      5. Deleting a Slide
    5. Working with Presentations
      1. Previewing a Presentation
      2. Exporting a Presentation
      3. Printing a Presentation
      4. Deleting a Presentation
  10. The Main Event: Sharing and Viewing Presentations
    1. Sharing a Presentation
    2. Collaborating on a Presentation
    3. Giving a Live Presentation
      1. Starting the Show
      2. During the Presentation
      3. Ending a Presentation
    4. Publishing a Presentation on the Web
      1. Making a Presentation Public
      2. Embedding a Presentation in Your Web Page or Blog
    5. Working with Revisions
Class Materials

Each student will receive a comprehensive set of materials, including course notes and all the class examples.

Register for a Live Class
Please select a class.
Request a Private Class
  • Private Class for your Team
  • Online or On-location
  • Customizable
  • Expert Instructors
Request Pricing