Loading Events

« All Events

  • This event has passed.

Google: Tips Series: Sheets 2

January 28, 2022 @ 12:00 pm - 3:00 pm PST

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 2 of this series will build upon part 1 (basics) and will cover 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.

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 additional information, or to register for the online training, use the following link: OTAN Online Training Registration .

Details

Date:
January 28, 2022
Time:
12:00 pm - 3:00 pm PST
Event Categories:
,
Translate »