Autoplay
Autocomplete
Previous Lesson
Complete and Continue
Simple Spreadsheets
Simple Spreadsheets - Updated for 2022!
START HERE --> 2 Important Logistical Details about Simple Spreadsheets (6:56)
The 6-Step Data Analysis Process & Draft Agenda for 10-Week Program (8:51)
Step 0: The Absolute Beginner's Guide to Spreadsheets (72:06)
Step 1: Navigate Your Spreadsheets (60:07)
Step 2: Merge Variables Together or Pull Them Apart (78:12)
Step 3: Format, Clean, and Recode the Data (136:49)
Step 4: Explore the Data (93:25)
Step 5: Summarize Numbers with Formulas (96:42)
Step 5: Summarize Categories with Formulas or Pivot Tables (95:19)
Case Study: Demographic Data (105:37)
Case Study: Satisfaction Surveys (92:20)
Case Study: Expense Log (88:16)
Case Study: Pre-Post Assessments
Step 1: Navigate Your Spreadsheets (14:29)
Step 2: Merge Datasets Together (13:09)
Step 3: Format, Clean, and Recode the Data (14:02)
Step 4: Explore the Data with Sparklines, Data Bars, Heat Tables, and Additional Color-Coding (2:40)
Step 5: Summarize Data with Formulas (18:27)
Step 5: Or, Summarize Data with Pivot Tables (9:49)
Step 6: Share the Results in a Table or Graph (6:27)
Case Study: Deaths from Falls
Welcome & Materials
Step 1: Navigate Your Spreadsheets (13:11)
Step 2: Merge Variables Together or Pull Them Apart (5:11)
Step 3: Format, Clean, and Recode the Data (11:21)
Step 4: Explore the Data with Sparklines, Data Bars, Heat Tables, and/or Additional Color-Coding (4:44)
Step 5: Summarize Data with Pivot Tables or Formulas (15:38)
Step 5: Or, Summarize Data with Formulas (0:19)
Step 6: Showcase the Key Findings in Graphs (2:13)
Bonus Lessons
A Real-Life Excel Test from a Job Interview (28:58)
Tips for Passing the Excel Certification Exam (42:22)
How to Enter Cleaner Data AND Automate the Entire Analysis and Visualization Process (37:47)
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)
Next Steps
Recommended Resources
Step 3: Format, Clean, and Recode the Data
Lesson content locked
If you're already enrolled,
you'll need to login
.
Enroll in Course to Unlock