Select Events by Type

Filter Events

Filter By Zip Code

Google: Tips Series: Sheets

Name Google: Tips Series: Sheets
Date 12/9/2021
Time 9:30 AM - 11:30 AM
Description

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!

This hands-on workshop 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).

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

Prerequisites:

  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 support@otan.us

Location OTAN Online Workshop
Address

Zoom link and information sent after registration.

Trainer Melinda Holt

Registration

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!