Do you collect data using Google Forms & Google Sheets? Are you frustrated by having to edit the data to make it usable, and make it look good? If so, join this session to learn how to filter, sort, and validate data, change upper and lower cases, combine and break data apart, and automate it all! The session is designed for users that already have a working knowledge of Forms and Sheets, and are ready to take the next step in wrangling data.
Demo Google Sheet
Here’s the same spreadsheet I’m using for the session – feel free to make a copy, and tag along, or follow the video step by step below when it’s available (after the session).
- Demo Google Sheet (Google Sheets)
This is the outline I will follow, more or less.
- Session Outline (Google Doc)