The verdict in three sentences
In Dakar, an assistant or administrator comfortable with pivot tables and XLOOKUP typically earns 180,000 to 350,000 FCFA gross per month (about 275 to 535 EUR), depending on the sector (2026 order of magnitude, no income is guaranteed). In an interview or for a promotion, the "Excel" line on a CV weighs less than a file that works put on the table: a stock sheet with alerts, an invoice that finds the price and the customer on its own, a monthly pivot table analysis. The course Practical Excel: tables, formulas and analysis for work (level 3, 75,000 FCFA, 14 h, taught in French) is built around exactly these deliverables.
2026 salary ranges in Dakar
The figures below are orders of magnitude seen on the Dakar job market in 2026. They vary with the company, the sector and your experience, and no course guarantees a job or a raise. For reference, the average formal-sector salary in Dakar is around 280,000 to 350,000 FCFA in 2026.
| Profile in Dakar | Expected Excel level | Indicative gross monthly salary 2026 |
|---|---|---|
| Shop cashier or salesperson | Simple entry, sums | 90,000 to 150,000 FCFA |
| Junior administrative assistant | Clean tables, basic formulas | 130,000 to 200,000 FCFA |
| Assistant or administrator comfortable with Excel | IF, SUMIFS, XLOOKUP, pivot tables | 180,000 to 350,000 FCFA |
| SME stock manager | Stock sheet, alerts, inventory | 180,000 to 300,000 FCFA |
| Salesperson who tracks their numbers | Sales log, pivot by customer | 150,000 to 300,000 FCFA, excluding bonuses |
| Freelancer (custom workbook) | Complete management tools | 30,000 to 150,000 FCFA per workbook delivered |
The last row matters: alongside a job, building a management workbook for a shop or an SME is commonly billed 30,000 to 150,000 FCFA in 2026 (about 45 to 230 EUR). It is a possible extra, not an assured income.
The three skills that make the difference in an interview
A Dakar recruiter rarely tests Excel in theory. They ask "what have you already built?". Level 3 has you produce three tools you can show on your phone or laptop.
The stock sheet with stock-out alerts. Module 6: stock in, stock out, theoretical stock and alert threshold, with the conditional formatting from module 4 turning the item to reorder red. For a wholesaler in Colobane or a pharmacy, this is an immediately useful skill.
The invoice that finds the price and the customer. With XLOOKUP (module 3), you type an item code and Excel brings back the description and the price and calculates 18 % VAT. If your version lacks XLOOKUP, the lesson also covers VLOOKUP and INDEX MATCH.
The monthly pivot table analysis. Module 5: summarize thousands of sales rows by month, salesperson or product, then present two commented charts. This is often what moves you from executor to the manager's trusted person.
| Level 3 module | What you can do afterwards | Use at work |
|---|---|---|
| 1. Build a clean table (free preview) | FCFA formats, dates, structured table | No more "digital notebook" files |
| 2. Essential formulas | Absolute references, margins, 18 % VAT | No more totals redone on a calculator |
| 3. Logical and lookup functions | IF, COUNTIF, SUMIFS, XLOOKUP | Automatic invoice and price list |
| 4. Sort, filter and make data talk | Drop-down lists, conditional formatting | Fewer entry errors |
| 5. Pivot tables and charts | Pivot tables, mini dashboard | Answering the boss in minutes |
| 6. Ready-to-use management tools | Sales log for Wave, OM and cash, stock, budget, invoice | Protected, shareable workbook |
Two projects are to be submitted: your automated price and sales table (module 3) and the final project, an SME management workbook (module 6).
What upskilling costs
| Option | Indicative 2026 price | What you get |
|---|---|---|
| Free online tutorials | 0 FCFA | Scattered notions, no FCFA cases, no common thread |
| In-person Excel training in Dakar | order of magnitude 100,000 to 250,000 FCFA | Fixed hours, travel |
| Kolonell Academy, level 3 Excel | 75,000 FCFA (about 115 EUR), 14 h | Text lessons, PDFs, exercises with answer keys, quizzes, 2 projects, lifetime access |
| Full Office Productivity track (5 levels) | 350,000 FCFA instead of 450,000 | From level 1 to level 5 |
The course works on a phone, even on 3G, with no app to install, using Excel or Google Sheets (free, enough for 90 % of the exercises). Plan about 14 hours, i.e. four to five weeks at three sessions a week. Prerequisites: levels 1 and 2 of the Office and productivity track or equivalent ease with a computer, and knowing how to compute a percentage on a calculator. Support goes through the course forum and WhatsApp.
Learn this skill with Kolonell Academy
Short, practical online courses (taught in French), graded exercises, certificate. Pay with Wave or Orange Money.
Mini case study
Consider a hypothetical learner: Awa, 24, assistant in a building materials shop in Parcelles Assainies, earning 150,000 FCFA gross. She takes level 3 over five weeks, then shows her manager the stock sheet with alerts and the Wave, Orange Money and cash sales log she built during the course. Illustrative calculation: if this helps her get an administrator role at 200,000 FCFA, the 50,000 FCFA monthly difference would pay back the 75,000 FCFA in a month and a half. If she also builds a custom workbook billed 40,000 FCFA to another shop, the cost would be covered even faster. This scenario is not an achieved result: it simply compares a fixed cost with a possible gain.
FAQ
Do I need to be good at maths for level 3?
No. The course requires addition, multiplication and percentages. Each formula is first explained on a concrete FCFA case, for example 18 % VAT on a price list.
What salary can I aim for in Dakar after the course?
The 2026 order of magnitude for an assistant or administrator comfortable with pivot tables and XLOOKUP is 180,000 to 350,000 FCFA gross per month, depending on the sector. No income is guaranteed: the course strengthens your profile, hiring depends on the employer.
Is the certificate worth anything?
You receive a numbered Kolonell Academy certificate, verifiable online via QR code, which you can add to LinkedIn, after passing the module quizzes with at least 70 %; your final project must also be approved by a reviewer. It is not a state diploma: its real strength is backing up the files you show.
Can I try before paying 75,000 FCFA?
Yes, module 1 "Build a clean table" is a free preview. Do it first, because access is no longer refundable once activated.
How do I pay and when does access open?
With Wave or Orange Money at +221 77 596 93 33. Access is activated within 24 working hours after payment and stays valid for life, updates included.
---
Take the next step. Enroll in Practical Excel: tables, formulas and analysis for work: 14 h, level 3 Intermediate, 75,000 FCFA (about 115 EUR), numbered Kolonell Academy certificate, taught in French. 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.
