The Excel Skills Employers in Kenya Ask For, and How to Learn Them

Read job adverts in Kenya for accounts assistants, procurement officers, HR administrators, sales coordinators or monitoring and evaluation officers, and one phrase keeps appearing: "proficiency in Microsoft Excel", often with the word "advanced" in front of it. Few adverts explain what that means. This article does. It breaks Excel into the skills employers actually test, shows where each one is used at work and gives you a plan to learn and prove them.

The foundation: clean, well-structured data

Before formulas, employers want someone who keeps a spreadsheet tidy. That sounds basic, but messy data is the main reason reports go wrong. A strong candidate:

• Keeps one header row, one record per row and one type of data per column.
• Turns ranges into Excel Tables (Ctrl+T), so formulas and charts grow automatically as new rows are added.
• Stores dates as real dates and numbers as real numbers, not as text.
• Uses sorting and filtering confidently to find and fix problems.
• Cleans text with functions such as TRIM, PROPER, LEFT and TEXTSPLIT.

If you have ever received a staff list where names are in capitals, phone numbers have stray spaces and dates are typed three different ways, you already know why this matters.

Everyday formulas

Every Excel role expects you to be comfortable with SUM, AVERAGE, COUNT, MIN, MAX and ROUND, and to understand relative and absolute references (the dollar signs in $B$2). You should be able to write an IF formula, combine conditions with the AND function or the OR function, and handle errors neatly with IFERROR.

A typical task: flag every invoice that is more than 30 days overdue. That needs a date calculation, an IF and conditional formatting to colour the result. It looks simple, but it shows an interviewer that you think in rules, not in manual checking.

Lookups

If there is one skill that separates "basic" from "proficient", it is looking up data from another table. Employers use lookups to match staff numbers to payroll details, item codes to prices or customer IDs to regions.

• XLOOKUP is the modern choice in Microsoft 365 and Excel 2021. It searches in any direction and handles missing values cleanly.
• VLOOKUP is still common in older workbooks, so learn to read it and to spot its classic mistakes, such as forgetting exact match.
• INDEX with MATCH works in every version and is worth knowing for shared files.

Summaries with SUMIFS and pivot tables

Managers rarely want raw data. They want totals by branch, by month, by product or by officer. Two tools do most of this work:

• SUMIFS, COUNTIFS and AVERAGEIFS build fixed summary tables that update when the data changes.
• Pivot tables summarise thousands of rows in seconds and let you regroup by any field.

Picture a sales report with branches in Nairobi, Mombasa, Kisumu and Eldoret. With a clean table and a pivot, you can show sales by branch and month, add a filter for product category and refresh it every week in under a minute. Excel for Data Analysis builds exactly these skills step by step, with an exercise after every lesson.

Charts and simple dashboards

Being able to present numbers clearly is a skill employers notice. Learn to choose the right chart for the question: a column chart for comparing categories, a line chart for trends over time, and rarely a pie chart. Remove clutter, label axes, and give every chart a title that states the point, such as "Mombasa sales grew every month this quarter".

A one-page dashboard built from pivot tables, charts and slicers is an excellent piece to show in an interview.

Data validation and protection

Workbooks that other people fill in need guard rails. Data validation drop-down lists stop people typing "Nbi", "Nairobi " and "NAIROBI" in the same column. Conditional formatting highlights missing or unusual values. Sheet protection keeps formulas safe while still letting colleagues enter data. These features show that you think about the people who will use your file.

The advanced layer

When adverts say "advanced Excel", they often mean some of the following:

• Power Query, which imports and cleans data from CSV files, other workbooks and exports from accounting systems, then repeats the same cleaning steps at the click of Refresh. It is ideal for monthly reports built from bank or mobile money statement exports.
• Dynamic array functions such as FILTER, UNIQUE, SORT and SEQUENCE, which return whole lists from one formula.
• The Data Model and Power Pivot, which link several tables and handle far more rows than a normal sheet.

Advanced Excel: Dynamic Arrays, Power Query and Data Models covers all three. If your work is moving towards interactive company dashboards, Power BI for Business Intelligence is the natural next step, because Power BI uses the same Power Query engine.

For finance and accounting roles, employers also value budgeting, forecasting and three-statement models built with clear assumptions. Financial Modeling in Excel teaches that structure.

Working habits employers notice

Skills get you through the test; habits make colleagues trust your work. Good Excel users:

• Keep inputs, calculations and outputs on separate, clearly named sheets.
• Never type a number into a formula when it should live in a labelled input cell.
• Add a short notes sheet explaining what the workbook does and where the data comes from.
• Name files consistently and save versions before large changes.
• Use keyboard shortcuts to move quickly, and share files through OneDrive or SharePoint rather than emailing copies back and forth.

Microsoft 365 Office Productivity is useful if you also want to tighten up your Word, Outlook and Teams skills, which often appear in the same adverts.

How to prove your Excel skills

Some employers give a short practical Excel test during interviews. Prepare by practising tasks against the clock: clean a messy list, write a lookup, build a pivot table and chart, and explain your steps out loud.

It also helps to build two or three portfolio workbooks with made-up but realistic data, for example a stock tracker for a hardware shop, a monthly expense report for a small NGO project or a sales dashboard for a distributor. Remove any real personal or company information before you share them. A certificate of completion that names the course and carries a verification code adds clear evidence alongside your portfolio.

A four-week learning plan

Spend three or four short sessions a week and you will see steady progress. Excel rewards practice far more than reading, so open a workbook every time you study.