Simple Spreadsheets
-
Welcome & Logistics (10:21)
-
Download the Materials
-
STEP 0: The Absolute Beginner's Guide to Spreadsheets (Lingo, sorting, filtering, freezing panes, etc.) (58:34)
-
STEP 1: MANAGE -- Datasets We Receive (Excel Tables; Raw vs. Clean Data; etc.) (35:47)
-
STEP 1: MANAGE -- Datasets We Create (Data Validation; Drop-Down Menus) (22:17)
-
STEP 1: MANAGE -- Datasets We Merge (Unique Lists; Lookups) (55:09)
-
STEP 2: CLEAN -- How Much Data We Have & Don't Have (Duplicates; Missing Data; Counts) (26:35)
-
STEP 2: CLEAN -- Pull Variables Apart (Text to Columns; Left, Mid, Right) (33:42)
-
STEP 2: CLEAN -- Push Variables Together (&; Concatenation) (22:20)
-
STEP 2: CLEAN -- Formatting (Numbers; Currency; Dates; Text) (56:44)
-
STEP 2: CLEAN -- Recoding (If, Nested If, Vlookup) (32:44)
-
STEP 2: Q&A (46:34)
-
STEP 3: TABULATE -- Summarize Numbers with Formulas (61:56)
-
STEP 3: TABULATE -- Summarize Categories with Formulas (48:46)
-
STEP 3: TABULATE -- Summarize Categories with Pivot Tables (67:23)
-
Case Study: Demographics (63:45)
-
Case Study: Deaths from Falls (52:50)
-
Case Study: Technical Assistance Log (80:37)
-
Bonus! Interactive Dashboards in Excel (11:43)
Bonus Lessons
Case Studies with Your Colleagues
Guest Speakers
