This class provides an overview of Google Workspace Applications and how to share spreadsheets, documents, and presentations with others. In addition, it explains how to use Google Drive to store and share files and how to use Google Meet for online meetings and screen sharing. Applications introduced in this course include Drive, Sheets, Slides, Forms and Meet.
Who Should Attend
This course is recommended for users who want to get a quick overview of Google Workspace applications, file storage features, and online meeting software. This class is especially appropriate for individuals moving to Google Workspace from Microsoft Office.
Prerequisites
Basic email and document creation knowledge is required. Prior experience with Microsoft Office applications is helpful but not necessary.
Course Outline
Using Google Drive
- Signing in to Google Apps
- Using the Google Apps Menu
- Understanding the Google Drive Display Screen
- Changing Google Drive Display Options
- Creating a File from Drive
- Making a Copy of a File
- Moving a File to Trash
- Uploading a File from a Hard Drive
- Creating and Managing Folders
- Uploading a Folder from a Hard Drive
- Searching for Files
- Adding Shortcuts to My Drive
- Working with Drive Priority and Workspaces
- Changing Google Drive Settings
Collaborating in Google Drive
- Sharing a File or Folder
- Sharing a Link to a File or Folder
- Publishing to the Web
- Opening a Google Application
- Using the Menu and the Toolbar
- Using Help
- Creating a New File
- Renaming a File
- Emailing a File as an Attachment
- Downloading Files in Other Formats
- Opening a Microsoft Office File in a Google App
- Working with Versions
Google Sheets
- Understanding the Sheets Display Screen
- Creating Formulas
- Working with Functions
- Working with the Google Sheets Functions List
- Formatting Numbers
- Previewing and Printing a Sheet
- Creating a Chart
- Working with the Chart Editor Setup Options
- Working with the Chart Editor Customize Options
- Working with Pivot Tables
- Creating and Using Named Ranges
- Protecting Sheets and Ranges
Google Docs
- Understanding the Docs Display Screen
- Changing the View of a Document
- Inserting an Image
- Inserting Page Numbers
- Working with Styles
- Using the Document Outline
- Collaborating with Suggesting Mode
- Working with Comments
Google Slides
- Understanding the Slides Display Screen
- Changing the View of a Presentation
- Entering Text in a Slide
- Adding an Image to a Slide
- Adding, Deleting and Reordering Slides
- Applying a Theme
- Adding Transitions and Animations
- Delivering a Presentation
- Using Presenter View and Audience Tools
Google Forms
- Understanding the Forms Display Screen
- Creating a Form
- Adding Questions
- Sending a Form
- Linking to a Spreadsheet
- Viewing Responses
- Scheduling a Video Meeting from Google Calendar
- Joining a Video Meeting
- Understanding the Meet Display Screen
- Presenting Your Screen in a Meeting
- Managing Meetings
- Changing Audio and Video Settings
- Starting a Video Meeting from Gmail
- Starting a Video Meeting from Google Meet
