Special Discount

Use the code FEBRUARY in your cart for 30% off this course. Limited time only!

  • 00 Days
  • 00 Hours
  • 00 Minutes
  • 00 Seconds

Course curriculum

    1. 1.1 About the Course and Instructor

      FREE PREVIEW
    2. 1.2 - About the Google Environment

    3. 1.3 - Creating a Google Account

    4. 1.4 - How to Work on Projects

    1. 2.1 - Getting Started with Google Forms

    2. 2.2 - Basics of Google Forms

    3. 2.3 - Navigating a Google Form

    4. 2.4 - Understanding Question Types

    5. 2.5 - Reviewing the Live Form

    6. 2.6 - Viewing Responses from the Google Forms Dashboard

    7. 2.7 - Connecting the Form with a Google Sheet

    8. 2.8 - Sharing a Google Form

    9. Project 1: Create a Form and Connect to Google Sheets

    1. 3.1 - Updating the Form with a Theme

    2. 3.2 - Creating Custom Form Headers

    3. 3.3 - Adding Images and Videos to a Google Form

    4. 4.1 - Understanding Sections in a Form

    5. 4.2 - Creating and Using Conditional Logic

    6. Project 2: Create a Google Form using Conditional Logic

    7. 5.1 - Understanding and Creating a Quiz with Google Forms

    8. 5.2 - Answering the Quiz made using Google Forms

    9. 5.3 - Importing Questions from another Google Form

    10. Sample Google Forms

    1. 6.1 - Understanding Google Form Settings

    2. 6.2 - Updating the Font on a Google Form

    3. 6.3 - Creating a Prefilled Google Form

    4. 6.4 - Printing a Google Form

    5. 6.5 - Collaborating on a Google Form with your Team

    6. 7.1 - Installing Add Ons on Google Forms

    7. 7.2 - Enabling the Form Notifications Add On

    8. 7.3 - Triggering Automated Emails to Respondents

    1. 8.1 - Getting Started with Google Sheets

    2. 8.2 - Basics of Google Sheets

    3. 8.3 - Reviewing Form Responses using Mail Merge

    4. 8.4 - Entering Data into a Google Sheet

    5. 8.5 - Formatting Text, Dates & Numbers + Custom Formats

    6. 8.6 - Using conditional formatting to highlight data

    7. 8.7 - Sorting Data

    8. 8.8 - Filtering Data

    9. 8.9 - Collaborating using Filtered Data

    10. 8.10 - Importing and exporting data

    1. 9.1 - Overview of Formula _ Functions

    2. 9.2 - Finding data with VLOOKUP

    3. 9.3 - Transposing your Data

    4. 9.4 - Finding data with HLOOKUP

    5. 9.5 - Using Index _ Match

    6. 9.6 - Using SUMIF, SUMIFS, COUNTIF

    7. 9.7 - Using SUM, AVERAGE, MIN, MAX, ROUNDUP, ROUNDDOWN

    8. 9.8 - Query Basics

      FREE PREVIEW
    9. 9.9 - Using Pivot Tables

    10. Project 3: The COUNTIF in Google Sheets

    11. Project 4: VLOOKUP in Google Sheets

    12. Project 5: Organize Data on a Google Sheet

    13. Project 6: Pivot Tables

    14. Project 7: Analyze Data using a Google Sheet

About this course

  • $99.00
  • 66 lessons
  • 4.5 hours of video content

Video

Discover your potential, starting today