Google Workspace Essentials

Welcome to Google Drive Essentials.

This brief introduction gives you an overview of what to expect and sets the stage for mastering Google Drive with confidence.

Learn what Google Drive is, how to navigate its main features, and where everything lives.

We’ll explore the Drive interface, review key settings and preferences, and clarify the difference between My Drive, Shared with Me, and Shared Drives so you can move through Drive with confidence.

Discover how to upload, organize, and manage your files in Google Drive.

You’ll create new folders, color-code and arrange them, move and rename files, and master search filters so you can always find what you need quickly and easily.

Learn how to share files and folders, choose the right permission level, and collaborate in real time.

We’ll walk through sharing links, adjusting access settings, restricting downloads or copies, and transferring ownership so you stay in full control while working with others.

Take your Drive skills to the next level.

You’ll explore Workspaces for project organization, integration with tools like Docs, Sheets, and Gmail, syncing across devices, offline access, and a few Gemini AI features that boost productivity.

Celebrate completing Google Drive Essentials.

This short wrap-up reinforces what you’ve accomplished and encourages you to keep using your new Drive skills with confidence.

A quick overview of what you can expect in the Google Docs Essentials module, including the core skills we'll cover and how the lessons are structured.

Learn the fundamentals of Google Docs, including how to access the app, navigate the interface, and adjust key settings. By the end of this lesson, you’ll know how to set up and save your first document with confidence.

Discover how to make your documents look professional and polished. You’ll explore tools for formatting text, adjusting spacing, working with lists, inserting visuals, and customizing styles to create clean, readable layouts.

Master the collaborative power of Google Docs. This lesson covers sharing settings, permissions, comments, and suggestions. Plus how to manage version history and communicate effectively within shared documents.

Streamline your workflow with reusable templates, smart chips, and building blocks. You’ll also learn how to find and manage add-ons that enhance Docs’ capabilities and connect it with other Google Workspace tools.

Take Google Docs to the next level with advanced tools like Gemini AI, Voice Typing, and Pageless mode. You’ll also learn about document tabs, accessibility features, and simple automation options to personalize your workflow.

You’ve finished Google Docs Essentials! This closing video celebrates your progress, encourages continued learning across Google Workspace, and shares how you can apply your new skills in real-world workflows.

A quick overview of what you can expect in the Google Docs Essentials module, including the core skills we'll cover and how the lessons are structured.

Learn how to set up the foundation of your presentation by navigating the Slides interface, choosing the right theme and aspect ratio, and using layouts and the Theme builder to create a consistent structure.

Learn how to add and format text, insert and adjust images, and use shapes, connectors, and media to build clear, engaging slides that communicate your message effectively.

Learn how to turn raw information into clear visuals by creating and formatting tables, diagrams, and charts, including how to link and update data from Google Sheets.

Learn how to refine your slides with alignment, spacing, and layering, and add simple transitions and animations to create a polished and professional presentation.

Learn how to move from editing to presenting by using Presenter View, managing notes and controls, and preparing your presentation for sharing or export.

A warm thank-you, a quick skill recap, and encouragement to keep going in the Google Workspace Essentials program.

Get an overview of what Google Sheets is, how spreadsheets are structured, and how this module will help you build practical, real-world spreadsheet skills from the ground up.

Learn how spreadsheets are organized, navigate the Google Sheets interface, and understand the core structure of rows, columns, cells, and sheets.

Explore how to enter, organize, and format data efficiently using tools like autofill, dropdowns, resizing, freezing, grouping, and layout controls.

Learn how to build formulas, use common functions, work with cell references, and create calculations that automatically update as your data changes.

Discover how to sort and filter information, use collaborative filter views, apply conditional formatting, and organize larger spreadsheets more effectively.

Learn how to create and customize charts, organize visual layouts, and present spreadsheet data in a clean, clear, and professional way.

Wrap up the Google Sheets Essentials module, review the progress you’ve made, and prepare to continue building your Google Workspace skills in the next module.

A short intro to Google Forms from Joe Buchmann.

Google Forms is an easy to use tool for creating web forms, surveys, or online tests. Anyone can create a web form and tie it to a spreadsheet, without having to know any programming. 

As will other Google apps, you can also collaborate with multiple people on a form at the same time.

Here are a few things you can do with Google Forms:

• Manage event registrations
• Create an opinion poll
• Collect email addresses for a newsletter
• Create a pop quiz

In this lesson we'll talk about how to create a form and start setting it up.

We'll cover the following items:

• Creating a new form
• Adding a description
• Form settings
• Color and themes

By the end of this lesson you will know how to start a new form, and get it set up how you want.

Now that we can set up a form, we need to add some questions. 

In this lesson we'll cover:

• Adding titles
• Adding images and videos
• Changing the order of elements
• Adding new questions
• Types of questions

By the end of this lesson you will have an understanding of the various types of questions available in Forms, as well as how to use them in your form.

With Google Forms, you can make sure that respondents fill out answers according to rules that you set. For example, you can tell Google Forms to accept only email addresses in a short answer question

In this lesson we'll cover the following validation topics:

• Validation settings
• Text validation
• Checkbox validation

By the end of this lesson you will understand how validation works, as well as be able to add questions to your form to be validated.

You can divide your form into sections to control how respondents interact with the form. This allows you to do things such as send users to different sections based on their answers. For example, you can send users who answer "Yes" to a question to page three of your form while sending users who answer "No" to page four.

In this lesson we'll see how to add sections and control responses.

There are a few ways to send your form to people to start filling it out. In this lesson we'll take a look at those, as well as how to collect responses.

We'll cover the following items:

• Ways to share the form
• Pre-populating form answers
• The responses tab
• Spreadsheet responses
• Pausing responses
• Response options

By the end of this lesson you will understand where responses go, how to view them, and how to control where they go.

In this lesson we'll take a look at how to install and use add-ons. We'll also learn how to use one of my favorite add-ons, Form Publisher.

Google forms allows you to let people upload files when responding to your form. We'll see how to do that in this video.

This video is also available on YouTube: https://youtu.be/FGhvycPp0_o

In this closing video, Joe offers a warm thank-you for joining the course, summarizes the key skills you've built across the modules, and shares how you can stay connected as new lessons and updates are released.