Humanitarian HR Analytics with Excel — from recruitment tracking to workforce analytics.
A practical, hands-on training designed for HR and People & Culture professionals working in humanitarian and development organizations. Build the Excel skills — and the toolkit — to transform workforce data into actionable insights.
HR teams are now expected to produce workforce insights — not just process paperwork.
Humanitarian organizations depend on their people. As they grow, so does the volume of workforce data that HR and People & Culture teams must manage: recruitment pipelines, staff databases, contracts, leave, training records and workforce reporting.
Microsoft Excel remains the most widely used tool for managing and analysing this data across the sector. Yet many HR professionals have never received structured training on how to use it efficiently for analytics, reporting and decision-making — so significant time is lost on repetitive manual tasks while real workforce insights remain out of reach.
This training closes that gap with realistic humanitarian HR case studies, practical exercises and a complete suite of ready-to-use Excel tools.
By the end of the training, participants will be able to:
- Organize, clean and manage HR datasets using Excel best practices
- Build structured employee databases and workforce management systems
- Apply essential Excel formulas and functions for HR data analysis
- Use VLOOKUP and XLOOKUP to connect and manage workforce data
- Design recruitment tracking systems and monitor recruitment performance
- Build leave management and training monitoring systems
- Analyse workforce demographics, staffing patterns and composition
- Develop professional HR dashboards using Pivot Tables and Pivot Charts
- Monitor contract expiry risks and workforce trends
- Automate routine HR processes with conditional formatting, validation and alerts
- Produce management-ready HR reports and workforce analytics products
- Transform HR data into actionable insights that support strategic decisions
Five days, end-to-end — from clean data to executive dashboards.
- Day 1 — Building Strong HR Data Foundations
- Day 2 — HR Data Analysis with Excel
- Day 3 — Recruitment and Workforce Management Systems
- Day 4 — Humanitarian HR Analytics and Dashboards
- Day 5 — Automation and Workforce Analytics
The Relief Lab Humanitarian HR Analytics Toolkit.
Every participant leaves with a complete suite of practical Excel-based tools designed specifically for humanitarian and development organizations — yours to keep and adapt after the training.
Operational tools
- Recruitment Tracker
- Staff Database Manager
- Leave Management Tracker
- Contract Expiry Monitoring Tool
Management tools
- Payroll Preparation Template
- Training & Learning Tracker
- Workforce Analytics Dashboard
Reporting & guidance
- Humanitarian HR Reporting Templates
- Customization Guide
- Lifetime access to toolkit updates
Designed for HR and People & Culture professionals across the sector.
HR & People roles
- HR Assistants / Officers
- HR Coordinators / Managers
- People & Culture Officers / Managers
- Workforce Planning Officers
Specialist roles
- Recruitment / Talent Acquisition Officers
- Learning & Development Officers
- Payroll & Administrative Officers
- Operations staff handling HR data
Organizations
- UN agencies
- International NGOs
- National NGOs & CSOs
- Foundations & development orgs
250,000 XAF per participant — confirmed on receipt of payment.
Included
- All training modules and exercises
- Relief Lab HR Analytics Toolkit
- Training materials (badge, notebook, pen)
- Breakfast and lunch
- Wi-Fi access
- Certificate of Practical Competency
Not included
- Accommodation
- Transport
Please bring
- Laptop computer
- Laptop charger
- Microsoft Excel 2016 or later
Certificate of Practical Competency in Humanitarian HR Analytics with Excel.
Awarded to participants who actively take part in the 5-day workshop, complete the practical exercises and successfully complete the final workforce analytics assessment. It reflects applied competency in workforce data management, HR reporting, workforce analytics and data-driven HR decision-making.
Join the Relief Lab HR Analytics Community.
- Continued peer learning
- Post-training technical support
- Access to toolkit updates
- Networking opportunities
- Information on future Relief Lab learning programmes