Mastering Google Sheets: Web scraping, running scripts and other tricks **pre-registered attendees only
Skill level: Beginner
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. Come with a laptop and leave with the knowledge of a Google Sheets power user.
Preregistration is required and seating is limited. Attendees must bring a laptop and charger (no tablets) to this training.
Workshop prerequisites: You should be familiar with using spreadsheets and formulas.
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.
No tipsheets have yet been uploaded for this event.