| Price per person: | $119 |
| Length of class: | three hours |
| Version covered: | |
| Delivery format: | live over Zoom |
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.
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.
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