Course Highlights
  • Learn how Google, Documents, Spreadsheets, and Presentations can help you with your individual productivity needs.
  • Cover spreadsheet fundamentals like entering and selecting data, how to format data, what the different data types are, and how to edit worksheets.
  • Organize and optimize your Google Spreadsheets by manipulating the screen display, sorting and filtering data, and pivot tables.
  • Follow the demonstrations on sharing, collaboration, and publishing documents, spreadsheets, and presentations
  • Review the best practices to implement when working in Google slides, how to create and import slides, slide layout options, slide navigation, save options, and slide themes.
  • Take a closer look at Google Documents formatting options by learning about advanced formatting and ways to customize a document.
  • Become more productive and efficient at document, spreadsheet, and presentation creations.
Curriculum

1 Topic
Orientation Video

21 Topics
Getting Started: Creating Documents
Getting Started: Opening & Uploading Existing Documents
Getting Started: Documet Interface Overview
Document Fundamentals: Type Justification
Document Fundamentals: Type Justification
Document Fundamentals: Cut | Copy | Paste Concepts
Document Fundamentals: Page Setup
Document Fundamentals: Saving Documents
Basic Formatting: Text Formatting
Basic Formatting: Font Formatting
Basic Formatting: Paragraph Formatting
Advanced Formatting: Using the Ruler
Advanced Formatting: Working with Tabs & Indents
Advanced Formatting: Working with Lists
Advanced Formatting: Working with Headers & Footers
Customizing Documents: Importing Images
Customizing Documents: Adding Hyperlinks
Customizing Documents: Working with Drawings
Customizing Documents: Working with Comments & Footers
Part 1 Quiz
Google Docs - Supplemental Materials

21 Topics
Tables: Inserting Tables
Tables: Customizing Table Properties
Tables: Inserting & Deleting Rows & Columns
Tables: Adjusting Row & Column Height
Proofing Documents: Spelling Checker
Proofing Documents: Find & Replace
Proofing Documents: Word Usage Tools
Proofing Documents: Translating a Document
Saving Time: Keyboard Navigation
Saving Time: AutoComplete | AutoCorrect
Document Navigation Techniques: Using Bookmarks
Document Navigation Techniques: Adding a Table of Contents
Document Distribution: Printing
Document Distribution: Downloading & Copying Documents
Document Distribution: Revision History
Document Distribution: Sharing & Collaboration
Document Distribution: Communicating with Collaborators
Document Distribution: Notification Settings
Document Distribution: Publishing Your Document
Part 2 Quiz
Google Docs - Supplemental Materials

21 Topics
Getting Started: Creating a Presentation
Getting Started: Uploading a Presentation
Getting Started: Presentation Interface Overview
Presentation Fundamentals: Best Practices
Presentation Fundamentals: Creating Slides
Presentation Fundamentals: Importing Slides
Presentation Fundamentals: Slide Layout Options
Presentation Fundamentals: Slide Navigation
Presentation Fundamentals: Slide Themes
Presentation Fundamentals: Savings
Formatting Text: Text Boxes
Formatting Text: Formatting Basics
Formatting Text: Lists & Bulleted Lists
Formatting Text: Working with Text Boxes
Drawing Options: Shapes
Drawing Options: Drawing Tools
Drawing Options: Cut / Copy / Paste Drawing Objects
Drawing Options: Grouping / Aligning Objects
Drawing Options: Defining Object Order
Part 1 Quiz
Google Slides - Supplemental Materials

19 Topics
Working with Images & Video: Uploading & Inserting an Image
Working with Images & Video: Inserting an Image Using a URL
Working with Images & Video: Slide Backgrounds
Working with Images & Video: Inserting a YouTube Video
Working with Tables: Inserting a Table
Working with Tables: Customizing Borders & Shading
Working with Tables: Adding Rows & Columns
Working with Tables: Adjusting Rows & Columns
Animating Slide Elements: Slide Transitions
Animating Slide Elements: Animating Text
Animating Slide Elements: Animating Shapes and Images
Collaboration & Distribution: Adding Speaker Notes
Collaboration & Distribution: Download Options
Collaboration & Distribution: Revision History
Collaboration & Distribution: Print Options
Collaboration & Distribution: Sharing
Collaboration & Distribution: Presenting the Presentation
Collaboration & Distribution: Publishing the Presentation
Google Slides - Supplemental Materials

12 Topics
Getting Started: Creating a New Spreadsheet
Getting Started: Opening Existing Spreadsheets
Getting Started: Spreadsheet Interface Overview
Spreadsheet Fundamentals: Entering & Selecting Data
Spreadsheet Fundamentals: Formatting Data
Spreadsheet Fundamentals: Data Types
Spreadsheet Fundamentals: Editing Worksheets
Part 1 Quiz
Beyond the Basics: Working with Formulas
Beyond the Basics: Working with Functions
Beyond the Basics: Conditional Formatting & Data Validation
Google Sheets - Supplemental Materials

17 Topics
Enhancing Spreadsheets: Inserting Images
Enhancing Spreadsheets: Working with Charts
Enhancing Spreadsheets: Creating Drawings
Enhancing Spreadsheets: Working with Forms
Enhancing Spreadsheets: Google Gadgets
Part 2 Quiz
Spreadsheet Organization & Optimization: Getting Organized
Spreadsheet Organization & Optimization: Manipulating the Screen Display
Spreadsheet Organization & Optimization: Sorting & Filtering Data
Spreadsheet Organization & Optimization: Pivot Tables
Spreadsheet Distribution: Print Options
Spreadsheet Distribution: Downloading & Copying Spreadsheets
Spreadsheet Distribution: Revision History
Spreadsheet Distribution: Sharing & Collaboration
Spreadsheet Distribution: Notification Rules
Spreadsheet Distribution: Publishing Spreadsheets
Google Sheets - Supplemental Materials

  Write a Review

Getting Started with Google Office: Docs, Sheets, Slides

Go to Paid Course