The workbook that tracks your sales, your stock and your budget, and answers your manager's question in thirty seconds
Excel often makes the difference when you apply for a job or a promotion: in Dakar, an assistant or manager who is comfortable with PivotTables and XLOOKUP typically earns between 180,000 and 350,000 FCFA (about $300 to $580) gross per month depending on the sector, close to the average formal-sector salary in Dakar (280,000 to 350,000 FCFA, about $470 to $580, in 2026). As a freelancer, building a custom management workbook for a shop or an SME is commonly billed at 30,000 to 150,000 FCFA (about $50 to $250) (rates observed in 2026; no income is guaranteed).
Indicative estimate, depending on your market, pace and work. No income is guaranteed.
Who it is for: Administrative assistants, junior accountants, stock managers, sales staff, shop managers, NGO officers and entrepreneurs who keep track of numbers (sales, cash, stock, budget, payroll) and want to move from a notebook or a calculator to a reliable workbook.
A module-by-module path: lessons, exercises, quizzes and projects to submit.
Module 1· 12 exercises
Enter clean data from the start, so that every calculation and every analysis that follows is correct.
Module 2· 12 exercises
Calculate totals, averages, margins and VAT without ever retyping a result by hand.
Module 3· 12 exercises
Let Excel make decisions for you and find information in a list with a single formula.
Module 4· 12 exercises
Control data entry, find the information that matters and see at a glance what is going wrong.
Module 5· 12 exercises
Summarize thousands of rows and present a trend in a chart that everyone understands.
Module 6· 12 exercises
Assemble the Excel tools a shop or an SME uses every day, then print, protect and share them.
Certificate included
A numbered certificate with your validated skills, a public page and a verification QR code. Add it to LinkedIn in one click.
Certificate of skills
Your name
has completed and validated the course
Practical Excel: tables, formulas and analysis for work
Certified skills
Number KOL-CERT-2026-XXXXX
Mohamed Bah
Founder, Kolonell Academy
Download the poster to print it, send it to your employer or share it with colleagues. The full programme details every module.
This course is part of the track
Level 3 of 5 · Advanced
See the 5 track levelsNext level · 4/5 Career
The full job, with a portfolio
The complete monthly pack, Word report, Excel workbook and PowerPoint presentation, produced in half a day instead of three days
100,000 FCFA 22 h
View the next levelYour instructor
Founder of Kolonell, a digital agency in Dakar. A former chief technology officer, he has trained administrative and sales teams on office software and built business applications for SMEs in Senegal, Côte d'Ivoire and Dubai.
Both. The lessons are written for Excel and every significant difference with Google Sheets is pointed out. Google Sheets is free and is enough for 90% of the exercises.
Yes. The course only requires addition, multiplication and percentages. Every formula is explained on a concrete case in FCFA before it is generalized.
The lesson also covers VLOOKUP and the INDEX MATCH combination, which work in every version since Excel 2010 and in Google Sheets.
About 14 hours: nearly 8 hours of lessons, the exercises after each lesson and two projects (one hour for the pricing sheet, two and a half hours for the final workbook). At three sessions a week, allow four to five weeks.
It is recommended. Every practical exercise can be done on your real data or on the fictional files provided, as long as you do not share any customer's personal data.
Level 4, Complete Office suite, to make Word, Excel and PowerPoint work together and produce presentations for senior management.
Via Wave or Orange Money. After enrolling you receive a pro forma invoice by email with the number to pay. Send the proof on WhatsApp: your access is activated within 24 business hours.
For life, updates included. Learn at your own pace and revisit lessons as often as you need.
Complete the lessons and pass each module quiz with at least 70%. The certificate is generated automatically, with a unique number and a public verification page.
75,000 FCFA · 115 €
Advanced