Mastering Google Sheets: Web scraping, running scripts and other tricks (Friday) **pre-registered attendees only

  • Event: 2019 IRE Conference
  • Speaker: Frank Bi of Vox Media
  • Date/Time: Friday, Jun. 14 at 2:30pm
  • Location: Clear Lake
  • Audio file: No audio file available.

Google Sheets is more than just free spreadsheet software to organize and store data. In this hands-on session will start with pivot tables and conditional formatting but through examples, we'll also learn how to scrape data in seconds without code, automate menial tasks with macros, write custom spreadsheet formulas as well as how to send emails, geocode addresses, translate text and more – all through the power of Google Sheets. 

Preregistration is required and seating is limited. Attendees must bring a laptop (no tablets) and charger to the training.

Workshop prerequisites: You should be familiar with using spreadsheets and formulas and have a Google account.

Speaker Bios

  • Frank Bi is a senior storytelling engineer at Vox Media in New York City where he works on innovative storytelling projects for the web. He also teaches data literacy and visualization at Fordham University and is a Google News Initiative trainer, teaching journalists at newsrooms and conferences across the country on utilizing free journalism tools. Frank is the president of the Asian American Journalists Association's New York chapter.

Related Tipsheets

No tipsheets have yet been uploaded for this event.