Beautiful Data with Google Sheets | Google Summit #ITIP2017

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.

Slides

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).

Outline

This is the outline I will follow, more or less.

Video Recording