Log in

Use Spreadsheets like a Database: Tips and tricks for using Google Sheets

Sign up for our weekly newsletter!

When & Where
Date: 
Thu, February 18, 2016 - 4:00 PM to 6:00 PM
Location: 
D-Lab: Convening Room (356 Barrows Hall)
Description
Type: 
Workshop

This workshop will focus on how to quickly set up database-like structures in Google Sheets and then flexibly build various kinds of reports and displays on top of a sound data foundation. I come at this as a manager (of datavis and web teams) rather than as a stats person. So the goals are (a) fast but shallow assessment of flat datasets to see possibilities and (b) creating database-like structures within a spreadsheet that maximize flexibility for data reuse for various displays. 

Link: 
Workshop presentation
Keyword: 
Professional Development
Details
Training Host: 
D-Lab
D-lab Facilitator: 
Trinetta Chong
Format Detail: 
This will be a hands-on follow-along workshop where we'll take several example datasets, reformat them, and then make some simple tools to analyze those datasets.
Participant Technology Requirement: 
Laptops encouraged to follow along. If you've used Google Sheets even once, you're ready for this workshop.
Register