Course Objective

In this course we will talk about Drive, Docs, Slides, Forms, Drawing and Sheets. We selected this kind of courses not only because we use it in our day-to-day work, but also because we think the future of teamwork and collaboration in general will be with this kind of tools.

What is G Suite - Google Office Tools

G Suite is a brand of cloud computing, productivity and collaboration tools, software and products developed by Google. G Suite comprises Gmail, Hangouts and Calendar for communication; Drive for storage; Docs, Sheets, Slides, Forms, Drawing and Sites for collaboration. It also includes the digital interactive whiteboard Jamboard and the app development platform App Maker.

 

Google Drive

Google Drive is a file storage and synchronization service developed by Google. Google Drive allows users to store files on their servers, synchronize files across devices, and share files. Google Drive encompasses Google Docs, Sheets, and Slides, an office suite that permits collaborative editing of documents, spreadsheets, presentations, drawings, forms, and more. Files created and edited through the office suite are saved in Google Drive.

Users can change privacy settings for individual files and folders, including enabling sharing with other users or making content public. On the website, users can search for an image by describing its visuals, and use natural language to find specific files, such as "find my budget spreadsheet from last December".

As of March 2017, Google Drive has 800 million active users. As of May 2017, there are over two trillion files stored on the service.

 

Google Docs

Google Docs is a word processor included as part of a free, web-based software office suite offered by Google within its Google Drive service. The application allows users to create and edit files online while collaborating with other users in real-time. Edits are tracked by user with a revision history presenting changes. An editor's position is highlighted with an editor-specific color and cursor. A permissions system regulates what users can do. Updates have introduced features using machine learning, including "Explore", offering search results based on the contents of a document, and "Action items", allowing users to assign tasks to other users.

 

Google Sheets

Google Sheets is a spreadsheet program and is compatible with Microsoft Excel file formats. The app allows users to create and edit files online while collaborating with other users in real-time. Edits are tracked by user with a revision history presenting changes. An editor's position is highlighted with an editor-specific color and cursor and a permissions system regulates what users can do. Updates have introduced features using machine learning, including "Explore", offering answers based on natural language questions in a spreadsheet.

 

Google Forms

Google Forms is a tool that allows collecting information from users via a personalized survey or quiz. The information is then collected and automatically connected to a spreadsheet. The spreadsheet is populated with the survey and quiz responses. The Forms service has undergone several updates over the years. New features include, but are not limited to, menu search, shuffle of questions for randomized order, limiting responses to once per person, shorter URLs, custom themes, automatically generating answer suggestions when creating forms, and an "Upload file" option for users answering questions that require them to share content or files from their computer or Google Drive. The upload feature is only available through G Suite. In October 2014, Google introduced add-ons for Google Forms, that enable third-party developers to make new tools for more features in surveys.

In July 2017, Google updated Forms to add several new features. "Intelligent response validation" is capable of detecting text input in form fields to identify what is written and ask the user to correct the information if wrongly input. A new checkbox grid enables multi-option answers in a table. In Settings, users can make changes that affect all new forms, such as always collecting email addresses.

 

Google Slides

Google Slides is a presentation program and is compatible with Microsoft PowerPoint file formats.

Slides allows users to create and edit presentations online while collaborating with other users in real-time. Edits are tracked by user with a revision history that tracks changes to the presentation. Each editor's position is highlighted with an editor-specific color/cursor and the system regulates what users can do through varying degrees of permissions. Updates have introduced features using machine learning, including "Explore", offering suggested layouts and images for presentations, and "Action items", allowing users to assign tasks to other users.

 

Google Drawing

Google Drawings is a free, web-based diagramming software developed by Google. It allows users to collaborate and work together in real time to create flowcharts, organisational charts, website wireframes, mind maps, concept maps, and other types of diagrams. Google Drawings is also available as a Chrome app that works offline, available from the Chrome Web Store. Google Drawings is hosted within Google Drive and all files created with the application are by default saved to Google Drive.

Google Drawings allows multiple users to open and edit drawings simultaneously in real time. Users can insert images from the local hard drive or from the Web, as well as shapes, arrows, scribbles and text. Google Drawings has set of flow-chart symbols and other shapes that can be dragged and dropped into place. Users can move, resize and rotate objects, and use polylines and line connectors. It also allows for the editing of images, including cropping, applying masks and adding borders. Other features include laying out drawings precisely with alignment guides, snapping to grid, and auto-distribution. Drawings can be inserted into other Google documents, spreadsheets, or presentations. They can also be published online as images or downloaded in standard formats such as JPEG, SVG, PNG, or PDF

Topics

Google Drive

  1. Introduction

  2. Create, Upload, Download & Convert

  3. Sharing

  4. Search, Details & Settings

  5. Team Drive

 

Google Docs

  1. Create and Format

  2. Indents Margins

  3. Columns

  4. Page Number Headers Footers

  5. Line Spacing

  6. Bookmarks and Links

  7. Table of Contents

  8. Embed a Spreadsheet

  9. Add Comments

  10. Insert Special Characters

  11. Add-ons

 

Google Sheets - Basic Tools

  1. Create

  2. Format

  3. Use Cell References

  4. Formulas

  5. Group Rows and Columns

  6. Comment vs Note

  7. Sort and Filter

  8. Different Types of Sum

  9. Scatter Charts

  10. Create Drop Down Lists & Check Boxes

  11. Today & Now

 

Google Sheets - Advance Tools

  1. Protect Cells

  2. Dynamic Drop Downs from a Range of Data

  3. Create an Interactive Task List

  4. Ways to Find the Top or Bottom Values

  5. Highlight Duplicate Data in a Column or Row

  6. Insert Special Characters

  7. Remove Duplicate Data

  8. Advance Count Cells

  9. Conditional Formatting Based on Another Cell

  10. Macro Tutorial with Examples

  11. Compare two Lists for Matches or Differences

  12. Define and Use Named Ranges

  13. Show Formulas

  14. Concatenate

  15. Use Sparklines

  16. Draw a Straight Line

  17. Pivot Tables

 

Google Forms

  1. Create

  2. Make a Quiz

  3. Add-ons

  4. Create a Workflow

 

Google Slides

  1. Create & Basic Tools

  2. Add-ons

 

Google Drawing

  1. Create a Draw and a Poster

  2. Make a Flyer

  3. Example of an Illustration