Excel skills every NGO officer needs

Why Excel still matters for NGO work

Budgets, beneficiary lists, activity trackers, stock sheets and indicator tables. Most NGO data lives in a spreadsheet. When the sheet is messy, reports are late and numbers do not match. When the sheet is clean, a monthly report takes hours, not days.

You do not need to be an Excel expert. You need a small set of skills, used the same way every time. This guide lists those skills in the order to learn them. It works for programme, MEAL, finance and admin staff.

What are the seven core skills?

Skill 1: Keep data in a proper table

Most problems start with the layout. A good data sheet has one header row, one record per row and one type of data per column. Do not merge cells. Do not leave blank rows. Do not put notes in the middle of the data.

Then convert the range into an Excel table (Insert > Table). According to Microsoft, a table gives you a header row with filters on every column, and formulas that use column names (structured references) which adjust when you add or remove rows. This means a new row is included in your totals without any change to the formula.

Skill 2: Sort and filter

Sorting and filtering answer most quick questions. Which activities are late? Which partner has not reported? Which households received support in March? With table filters, you can find the answer in seconds and avoid scrolling through hundreds of rows.

One caution: filter a copy if you plan to delete rows. Deleting inside a filtered view is how people lose data.

Skill 3: Five formulas that cover most needs

Learn these five before anything else. Write each formula once in a table column and let the table fill it down. Check one row by hand to make sure the formula does what you expect.

Skill 4: Stop bad data with data validation

Most data errors come from typing. One officer writes "Female", another writes "F", a third writes "female ". Counts then come out wrong.

Data validation fixes this at the source. Microsoft notes that it lets you limit entries to a list of items, a number range or a date range. Use drop-down lists for sex, location, activity type and status. Use number limits for ages. Add a short error message that tells the user what is allowed. For more on checking data after it is collected, see our guide to data quality checks.

Note that validation works when people type into a cell. Microsoft also states that pasted or filled data can skip the check, so review pasted data too.

Skill 5: Summarise with a pivot table

A pivot table totals and counts your data by any column without formulas. You drag "Location" to rows and "Participants" to values, and the summary appears. Change your mind, and you move the field. Our step-by-step guide to pivot tables for monitoring data shows how.

Skill 6: Make one clear chart

A chart should answer one question. Use a bar chart to compare groups and a line chart for change over time. Give it a title that states the finding, for example "Training attendance rose in Q3". Remove extra colours and gridlines. If you cannot say in one sentence what the chart shows, do not use it.

Skill 7: Safe file habits

Good habits protect your work and the people in your data.

1. Save a dated copy before any big change, for example Tracker_2026-11-10.xlsx.
2. Keep one master file. Do not email five versions and merge them later. Our guide on using Google Sheets for team collaboration shows one way to avoid this.
3. Protect personal data. Remove names and phone numbers from files that you share widely. Use a password or restricted folder for files that must hold them.
4. Document the file. Add a "Read me" sheet that explains the columns, the formulas and who owns the file.
5. Check the totals. Compare a total in your sheet with a source document before you send a report.

A simple practice plan

Take one real tracker from your project. In week one, turn it into a table and add filters. In week two, add five formulas. In week three, add data validation. In week four, build one pivot table and one chart. After a month, you will use these skills without thinking.

How EMPO can help

EMPO is a trusted, Yangon-based training and consultancy provider and one of Myanmar's leading names in practical NGO training, with 1,200+ people trained and 15 partner organisations. We run practical training for NGO and CSO teams, online over Zoom or in person across Myanmar, in English and Burmese, and can build a session around your own trackers. See our training services, or try the Master Project Budget Tracker in our store.

Sources

• Overview of Excel tables — Microsoft Support
• More on data validation — Microsoft Support