Google Sheets & Forms Essentials

Name: Google Sheets & Forms Essentials
Rating: 4.4 (366 reviews)

Learn Google Sheets and Forms to organize data, collect responses, and build practical workflows.

Created byJoe Buchmann

Last updated 8/2026

English

What you'll learn

Organize and format data clearly in Google Sheets
Use formulas, functions, sorting, and filtering to work with spreadsheet data
Create charts that make spreadsheet information easier to understand
Build Google Forms using question types, sections, settings, and validation
Collect form responses and connect them to Google Sheets
Use Sheets and Forms together to create practical data collection workflows

Course content

4 sections • 16 lectures • 1h 46m total length

Course Welcome2:59
Welcome to Google Sheets & Forms Essentials. In this introduction, you’ll get a quick overview of what the course covers, how Google Sheets and Google Forms work together, and why Google Drive is an important foundation for organizing, sharing, and managing your files.

Module Introduction: Google Sheets Essentials1:19
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.
Lesson 01: Getting Started with Google Sheets6:31
Learn how spreadsheets are organized, navigate the Google Sheets interface, and understand the core structure of rows, columns, cells, and sheets.
Lesson 02: Working with Data and the Grid13:47
Explore how to enter, organize, and format data efficiently using tools like autofill, dropdowns, resizing, freezing, grouping, and layout controls.
Lesson 03: Creating Formulas and Functions10:53
Learn how to build formulas, use common functions, work with cell references, and create calculations that automatically update as your data changes.
Lesson 04: Sorting, Filtering, and Organizing Data14:04
Discover how to sort and filter information, use collaborative filter views, apply conditional formatting, and organize larger spreadsheets more effectively.
Lesson 05: Visualizing Data with Charts9:28
Learn how to create and customize charts, organize visual layouts, and present spreadsheet data in a clean, clear, and professional way.
Module Review: Google Sheets Essentials
Module Completion Video1:12
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.

Module Introduction: Google Forms Essentials1:40
A quick overview of what you can expect in the Google Forms Essentials module, including the core skills we’ll cover and how the lessons are structured.
Lesson 01: Building the Foundation7:09
Learn the core fundamentals of Google Forms, including the editor interface, basic question types, required fields, and how to organize a clean, user-friendly form structure.
Lesson 02: Advanced Inputs and Design7:56
Explore advanced question types, visual media, sections, and theme customization to create forms that feel more polished, engaging, and professional.
Lesson 03: Logic and Flow8:13
Learn how to use branching logic, data validation, and section navigation to create smarter forms that adapt to user responses and collect cleaner data.
Lesson 04: Settings and Distribution11:19
Configure quiz settings, response controls, presentation options, publishing, and distribution methods so your form is ready to launch.
Lesson 05: Analyzing the Results6:33
Learn how to review responses, analyze form data, connect Google Forms to Google Sheets, and manage the tools and workflows that keep your forms running smoothly.
Module Review: Google Forms Essentials
Module Completion Video1:32
Wrap up the Google Forms Essentials module with a final review of the key concepts covered and guidance on how to apply Forms in real-world workflows and data collection systems.

Requirements

No previous Google Sheets or Google Forms experience is required
A free Google account is recommended so you can follow along
Basic familiarity with Google Drive is helpful, but not required

Description

Google Sheets & Forms Essentials is designed to help you use two of Google Workspace’s most practical tools with more confidence and clarity.

In this course, you’ll learn how to work with Google Sheets to organize information, format data, use formulas and functions, sort and filter records, and create charts that help make your data easier to understand.

You’ll also learn how to build Google Forms for collecting information in a clean, structured way. We’ll cover form setup, question types, design choices, settings, validation, sections, response collection, and how to connect form responses directly to Google Sheets.

The real power comes from using these tools together. Forms helps you collect information. Sheets helps you organize, review, analyze, and use that information.

This course is built for beginners and everyday users who want practical skills without getting buried in unnecessary complexity. We’ll focus on realistic workflows you can use for surveys, feedback, sign-ups, tracking, reports, requests, and other common projects.

By the end of the course, you’ll understand how Sheets and Forms work on their own, how they connect together, and how they fit into the larger Google Workspace system.

Whether you’re organizing personal information, managing a small project, supporting a team, or just trying to make spreadsheets and forms feel less intimidating, this course will give you a practical foundation you can build on.

Who this course is for:

Beginners who want to learn Google Sheets and Google Forms from the ground up
Students, teachers, and professionals who need to organize information or collect responses
Small business owners, team members, and everyday users who want practical spreadsheet and form skills
Anyone who wants to use Sheets and Forms together for surveys, sign-ups, tracking, feedback, or simple workflows

Google Sheets & Forms Essentials

What you'll learn

Explore related topics

Course content

Course Introduction1 lecture • 3min

Module 01: Google Sheets Essentials7 lectures • 57min

Module 02: Google Forms Essentials7 lectures • 44min

Course Completion1 lecture • 2min

Requirements

Description

Who this course is for: