Power Up Reports With Google

Power Up Reports With Google

Webinar archive


Webinar handouts

Tuesday, September 24, 2019, 1:00-2:00 Eastern/10:00-11:00 Pacific

Presenter: Lynn Hoffman, Director of Operations, Somerset County Library System of New Jersey

Google Sheets includes a variety of lesser-known tools that can help you power up your library’s reports, including conditional formatting and basic scripting. This webinar will cover strategies and approaches you can use to automate regular reporting and analytical tasks, such as scheduling updates to data used for periodic circulation tasks, and pulling data from emailed reports into a spreadsheet. Use your new knowledge to impress your colleagues with fancy, on-demand reports.

Lynn Hoffman has worn a wide variety of hats throughout her twenty-plus year public library career, but has found her niche in administration, implementing big ideas on the front lines at the assistant director level at several large public library systems in the Midwest. She is also a self-professed data nerd and wannabe coder, and loves finding ways to make it easy for her colleagues to gain new insights from the data we already collect. Lynn is currently Director of Operations at the Somerset County Library System of New Jersey and served on the Public Library Association’s Measurement, Evaluation and Assessment Committee.

Connection Information:

You do not need to register for this free webinar. It will be recorded and the archive will be available afterward at ripl.lrs.org/webinars.

Audio will be via VOIP. You can listen to the webinar with a USB headset or your computer speakers.

In advance of the meeting, please run through the connection test:


Access the meeting room online at https://enetlearning.adobeconnect.com/ripl/

Please enter your name as you log in as a guest.

Please consider logging in to the meeting 5-10 minutes in advance to make sure we can troubleshoot any technical issues, and not take time away from our session to do so.