Learn basic and advanced skills in Google Sheets and how to apply them to your organizing! This free, hybrid event series will include snacks and time to mingle with comrades.

We'll watch short video tutorials together, pausing for questions and practice activities that are specialized to DSA organizing. Then, participants will be given a Google Sheets file to transform using the skills they've learned and have the option to present it at the end of the series.

Before RSVPing, please review the requirements and agenda below. In-person space is limited, so RSVP soon!

Requirements:

• Have a basic understanding of computers and web browsers
• Bring their own laptop and charger to the event*
• Have a Google account (Gmail address)

*Don't have a laptop? We recommend attending a course at the Boston Public Library. Find upcoming BPL events here.

Schedule:

This series will take place on Wednesdays in February at 6:00 PM - 7:30 PM. Be sure to RSVP for all four sessions!

• February 4
• February 11
• February 18
• February 25

View All

Introductory Topics:

• Managing data (importing, sorting, filters)
• Formatting (cell types, freezing, sheet managament)
• Basic formulas, functions, and charts (=SUM, =AVERAGE, data types, named ranges)
• Sharing and collaboration (roles, permissions, versions, downloading)

Advanced Topics:

• Advanced formatting (themes, conditional formatting)
• Advanced formulas and functions (relative/absolute references, =IF/IFS, data validation)
• Analyzing and reporting (charts, pivot tables, integration, web publishing, macros)
• Populating data using Google Forms