Build foundational Excel skills for public health data analysis while learning practical techniques to clean, organize, and prepare data for use in your local health department. Through hands-on activities, this session helps participants work with Wisconsin health data and gain confidence using Excel to clean and analyze datasets. This session is great for those who are new to using datasets in Excel, those who want to help others gain comfort in Excel, or anyone looking for a refresher. 

This is the second of a three-part series highlighting how to more effectively collect, organize, and analyze data, as well as identify ways to incorporate findings into your work. Participation in Session 1 is not required to complete Session 2. Consider reviewing the recording and presentation materials from Session 1.

Save the date for Data Workshop Series – Session 3 on September 23.

Pre-work 

Complete prior to viewing Session 2:

• Download one WISH dataset (CSV) for your chosen health priority.
• Identify two indicators for your topic using the CHA/CHIP Indicator List. 

Presentation Resources

• Presentation slides (PowerPoint)
• Excel step-by-step reference guide (PDF)
• Breakout room exercise slides (PDF)
• Presentation recording (YouTube)