The verdict in three sentences
In a 400-pupil private school in Yamoussoukro, tracking school fees, unpaid balances and teacher pay by hand takes several days per term and lets money slip away. A well-built Excel workbook answers the founder's question in thirty seconds: "who owes how much, and since when?". Kolonell Academy's Practical Excel course (level 3, 14 h, 75,000 FCFA) teaches you to build that workbook with reliable formulas and pivot tables.
The bursar's notebook versus the spreadsheet
The bursar of a private school manages three overlapping flows: fee payments by instalment (often three instalments between October and March), reminders to families in arrears and salaries of part-time or permanent teachers. In a notebook, every check means recounting everything. In a workbook, a SUMIFS or XLOOKUP formula gives the answer instantly.
| Bursar task | Notebook or calculator | Structured Excel workbook |
|---|---|---|
| Balance of each pupil | 2 to 3 days per term | Automatic calculation on each entry |
| Unpaid list by class | Manual copying, frequent errors | Filter in 10 seconds |
| Reminders to families | List redone each time | Conditional formatting in red |
| Part-time teacher pay (hours x rate) | Calculator, risk of omission | Formula per teacher, checked total |
| Report for the founder | Table copied out at the weekend | Pivot table and chart in 5 minutes |
| Finding an old receipt | Leafing through registers | Search by name or ID number |
In many schools, unpaid fees represent 10 to 20 % of expected fees (2026 order of magnitude). For a 400-pupil school at 150,000 FCFA a year, that is 6 to 12 million FCFA to track pupil by pupil. A reminder delayed by one term weighs directly on the cash that pays the teachers.
What you learn and what it costs
The course Practical Excel: tables, formulas and analysis for work, taught in French, runs in six modules: building a clean table, essential formulas (absolute references, percentages, 18 % VAT), logical and lookup functions, sorting, filtering and making data talk, pivot tables and charts, then ready-to-use management tools. It works with Excel as well as Google Sheets.
| Option in Yamoussoukro | Indicative 2026 price | Format | Main limitation |
|---|---|---|---|
| Free online tutorials | 0 FCFA (plus data) | Isolated videos | No school case or corrected exercises |
| Classroom training (local centre or Abidjan) | 80,000 to 150,000 FCFA | 2 to 5 fixed days | Hard to fit in during back-to-school |
| Kolonell Academy, level 3 Excel | 75,000 FCFA (about 115 EUR / 125 USD) | 14 h, at your own pace | Requires personal discipline |
| Full Office track (5 levels) | 350,000 FCFA instead of 450,000 (about 534 EUR) | Several months | Higher upfront investment |
Enrollment is paid with Wave or Orange Money. This level 3 is part of the Office and productivity track: if you are starting further back, levels 1 (computer and email) and 2 (Word) prepare the ground.
What Excel skills are worth for a bursar
The pay levels below are 2026 orders of magnitude in Côte d'Ivoire, not promises. They depend on the size of the school and your responsibilities.
| Position in a private school | Indicative monthly salary | Role of Excel in the job |
|---|---|---|
| Cashier / school secretariat | 100,000 to 150,000 FCFA | Recording payments |
| Primary school bursar | 150,000 to 220,000 FCFA | Tracking fees and arrears |
| Secondary school bursar | 200,000 to 300,000 FCFA | Budget, payroll, reports to the founder |
| Accountant of a school group | 250,000 to 400,000 FCFA | Analysis, dashboards |
| One-off assignment setting up a workbook | 50,000 to 150,000 FCFA per school | Freelance service |
A bursar who produces a clear monthly table of arrears becomes the founder's trusted contact, which counts at salary reviews or when applying to a school group.
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.
Aminata, 34, is bursar of a 420-pupil private secondary school in Yamoussoukro, paid 210,000 FCFA a month. She spends about 3 days per term recalculating balances and preparing the reminder list. After the course (75,000 FCFA, 14 h spread over three weeks), she builds a workbook: a pupils tab, a payments tab, a pivot table by class.
Calculation: her 3 days per term drop to half a day, about 7.5 days saved over the school year. Above all, if faster reminders recover just 1 % of the 63 million FCFA in annual fees (420 x 150,000 FCFA), that is 630,000 FCFA collected, more than eight times the price of the course. These are illustrative assumptions; the real gain depends on the school.
FAQ
Do I need to know Excel already?
Yes, a minimum: it is an intermediate level 3. If you can open a workbook and enter figures, the 14 h are enough; otherwise start with level 1 at 25,000 FCFA.
Can I work in Google Sheets instead of Excel?
Yes, the exercises work in both. Google Sheets is free and can be shared with the founder, handy when the school has no Microsoft 365 licence (about 7,000 FCFA per user per month).
Is the school fees workbook provided?
The last module offers ready-to-use management tools that you adapt to your instalments, classes and fees. Allow 2 to 3 hours of adaptation for one school.
How do I pay for enrollment?
The 75,000 FCFA is paid with Wave or Orange Money, from Yamoussoukro or any city in Côte d'Ivoire.
What certificate do I get?
A Kolonell Academy certificate verifiable online, issued after the quizzes of the six modules. The full 5-level track costs 350,000 FCFA instead of 450,000.
Take the next step. Enroll in Practical Excel: tables, formulas and analysis for work: 14 h at your own pace, taught in French, 75,000 FCFA (about 115 EUR), verifiable 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.
