Google: Tips Series: Sheets 2

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.