Step 0. The Absolute Beginner's Guide to Spreadsheets
-
Welcome & Logistics (6:25)
-
Download the Materials
-
1. Versions (5:41)
-
2. Lingo (10:48)
-
3. Sheets (14:13)
-
4. Re-Sizing Columns/Rows (6:15)
-
5. Inserting/Deleting Cells (3:34)
-
6. Freezing Panes (4:31)
-
7. Sorting (10:50)
-
8. Filtering (3:03)
-
9. Formatting Cells (6:46)
-
10. Styles (2:38)
-
11. Borders & Gridlines (2:27)
-
12. Pictures (3:47)
-
13. Icons & Symbols (9:35)
-
14. Hyperlinks (3:21)
-
15. Auto-Fill (11:51)
-
16. Formulas & Functions (3:58)
-
17. Ultimate Editing Control (3:12)
-
18. Keyboard Shortcuts (4:49)
-
19. Paste Special (9:13)
-
20. Format Painter (2:34)
Step 1. Data Management: Datasets We Receive
2024 Version of Course (Taught Live in March 2024)
-
Download the Materials
-
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
Next Steps
