Course Details
A comprehensive immersion in Excel's powerful but often underutilized analytical capabilities. Perfect for public health practitioners with limited programming experience. Master advanced functions, Power Query, PivotTables, data validation, and visualization techniques specifically applied to health datasets. Learn time-saving automation, data cleaning strategies, and dashboard creation that will transform your daily work with surveillance data, program metrics, and health statistics.
Learning Outcomes
Learn how to import and clean messy a dataset using Power Query
Create dynamic PivotTables for data analysis
Apply advanced Excel functions for statistical calculations
Implement data validation to ensure data quality
Generate professional reports with charts and visualizations
Build automated dashboards for program monitoring
Course Prerequisites
None
Topics Covered
Data Collection, Data Management, Data Visualization, Dashboarding