At work, the tools never operate alone: the report reuses the Excel figures, the presentation reuses the report, and everything travels by email in ten versions. This course is for assistants, project officers, sales staff, NGO and public sector officers who already know the basics of Word and Excel. It teaches you to chain the whole suite together, work with others on the same file and present a clear result to management.
You first set up the shared workspace (OneDrive, SharePoint, Teams, versions), automate Word with templates, mail merge and forms, then consolidate Excel data from several sources with Power Query. Four modules then focus on PowerPoint: the message, on-brand layout, useful visuals and presenting in the room or on a video call. The last module links Word, Excel, PowerPoint and Outlook, Copilot included.
The course covers 22 hours, 8 modules, 40 lessons and 96 exercises. Above all, every module ends with a project graded against a rubric: 8 projects in total that add up to a real portfolio. A Kolonell certificate, verifiable online, is included.
You leave with a mail merge of 30 personalized letters, a consolidation workbook fed by Power Query, your on-brand PowerPoint template, a presentation with linked Excel charts, a video recording of a 7-minute presentation and a complete, linked Word, Excel and PowerPoint monthly pack. These skills are frequently required for assistant, project officer and reporting roles in Dakar and Abidjan, generally paid between 250,000 and 450,000 FCFA gross per month depending on experience. As a freelancer, a professional presentation is commonly billed at 25,000 to 100,000 FCFA and an on-brand template at 50,000 to 150,000 FCFA (2026 market rates; no income is guaranteed).
Level 4 of 5 in the Office and productivity track: it builds on Practical Excel and prepares level 5, Executive Assistant, which turns these tools into a profession.