Humanitarian HR Analytics with Excel

95% of HR jobs in the UN and NGOs require Excel. Why? Because humanitarian and development organizations manage large amounts of workforce data every day, from recruitment pipelines and staff databases to leave, contracts, training and workforce reporting. But having HR data is not enough. HR professionals increasingly need to turn that data into clear information that helps managers understand workforce trends, identify risks, improve processes and make better decisions. Humanitarian HR Analytics with Excel is a practical, hands-on training that combines Excel skills with realistic HR applications from the humanitarian and development sector. You will learn how to build and use practical HR tracking systems, analyse workforce data, develop professional dashboards and generate management-ready reports, while gaining access to the Relief Lab's Humanitarian HR Analytics Toolkit, a suite of Excel-based tools designed specifically for humanitarian and development HR work.

✔ Learn Excel through real HR applications Instead of learning Excel functions in isolation, you will apply them to realistic HR challenges such as recruitment tracking, leave management, contract monitoring, staff databases and workforce reporting.

✔ Build practical HR analytics skills Learn how to move beyond basic spreadsheets and use Excel to organize, analyse, visualize and interpret workforce data for management and decision-making.

✔ Get the Relief Lab Humanitarian HR Analytics Toolkit You will receive a practical suite of Excel-based tools, including: ✨Recruitment Tracker ✨Staff Database Manager ✨Leave Management Tracker ✨ Contract Expiry Monitoring Tool ✨Training & Learning Tracker ✨Humanitarian HR Executive Dashboard ✨A Customization Guide: the toolkit is designed to give you resources that you can adapt and use in your own professional context.

✔ Learn by doing The training is built around practical exercises, guided activities and realistic humanitarian HR scenarios — allowing you to practise what you learn throughout the programme.

✔ Develop management-ready HR reporting skills Learn how to transform workforce data into dashboards, reports and insights that can support workforce planning, management meetings, compliance monitoring and organizational decision-making.

✔ Strengthen your professional profile Develop a practical competency that is relevant to HR, People & Culture, recruitment, workforce planning, operations and HR data roles across humanitarian and development organizations.

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 Excel formulas and functions to real HR data.

✅ Build recruitment tracking systems and monitor recruitment performance.

✅ Develop leave management and staff training monitoring systems.

✅ Analyse workforce demographics, staffing patterns and workforce composition.

✅ Monitor contract expiry risks and workforce trends.

✅ Produce management-ready HR reports and workforce analytics products.

✅ Transform HR data into actionable insights for workforce planning and decision-making.

✅ Adapt practical HR analytics tools to organizational needs.

Participants will learn through:

✔ Live online instructor led sessions Learn directly from experienced practitioners. Live sessions from Monday to Friday, 5PM to 9PM UTC+1 Participants need a computer (or mobile device), a reliable internet connection and either a headset with a microphone to connect to the audio through a computer, or a telephone.

✔ Realistic humanitarian HR case studies based on common workforce-management situations.

✔ Guided practical exercises that allow participants to apply each concept.

✔ Step-by-step development of HR analytics tools and dashboards.

✔ Practical use of the Relief Lab Humanitarian HR Analytics Toolkit.

✔ Management reporting exercises focused on turning HR data into useful insights.

✔ Guided customization, helping participants understand how tools can be adapted to their own organizational context.

✔ Recorded session replays, allowing participants to revisit demonstrations and practical activities.

HR and People & Culture professionals working in humanitarian and development organizations.

✨ Module 1 — HR Data Management with Excel

✨ Module 2 — Excel for HR Data Analysis

✨ Module 3 — Recruitment & Workforce Tracking

✨ Module 4 — HR Management Systems

✨ Module 5 — HR Dashboards & Management Reporting

✨ Module 6 — Relief Lab Humanitarian HR Analytics Toolkit