Excel Basics and Digital Security
A hands-on course for MEAL specialists and programme teams in humanitarian organisations. Learn to clean KoBo exports quickly, calculate disaggregated indicators, maintain an Indicator Tracking Table (ITT) and prepare donor reports — while keeping beneficiary data out of the wrong hands.
Course goal
To give MEAL teams practical tools for everyday work: from raw survey data and distribution lists to accurate figures in a donor report — without double-counting beneficiaries, losing track of file versions or leaving open links to spreadsheets with personal data.
Problems we help you solve
KoBo exports “fall apart”: dates turn into text, Cyrillic breaks, and one community is spelled ten different ways.
The same person appears on several lists — so the report shows more beneficiaries than were actually reached.
Sex, age and disability disaggregation is calculated by hand every time, and figures differ between reports.
The Drive is full of “Report_final_2_new.xlsx”, and the sheet with names and phone numbers is open to “anyone with the link”.
Who this course is for
MEAL officers and assistants who collect, verify and analyse monitoring data.
Programme and project managers who prepare donor reports and track indicators.
Registration, distribution and feedback mechanism (CFM) staff who maintain beneficiary lists.
Local partner organisations that exchange data with international partners via Google Drive.
Course programme
Spreadsheets and Google Drive for MEAL teams
- sound data structure: one row per record, one column per question;
- importing KoBo / ODK exports (XLSX and CSV) without broken dates or Cyrillic;
- Excel or Google Sheets: which to use when, and formula and format compatibility;
- project folder structure on Google Drive and file naming rules;
- version history instead of “final_2_new”: how to find and restore the right version.
Data cleaning and verification
- removing extra spaces, splitting and merging columns, fixing formats;
- consistent names of regions, communities and settlements based on an official reference list;
- finding duplicate beneficiaries by ID, phone number or document;
- conditional formatting to flag gaps, outliers and illogical answers;
- drop-down lists and data validation so errors don’t come back;
- a cleaning log: what was changed and why — for transparency with donors.
Formulas for indicators and disaggregation
- COUNTIFS and SUMIFS for disaggregation by sex, age and disability;
- unique beneficiaries vs. number of services delivered — avoiding double counting;
- age groups from dates of birth and achievement percentages;
- VLOOKUP / XLOOKUP: reconciling registration and distribution lists, finding who hasn’t received assistance;
- Google Sheets: FILTER, UNIQUE, QUERY and IMPORTRANGE to combine data from several files.
Pivot tables, ITT and donor reports
- pivot tables: breakdowns by location, period, type of assistance and partner;
- Indicator Tracking Table (ITT): baseline, target, actual and % achieved;
- charts a donor understands at a glance;
- a simple Google Sheets dashboard that updates from monitoring data;
- collaboration: comments, assigning tasks to colleagues, protected ranges for formulas.
Protecting beneficiary data
- data minimisation: collect and keep only the personal data you really need;
- pseudonymisation: replacing names with IDs and keeping a separate key file with restricted access;
- Google Drive access settings: roles, disabling download and copying, access expiry;
- the risks of “anyone with the link” and how to check who can open your files;
- sharing anonymised data with partners and donors, retention and deletion periods;
- especially sensitive data: CFM complaints and feedback, vulnerability data.
Digital security in everyday work
- securing your work Google account: strong passwords and two-factor authentication;
- phishing: fake “file access requests”, emails “from the donor”, files with macros;
- tablets and phones with KoBo Collect in the field: screen lock, encryption, what to do if a device is lost;
- incident response: a spreadsheet with data was accidentally shared with the wrong people.
After the course you will be able to
- quickly turn a raw KoBo export into a clean, analysis-ready table;
- find duplicates and reconcile registration and distribution lists;
- calculate indicators disaggregated by sex, age and disability without manual counting;
- maintain an ITT and prepare pivot tables and charts for donor reports;
- organise your project’s Google Drive and set up access correctly;
- anonymise beneficiary data before sharing and respond to a data leak.
Learning format
The course runs over 6 days on Google Meet, each session lasting 2 hours. New groups start every quarter.
Practice on training datasets that resemble real ones: a survey export, a distribution list and an ITT.
Key topics
Sign up
Write or call us — we’ll tell you about the next group.
