Intro to Spreadsheets (Google Sheets)
SAT Score Range
•
3 sessions
•
SS
RT
NJ
+14
This series ended on December 30, 2022. All 1:1 and group chats related to this series are disabled 7 days after the last session.
About
Spreadsheets are a handy tool for managing any small dataset, say your budget, or how your Wordle scores compare against your friends'. Spreadsheets can dramatically enhance your organization, so it's best to learn about them as soon as you can!
In this series, we will start from the very beginning and work our way towards the more advanced functionality within Google Sheets.
Tutored by
Schedule
✋ ATTENDANCE POLICY
You are free to attend/skip whichever sessions you want. Note: There will be no slides or recordings for this course.
SESSION 1
26
Dec
SESSION 1
Orientation
Orientation
Mon 5:00 PM - 5:50 PM UTCDec 26, 5:00 PM - 5:50 PM UTC
Intro to Google Sheets. This 12/26 session is specifically for those who have *never* used spreadsheets before. If you have used it, consider starting from the 12/27 session instead.
We will cover the basics:
1. Cells
2. Adding/deleting rows/columns
3. Data types
4. Formulas, including references
5. Basic functions: SUM, COUNT, CONCAT
6. Wrapping, conditional formatting
SESSION 2
28
Dec
SESSION 2
Enrichment
Enrichment
Wed 5:00 PM - 5:50 PM UTCDec 28, 5:00 PM - 5:50 PM UTC
Subject to change based on the pace of the class:
We will cover how to download data from the web into a Google Sheet and play around with what we find.
SESSION 3
30
Dec
SESSION 3
Enrichment
Enrichment
Fri 5:00 PM - 5:50 PM UTCDec 30, 5:00 PM - 5:50 PM UTC
Final class of the series. Subject to change based on the pace of the class:
We will cover charts, pivot tables, filters, filter views, and Apps Script.