Beginner
Beginner
Google Forms and Sheets Masterclass
This comprehensive spreadsheet course covers everything you need to know about two of the most valuable tools in Google Workspace: Forms and Sheets. Students learn from Yahya Zakir Sait, a Google Certified Professional with experience giving in-person and online courses on the same subject.
Specific Google Forms lessons include:
- Creating a form and connecting it to Google Sheets
- Customizing forms with videos
- Using conditional logic
- Importing and exporting data
- Collaborating with other users
- Using INDEX & MATCH
- Using SUMIF, SUMIFS, COUNTIF
- Find data with VLOOKUP
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