What you will be able to do
- Structure data so that it can be analysed
- Clean and combine data from several sources
- Summarise data with pivot tables and descriptive statistics
- Build workbooks that others can check and update
Who it is for
- Analysts and officers who work with administrative data
- Finance, HR and planning staff
- M&E officers
Prerequisites
- Everyday use of a spreadsheet
Program
Well-structured data
- One row per record, one column per variable
- Data types, codes and dates
- Separating raw data, calculations and outputs
Cleaning and combining
- Duplicates, blanks and inconsistent entries
- Lookups to combine tables
- Checks that catch errors early
Analysing
- Pivot tables
- Averages, medians and distributions
- Comparing groups and periods
Reproducible workbooks
- Documenting sources and steps
- Formulas that others can follow
- Updating with new data without starting over
How we work
- Hands-on exercises on realistic training datasets
- A small analysis project from question to summary
- Peer review of workbooks