The verdict in three sentences
In Abidjan in 2026, an HR assistant who keeps leave, hours and payroll items in a reliable Excel workbook spends less time recounting and makes fewer mistakes at month end. The Kolonell course Practical Excel: tables, formulas and analysis for work, taught in French, costs 75,000 FCFA for 14 hours with a certificate, against 150,000 to 300,000 FCFA for an in-person workshop. It is level 3 Advanced of the office skills track: it assumes you can already open a workbook and enter data.
The HR spreadsheets you will be able to build
HR assistants in Abidjan, in Plateau as well as in Cocody or Treichville, often juggle a paper attendance book, WhatsApp leave requests and an inherited Excel file nobody understands. The problem is rarely Excel itself: it comes from poorly structured tables.
| HR need | Excel function or tool | Time saved per month (estimate) |
|---|---|---|
| Leave balance per employee | SUMIFS, dates and NETWORKDAYS | 2 to 4 h |
| Weekly overtime | Time formulas and MOD | 1 to 3 h |
| Seniority bonus | Nested IF or XLOOKUP | 1 to 2 h |
| Absenteeism summary by department | Pivot table | 2 to 3 h |
| Input control (staff ID, dates) | Data validation | Errors prevented upstream |
| End of contract alert | Conditional formatting | Missed deadlines avoided |
| Clean export for the accountant or CNPS | Structured table and filter | 1 h |
The course also works with Google Sheets, useful if your company shares files online.
Excel training in Abidjan: comparing options
The following figures are 2026 orders of magnitude observed in Abidjan.
| Option | Cost | Duration | Certificate | Suited to HR? |
|---|---|---|---|---|
| Kolonell course, level 3 Advanced | 75,000 FCFA (about 115 EUR) | 14 h, self-paced | Yes, Kolonell Academy certificate | Yes, payroll, stock, budget examples |
| In-person Excel workshop (training firm) | 150,000 to 300,000 FCFA | 2 to 4 days | Attestation | Often generic |
| Employer-funded training (FDFP) | Variable, application required | Per training plan | Attestation | Depends on the provider |
| YouTube tutorials | 0 FCFA | Variable | No | Fragmented, no complete HR case |
| International online certificate | About 30,000 to 60,000 FCFA | 10 to 20 h | Yes | In English, examples outside the Ivorian context |
The Kolonell course is taught in French. It belongs to the Office skills and productivity track, whose 5 levels cost 350,000 FCFA instead of 450,000 FCFA bought separately. If you are not comfortable with computers, start with level 1 instead.
What Excel is worth on the Ivorian HR market
| Position in Abidjan | Monthly salary (2026 order of magnitude) | Expected Excel level |
|---|---|---|
| Administrative assistant | 150,000 to 250,000 FCFA | Data entry, simple formulas |
| HR assistant | 200,000 to 350,000 FCFA | Formulas, pivot tables |
| Junior payroll officer | 300,000 to 450,000 FCFA | Advanced Excel and payroll software |
| Experienced HR officer | 400,000 to 650,000 FCFA | Analysis, dashboards |
| SME administrative manager | 450,000 to 800,000 FCFA | Full reporting |
These ranges depend on the sector and company size. Excel does not replace knowledge of the Ivorian Labour Code or CNPS rules, but it is often the tool that separates an HR assistant from a payroll officer.
Mini case study
Learn this skill with Kolonell Academy
Short, practical online courses (taught in French), graded exercises, certificate. Pay with Wave or Orange Money.
Koffi, 27, is an HR assistant at a 60 employee logistics company in Yopougon, earning 230,000 FCFA per month. He spent about 10 hours a month recalculating leave and overtime by hand. After the course, he builds a workbook with one tab per month and a pivot table per department: the work drops to 3 hours. Six months later, he is promoted to junior payroll officer at 300,000 FCFA. Calculation: 75,000 FCFA of training for a 70,000 FCFA monthly gain, paid back in about five weeks. This case is illustrative; promotion depends on the employer.
FAQ
What level do I need before starting?
You need to be able to open a workbook, enter data and do a simple sum. If not, level 1 at 25,000 FCFA prepares you in 9 hours.
Does the course cover pivot tables?
Yes, they are part of the 14 hours, with exercises on sales, stock and payroll data. Allow 3 to 6 weeks at 3 hours per week.
Can I use Google Sheets instead of Excel?
Yes, the main formulas are about 90 % identical. Google Sheets is free with a Google account, which avoids a Microsoft 365 licence of about 50,000 FCFA per year.
Does the certificate help with a promotion?
The Kolonell Academy certificate confirms the programme you completed. What weighs most is a concrete HR workbook you can show your manager.
How do I pay for enrollment?
By Wave or Orange Money, in one go, at enrollment. Access opens as soon as payment is confirmed.
Take the next step. Enroll in Practical Excel: tables, formulas and analysis for work: 14 hours, 75,000 FCFA, Kolonell Academy certificate. Pay with Wave or Orange Money. Questions? WhatsApp +221 77 596 93 33.
Mohamed Bah
Fondateur, Kolonell
Passionate about digital and entrepreneurship in Africa, Mohamed has been helping Sénégalese businesses with their digital transformation since 2020. Founder of Kolonell, he believes every SME deserves a professional and accessible online présence.
