Autoplay
Autocomplete
Previous Lesson
Complete and Continue
Simple Spreadsheets
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
A Real-Life Excel Test from a Job Interview (28:58)
Tips for Passing the Excel Certification Exam (42:22)
Case Studies with Your Colleagues
Kharaam S. (39:49)
Akimi S. (38:10)
Kristen S. (55:52)
2021 Graduation Party (52:39)
Gerda Z.'s Dashboard in Excel (57:52)
Kay B.'s Spreadsheet Organization (81:22)
Guest Speakers
Bill Jelen a.k.a. Mr. Excel (48:33)
Maryfrances Porter and Alison Nagel West from Partnerships for Strategic Impact (59:11)
Asya Spears from Rose Data Studio (49:19)
Mynda Treacy from My Online Training Hub (44:23)
Teach online with
Bill Jelen a.k.a. Mr. Excel
Lesson content locked
If you're already enrolled,
you'll need to login
.
Enroll in Course to Unlock