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

  • Event: 2020 NICAR Conference
  • Speaker: TBA
  • Date/Time: Saturday, Mar. 7 at 9:00am
  • Location: Studio 1 - 2nd floor
  • Audio file: No audio file available.

Skill level: Beginner/intermediate

Google Sheets is more than just free spreadsheet software to organize and store data. This hands-on session will start with pivot tables and conditional formatting, and 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. Come with a laptop and leave with the knowledge of a Google Sheets power user.

Preregistration is required and seating is limited. You must bring your own laptop (no tablets) to this training and have a Google account.

Workshop prerequisites: You should be familiar with using spreadsheets and formulas.

Related Tipsheets

No tipsheets have yet been uploaded for this event.