Select Events by Type

Filter Events

Filter By Zip Code

Google Apps: Sheets 1 & 2

Name Google Apps: Sheets 1 & 2
Date 1/28/2022
Time 12:00 PM - 03:00 PM

Google Sheets is an online spreadsheet app that is used directly in a web browser - no special software is required. Formulas as simple as adding two cells or as complex as completing sums with IF statements can be used to calculate, find, or count specific data.

Paired with Forms as the data collector, Sheets can sort, filter, or make data standout. Sheets can be used for attendance, filtering grades, creating schedules and much more!

Part 1: will start with a brief overview of Forms followed by a dive into Sheets where attendees will use simple filters as well as queries, complete simple and custom conditional formatting, and create and build basic to complex functions (aka formulas).

Part 2: will continue with using and tailoring templates, using more advanced functions with data, layering conditional formatting, and creating formulas with multiple functions. Where this hands-on workshop will focus on Sheets, some of the topics and components shown are transferable to Microsoft Excel.

Each part may be scheduled as separate workshops or presentations.

Sheet starter-kits will be given to all that attend.

Agencies may select targeted areas for requested in-person workshops.


  1. Attendees MUST have a Google account to use during the workshop.
  2. Attendees should have a basic understanding of spreadsheets including:
    1. how to create a basic Form (with Full name, checkbox, and multiple choice questions),
    2. how to allow others to fill out a Form online,
    3. how to create a new Google Sheet,
    4. difference between Rows and Columns,
    5. how to add a second sheet (use the plus at bottom, far left)

Those that have never used Sheets before are still welcome to attend and watch the magic.

An OTAN Certificate of Attendance will be awarded to those that have pre-registered and attend at least 75% of the scheduled time.
*****  -  *****  -  *****

This session may be requested, customized, and scheduled as a workshop or presentation by qualifying adult education agencies for their staff as targeted professional development

OTAN workshops are conducted as "hands-on” sessions, where participants are asked to provide their own devices and follow along with the trainer - questions are answered throughout. An OTAN presentation is more geared towards a "show and tell" where questions are answered during or after the presentation.

The desired outcome of every OTAN session is that participants will have a working understanding of the application or topics discussed and modeled.

For more information about this or other OTAN workshops and training options, contact

Location OTAN Open Workshop (OWo)

Zoom link and information sent after registration.

Trainer Melinda Holt


If you have an OTAN membership and wish to register for this course, enter your e–mail below.
If you do not have an OTAN membership, you will need to get an OTAN membership first. It is fast and free to Get an OTAN membership!