Google Workspace Basics: Sheets, Docs, Slides, Forms, and Meet Tutorial

Overview

Save Big on Coursera Plus. 7,000+ courses at $160 off. Limited Time Only!

Grab it

Dive into a comprehensive tutorial on Google Workspace basics, covering essential productivity apps like Sheets, Docs, Slides, Forms, and Meet. Learn to create and manage files, input data, use formulas and functions, format documents, design presentations, build forms, and conduct online meetings. Master the interfaces, explore key features, and understand collaboration tools across these applications. Ideal for users transitioning from Microsoft Office or seeking to enhance their Google Workspace skills, this 3-hour 18-minute guide provides a thorough overview of Google's powerful suite of productivity tools.

Syllabus

Start
Introduction
Introduction to Google Sheets
Google Sheets Interface
Inputting Data
Formulas
Functions
Using the Google Sheets Functions List
Formatting Numbers
Previewing and Printing Sheets
Charts
Chart Editor Setup Options
Chart Editor Customize Options
Pivot Tables
Named Ranges
Protecting Sheets and Ranges
Google Sheets Recap
Introduction to Google Docs
Google Docs Interface
Changing Document Views
Inserting Images
Page Numbers
Styles
Document Outlines
Collaboration and Suggesting Mode
Comments
Google Docs Recap
Introduction to Google Slides
Google Slides Interface
Entering Text
Changing Presentation Views
Adding Images
Adding Slides
Deleting Slides
Reordering Slides
Themes
Transitions
Animations
Presenting with Speaker Notes
Presenter View and Audience Tools
Google Slides Recap
Introduction to Google Forms
Google Forms Interface
Creating Forms
Adding Questions and Sections
Previewing Forms and Applying Themes
Sending and Filling Out Forms
Viewing Responses
Linking Forms to Spreadsheets
Google Forms Recap
Introduction to Google Meet
Scheduling Meetings
Joining and Participating in Meetings
Presenting Screens
Messaging and Leaving Meetings
Managing Meetings
Audio and Video Settings
Starting Meetings from Gmail and Meet
Google Meet Recap
Conclusion