Digital Africa10 min read

Excel Training in Saint-Louis, Senegal: Formulas, Pivot Tables and Price (2026)

Mohamed Bah·Fondateur, Kolonell
November 2, 2026
Share:
Excel Training in Saint-Louis, Senegal: Formulas, Pivot Tables and Price (2026)

Excel Training in Saint-Louis, Senegal: Formulas, Pivot Tables and Price (2026)

Digital Africa

The verdict in three sentences

In Saint-Louis, Excel remains the most requested office skill in administrative, accounting and logistics job ads, and the words "advanced Excel" filter out many candidates. A local in-person course costs, as a 2026 ballpark, 80,000 to 200,000 FCFA (about 120 to 300 EUR), with fixed hours that are hard to fit around a job. With 14 hours of targeted practice on formulas, pivot tables and dashboards, an administrative officer can win back 3 to 5 hours a week on repetitive tasks.

Why Excel matters so much in Saint-Louis in 2026

Saint-Louis is full of employers that run on spreadsheets: Gaston Berger University and its administrative departments, regional government offices, agricultural companies in the river valley, health facilities, hotels on the island and the Langue de Barbarie, NGOs and development projects. They all track budgets, stock, attendance, harvests or beneficiaries in Excel.

In 2026 job ads for administrative assistants, junior accountants, stock managers or monitoring and evaluation officers, Excel is almost always listed. What recruiters test is precise: an XLOOKUP, a SUMIFS, a pivot table and a clean chart within a few minutes.

Target job in Saint-LouisExcel useExpected levelMonthly salary (2026 ballpark)
Administrative assistantLists, letters, file trackingIntermediate150,000 to 250,000 FCFA
Junior accountantReconciliations, statements, VATAdvanced200,000 to 350,000 FCFA
Stock managerInflows, outflows, threshold alertsIntermediate to advanced180,000 to 300,000 FCFA
M&E officer (NGOs, projects)Indicators, dashboardsAdvanced300,000 to 550,000 FCFA
HR assistantAttendance, leave, simple payrollIntermediate180,000 to 280,000 FCFA
Intern studentData collection and analysisIntermediateStipend 50,000 to 100,000 FCFA

Comparing training options

Option2026 priceLengthStrengthsLimits
Free YouTube videos0 FCFAVariesAvailable everywhereNo progression, no graded exercises
Free online certificates0 to 25,000 FCFA6 to 20 hDecent basicsEuropean examples, few local cases
Training centre in Saint-Louis80,000 to 200,000 FCFA15 to 30 hTrainer on siteFixed hours, travel, mixed-level groups
Kolonell, Practical Excel (level 3)75,000 FCFA14 hReal work cases, self-paced, certificateRequires personal discipline
Full Kolonell track (5 levels)350,000 FCFA instead of 450,000ProgressiveFrom computer basics to the full Office suiteLonger commitment

The course Practical Excel: tables, formulas and analysis for work, taught in French, is level 3 of the Office and productivity track. You pay with Wave or Orange Money and follow it on a computer at your own pace.

What you learn in 14 hours

The syllabus is built around tasks you already do at work, not around a list of functions.

BlockSkillsOffice taskEstimated time saved
Clean tablesFormatting, structured tables, data validationAttendance files, beneficiary lists30 min a week
Core formulasSUMIFS, COUNTIFS, nested IFTotals by month, staff member, area1 h a week
LookupsXLOOKUP, INDEX and MATCHMatching two lists, finding a price or ID1 h a week
Pivot tablesGrouping, filters, slicersMonthly sales or expense reports1 to 2 h a week
Charts and dashboardReadable charts, key indicatorsManagement meeting, donor report30 min to 1 h a week

In total, learners who apply the method to their real files win back roughly 3 to 5 hours a week. That gain obviously depends on how much of your job is spent in Excel.

Mini case study

Mariama, 29, an accounting assistant at a distribution company in Saint-Louis, prepares a sales report by salesperson and product at the end of every month. She copies totals by hand, which takes about 6 hours a month, plus 1 hour a week searching across two customer files.

Learn this skill with Kolonell Academy

Short, practical online courses (taught in French), graded exercises, certificate. Pay with Wave or Orange Money.

  • Course cost: 75,000 FCFA, paid with Wave.
  • After the course: the monthly report comes out of a pivot table in 45 minutes, and lookups are done with XLOOKUP.
  • Time saved: about 5 hours a month on the report and 4 hours on lookups, so 9 hours a month.
  • Value of that time: on a 250,000 FCFA salary for 173 hours, one hour is worth about 1,445 FCFA, so 13,000 FCFA a month.

The cost is covered in under 6 months by time savings alone. More importantly, Mariama can now apply for junior accountant roles that require advanced Excel, with a possible salary gap of 50,000 to 100,000 FCFA a month, with no guarantee.

FAQ

Do I need to know Excel already for level 3?

You should be able to open a file, enter data and do a simple sum. If not, levels 1 and 2 of the office track cover those basics in a few hours.

How much does the Kolonell Excel course cost?

Level 3 costs 75,000 FCFA for 14 hours, payable with Wave or Orange Money. The full 5-level track costs 350,000 FCFA instead of 450,000.

Is the certificate useful for hiring?

It shows you completed the 14 hours and passed the quizzes, which reassures a recruiter. What convinces most is passing the 15 to 30 minute Excel test often given in interviews.

Can I follow it on LibreOffice or Google Sheets?

Most formulas work in Google Sheets, free with a Google account. For pivot tables and slicers, Excel 2016 or later is recommended.

How much time per week should I plan?

At 3 hours a week you finish in about 5 weeks. At 1 hour a day, in just over 2 weeks.

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.

Tags:#Excel training#Saint-Louis#pivot tables#Excel formulas#Excel certificate#Kolonell Academy
Share:

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.