Excel for Public Health Data: Management, Analysis & Visualization

2 Credits.

This course provides hands-on Microsoft Excel training tailored for local public health work. Students will learn practical skills to import, clean, manage, and document datasets (whether from surveillance reports, community health assessments, immunization records, or program evaluation data). Through guided exercises, the student will learn foundational tools (e.g., data validation, filters, pivot tables, basic formulas) and learn how to structure data for analysis while maintaining clarity and quality (e.g., creating data dictionaries, consistent coding, and clean formatting).