Spreadsheet Basics For Everyone
The basics that everyone should know about using spreadsheets, including Google Sheets, Microsoft Excel, and Apple Numbers. We cover how spreadsheets are structured, how to use formulas, sorting and filtering rows, a small bit about pivot tables. Rather than speak in abstractions, we dive into a specific data set and work our way through it.
-- Contents --
00:00 - Overview
03:24 - Overview: Formulas
03:58 - Overview: IDEs
06:59 - Overview: Spreadsheets As Databases
08:44 - Overview: Data Munging
11:46 - Raw Data
13:54 - Import Into Spreadsheet
16:55 - A Sheet For An Entity
17:40 - Sorting Rows
18:28 - Simple Statistics
19:50 - Smell Test
21:17 - The Meaning Of The Data
23:54 - Assumptions
27:32 - Imposing Criteria
30:48 - Filtering
37:45 - Further Exploration
40:44 - Marker
