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.
Course Outline
Google Sheets
- format numbers and dates
- conditional formatting
- write formulas using functions like:
- IF and IFS
- VLOOKUP, INDEX and MATCH
- Concatenate and parse text
- 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
