VentureKite

1.2 - About the Google Environment

1.3 - Creating a Google Account

1.4 - How to Work on Projects

2.1 - Getting Started with Google Forms

2.2 - Basics of Google Forms

2.3 - Navigating a Google Form

2.4 - Understanding Question Types

2.5 - Reviewing the Live Form

2.6 - Viewing Responses from the Google Forms Dashboard

2.7 - Connecting the Form with a Google Sheet

2.8 - Sharing a Google Form

Project 1: Create a Form and Connect to Google Sheets

3.1 - Updating the Form with a Theme

3.2 - Creating Custom Form Headers

3.3 - Adding Images and Videos to a Google Form

4.1 - Understanding Sections in a Form

4.2 - Creating and Using Conditional Logic

Project 2: Create a Google Form using Conditional Logic

5.1 - Understanding and Creating a Quiz with Google Forms

5.2 - Answering the Quiz made using Google Forms

5.3 - Importing Questions from another Google Form

Sample Google Forms

6.1 - Understanding Google Form Settings

6.2 - Updating the Font on a Google Form

6.3 - Creating a Prefilled Google Form

6.4 - Printing a Google Form

6.5 - Collaborating on a Google Form with your Team

7.1 - Installing Add Ons on Google Forms

7.2 - Enabling the Form Notifications Add On

7.3 - Triggering Automated Emails to Respondents

8.1 - Getting Started with Google Sheets

8.2 - Basics of Google Sheets

8.3 - Reviewing Form Responses using Mail Merge

8.4 - Entering Data into a Google Sheet

8.5 - Formatting Text, Dates & Numbers + Custom Formats

8.6 - Using conditional formatting to highlight data

8.7 - Sorting Data

8.8 - Filtering Data

8.9 - Collaborating using Filtered Data

8.10 - Importing and exporting data

9.1 - Overview of Formula _ Functions

9.2 - Finding data with VLOOKUP

9.3 - Transposing your Data

9.4 - Finding data with HLOOKUP

9.5 - Using Index _ Match

9.6 - Using SUMIF, SUMIFS, COUNTIF

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

9.9 - Using Pivot Tables

Project 3: The COUNTIF in Google Sheets

Project 4: VLOOKUP in Google Sheets

Project 5: Organize Data on a Google Sheet

Project 6: Pivot Tables

Project 7: Analyze Data using a Google Sheet