By Mohamed Bah · Kolonell, a digital agency in Dakar
The workbook that tracks your sales, your stock and your budget, and answers your manager's question in thirty seconds
75,000 FCFA · 115 €
Programme
and 1 more module
Wave / Orange Money payment, access within 24 business hours
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.
Your 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.
See Kolonell’s work →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, pass each module quiz with at least 70% and submit your final project: an instructor reviews and approves it (feedback within 5 working days). The certificate is then generated, with a unique number and a public verification page.
The cash count never balances, the stock on screen does not match the storeroom, and every month you redo the totals on a calculator. This course is for assistants, junior accountants, stock managers, sales staff, shop managers, NGO officers and entrepreneurs who keep track of numbers. It turns your digital notebooks into reliable workbooks that calculate on their own and answer your manager's question in thirty seconds.
You first learn to build a clean table, then the essential formulas, absolute references, percentages and 18% VAT. Next come the functions that decide and look things up for you (IF, COUNTIF, SUMIFS, XLOOKUP), along with sorting, filters, drop-down lists and conditional formatting. You finish with PivotTables, charts and ready-to-use management tools, in Excel as well as Google Sheets.
Expect 14 hours, 6 modules, 30 lessons and 72 exercises, all built on local cases in FCFA: a shop in Thiès, a pharmacy in Bamako, a wholesaler in Cotonou. Two projects graded against a rubric have you build real tools: an automated pricing and sales workbook, then the complete management workbook of an SME. A Kolonell certificate, verifiable online, is included.
By the end, you have a controlled sales log, a stock sheet with stock-out alerts, an invoice template that finds the price and the customer by itself, a planned versus actual budget and a PivotTable analysis. In Dakar, an assistant or manager comfortable with PivotTables and XLOOKUP typically earns between 180,000 and 350,000 FCFA gross per month depending on the sector; as a freelancer, a custom management workbook is commonly billed at 30,000 to 150,000 FCFA (rates observed in 2026; no income is guaranteed).
Level 3 of 5 in the Office and productivity track: it builds on Professional Word and prepares level 4, Complete Office suite, where Word, Excel and PowerPoint work together.
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
Skills developed
Number KOL-CERT-2026-XXXXX
Mohamed Bah
Founder, Kolonell Academy
After the course
Each certificate has a number anyone can verify online, and you can add it to your LinkedIn profile in one click.
Upload your CV from your profile: our team reviews it and helps you make it clearer and more convincing.
Learners who complete the course can join the Kolonell talent pool. Entry is earned: course completed, exercises submitted. Kolonell also draws on it for its own hiring.
Optional services, free for learners. This is not a promise of employment.
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 level