Training: Data cleaning and analysis in Excel
SCI convened a capacity building workshop focusing on data cleaning and analysis using Microsoft Excel in Ethiopia, between 17th and 20th November 2015. Skills covered during the workshop include pivot tables, if functions and graphing results.
Documents from the course are available for free download below. If you use or amend the course please credit SCI for the contribution. For questions please email us at email@example.com.
- Session_1_warm-up (PDF)
- Session_2_data-cleaning-workbook-and-identity-variable-checks (PDF)
- Session_3_cheatsheet (PDF)
- Session_4-checking-protocol (PDF)
- Session_5-creating-parasitological-variables (PDF)
- Session_6-parasitological-summary (PDF)
- Session_7-creating-parasitological-summaries (PDF)
- Session 8 was done verbally but not recorded.
- Session_9-data-entry (PDF)