Beginner
Beginner
Google Forms and Sheets Masterclass
Specific Google Forms lessons include:
- Creating a form and connecting it to Google Sheets
- Customizing forms with videos
- Using conditional logic
Specific Google Sheets lessons include:
- Importing and exporting data
- Collaborating with other users
- Using INDEX & MATCH
- Using SUMIF, SUMIFS, COUNTIF
- Find data with VLOOKUP
And many more!
By the end of this course, students will be able to easily create and customize Google forms, connect forms to Google Sheets, filter form responses, create pivot tables, transpose data, and demonstrate other valuable spreadsheet skills.
Curriculum
- 11 Sections
- 65 Lessons
- 0 Quizzes
- 4h Duration
Getting Started with the Google Environment
4 Lessons0 Quizzes
- About the Google Environment
- Creating a Google Account
- How to Work on Projects
- Course Introduction
Google Forms: The Basics
12 Lessons0 Quizzes
- Getting Started with Google Forms
- Understanding the Question Types
- Navigating a Google Form
- Understanding Question Types
- Reviewing the Live Form
- Viewing Responses from Google Forms
- Connecting the Form with Google Sheets
- How to Share a Google Form
- Project: Create and Connect a Google Form
- Updating the Form with a Theme
- Creating Custom Form Headers
- Adding Images and Videos to a Google Form
Conditional Logic in Google Forms
3 Lessons0 Quizzes
- Understanding Sections in a Form
- Creating and Using Conditional Logic
- Project: Conditional Logic in Google Forms
Google Forms as Quizzes
3 Lessons0 Quizzes
- How to Make a Quiz with Google Forms
- Quiz Answers in Google Forms
- Importing Questions from another Google Form
Configuring Google Forms
8 Lessons0 Quizzes
- Google Form Settings
- Fonts in Google Forms
- Creating a Prefilled Google Form
- Printing a Google Form
- Collaborating on a Google Form with Your Team
- Installing Add-Ons on Google Forms
- Enabling Notifications on Google Forms
- Triggering Automated Emails for Respondents
Google Sheets: The Basics
6 Lessons0 Quizzes
- Getting Started with Google Sheets
- Basics of Google Sheets
- Mail Merge for Reviewing Form Responses
- Entering Data
- Formatting Text, Dates & Numbers
- Conditional Formatting in Google Sheets
Working with Data in Google Sheets
4 Lessons0 Quizzes
- Sorting Data in Google Sheets
- Filtering Data in Google Sheets
- Collaborating Using Filtered Data
- Importing and Exporting Data
Forms and Functions in Google Sheets
9 Lessons0 Quizzes
- Formulas and Functions Overview
- Finding Data with VLOOKUP
- Transposing Data in Google Sheets
- Finding Data with HLOOKUP
- Using Index Match in Google Sheets
- Using SUMIF, SUMIFS, and COUNTIF
- Using SUM, AVERAGE, MIN, MAX, ROUNDUP, and ROUNDDOWN
- Query Basics in Google Sheets
- Pivot Tables in Google Sheets
Google Sheets: Forms and Formulas Projects
5 Lessons0 Quizzes
- Project: The COUNTIF Function
- Project: VLOOKUP for Matching Values
- Project: Organize Data on a Google Sheet
- Project: Pivot Table
- Project: Data Analysis
Google Sheets: Advanced Features
9 Lessons0 Quizzes
- Creating Charts and Graphs
- Charts and Graphs from Advanced Data Sets
- Linking a Chart within Google Workspace
- Collaboration within Google Sheets
- Comments and Notes
- Cell History on Google Sheets
- Protecting Sheets & Ranges
- Using Mail Merge on Google Sheets
- Project: Mail Merge on a Google Sheet
Course Conclusion
2 Lessons0 Quizzes
- Course Recap
- Course Completion
