Skip to content

We've built 200+ tools — open your toolbox, there's something in here you probably need.

💻 Education & Scholarships

Digital Skills and Excel Roadmap to Get Jobs in Kenya (2026)

The pain: You want a job or online work but do not know which digital skills matter or where to learn them without paying a fortune.

The outcome: You build the in-demand skills in the right order, master PivotTables, and learn free or cheaply through Ajira Digital, ALX and Google.

PivotTables and PivotCharts are the key hiring skill for analyst and admin roles.

Do it with LeadAfrik — free

In-demand skills

  • Excel and Google Sheets.
  • Data analysis and visualization (plus SQL, Power BI/Tableau, Python for higher roles).
  • Digital marketing (SEO, social, Google Ads and Analytics).
  • Virtual assistance.
  • Graphic design (Canva).
  • Bookkeeping software (QuickBooks, Sage).
  • General AI-tool literacy.

Excel roadmap (in order)

  1. 1Navigation, data entry, formatting, freeze panes.
  2. 2Basic formulas: SUM, AVERAGE, COUNT, MIN/MAX, percentages.
  3. 3Logical and lookup: IF and nested IF, VLOOKUP/XLOOKUP, INDEX/MATCH.
  4. 4Text and date functions, plus sorting, filtering, conditional formatting and data validation.
  5. 5PivotTables and PivotCharts, the key hiring skill for analyst and admin roles.
  6. 6Charts and dashboards, data cleaning, Power Query basics and light macros.

Free or cheap ways to learn

  • Ajira Digital (free government online-work training), Grow with Google, ALX Africa (free or low-cost data and AI), Coursera/edX (audit free or apply for Financial Aid).
  • Microsoft Learn, freeCodeCamp, YouTube. Moringa School bootcamps (paid, with financing) and accredited TVET short courses.

Ready to act? Use these free tools

Questions people ask

Which Excel skill matters most for jobs?

PivotTables and PivotCharts are the key hiring skill for analyst and admin roles. Work through the roadmap in order first, from navigation and basic formulas up to lookups, before you reach PivotTables.

Where can I learn for free?

Ajira Digital offers free government online-work training, and Grow with Google, ALX Africa, Microsoft Learn, freeCodeCamp and YouTube are free or low-cost. Coursera and edX let you audit free or apply for Financial Aid.

What skills are in demand?

Excel and Google Sheets, data analysis and visualization (plus SQL, Power BI/Tableau and Python for higher roles), digital marketing, virtual assistance, graphic design, bookkeeping software and general AI-tool literacy.

Keep it current: Course offerings, costs and financing options change. Confirm current details on each provider's site, such as ajiradigital.go.ke and alxafrica.com, before enrolling.

Official sources

Read next

Free

Free tools, templates & the Kenya money brief

New free tools, ready-to-use templates, and the numbers that move Kenyan money — in your inbox. Free, no spam.

No spam. Unsubscribe any time.

← All practical guides for Kenya