Course content
- Preparing and cleaning data
- Essential formulas
- Pivot tables and charts
Spreadsheets are the most common data tool in the workplace. This free course shows you how to clean, summarise and chart data in Excel.
Each lesson is short and practical, so you can learn on your lunch break.
Course summary
A quick, practical start to Excel for data analysis: tidy your data, use core formulas, build pivot tables and make clear charts.
Course objectives
- Clean and organise raw data in a spreadsheet
- Use core formulas such as SUM, AVERAGE, IF and VLOOKUP
- Summarise data with pivot tables and simple charts
Who should attend
Office staff, researchers, students and monitoring and evaluation officers who work with tables of data.
Curriculum
Module 01
Module 1: Preparing Your Data
2 lessons- Setting up clean data10 min
- Essential formulas15 min
Module 02
Module 2: Analysing and Presenting
2 lessons- Pivot tables in minutes15 min
- Making clear charts10 min