Google Apps Intermediate: Sheets and Forms
Class Details
Length of class: three hours
Price per person: $119
Version covered:
Description
In this three-hour session, you will improve your Google Sheets skills learning to apply number and date formatting, conditional formatting, write sophisticated formulas, create charts and PivotTables, and view cell and sheet history. You will also learn how to build beautiful, intuitive web forms using Google Forms and store responses in a Google Sheet file.
Prerequisites
This class is ideally suited for people who have attended our Google Apps Beginning course or are comfortable in the common Google Apps, and want to create forms and manage form submissions.
Outline
Google Sheets
- format numbers and dates
- conditional formatting
- write formulas like:
- SUM and AVERAGE
- calculate percentage
- use absolute vs relative references
- concatenate and parse text
- IF for conditional logic
- VLOOKUP
- create charts
- PivotTables
- view cell edit history and sheet version history
Google Forms
- create forms
- add questions
- group questions into sections
- apply design themes
- send links to forms
- store responses in Google Sheets
- halt submissions
- view summary and detail reports
- create slideshow of response summary graphics
Upcoming Dates
There are no dates for this course currently on the schedule.