Google Workspace Essentials

Course Overview

Course Content

• Introduction to Drive

  Accessing Drive
  What is Drive?
  Exploring the User Interface
  Getting Help
  Creating a Folder
  Moving Files into a Folder
  Deleting Files from Drive
  

• Introduction to Google Docs

  What is Docs?
  Create a New Document
  Saving in Docs
  Naming a Document
  Uploading an Existing Word Document into Docs
  Downloading your Document as a .docx
  

• Editing and Formatting

  Selecting Techniques
  Formatting Text
  Formatting Paragraphs
  Borders and Shading
  Clear Formatting
  Cut, Copy and Paste
  Find and Replace
  

• Introduction to Google Sheets

  What is Sheets?

• Understanding Workbooks and Worksheets

  Creating a new workbook
  Saving in Sheets
  Opening an existing workbook
  Navigating
  Selecting and entering data
  Saving a workbook in Sheets as a .xlsx file
  Upload an existing Excel spreadsheet into Sheets
  Downloading your worksheet

• Entering and Editing Data

  Entering text and numbers
  Entering numbers as text
  Inputting dates and times
  Editing the contents of a cell
  Manipulating data
  Undo and redo buttons
  

• Selecting Data

  Select a range of cells
  Select more than one range
  Select an entire column and row
  Highlight the entire worksheet

• Cell Formatting in Sheets

  Cell Formats options
  Understanding the General Format
  Date and Time Formats
  Currency and Accounting Formats
  Text Formats
  Clearing and Resetting Formats
  

• AutoFill

  Using Autofill to automate data entry
  Text AutoFill
  Number Autofill
  Date AutoFill
  Custom Lists
  Flash Fill

• Introduction to Google Slides

  What is Slides?
  

• Creating a Presentation

  Creating a presentation
  Adding slides to a presentation
  Working with themes
  Entering and editing text
  Navigating through a presentation
  Presentation views
  Saving in Slides
  Downloading your Google Slides presentation as a .pptx file
  Uploading a PowerPoint presentation into Slides
  

• Formatting Text on Slides

  Character formats
  Paragraph formats
  Formatting text placeholders

• Slide Transitions

  Adding Transitions to slides
  Modifying and Removing Transitions

• Animations

  Adding Animation
  Modifying or Removing Animations

• Running the Slide Show

  Starting the Slide Show presentation
  Slide Show presentation options