✕
ICT & Digital Skills

Productivity Software: Microsoft Office Suite Training

This intensive Microsoft Office Suite training programme equips professionals with practical, job-ready skills across Word, Excel, PowerPoint, Outlook, and Teams. Participants progress from core document and data management techniques to advanced automation, collaboration, and reporting capabilities. By the end of the course, delegates will confidently use the Office Suite to boost personal productivity and deliver higher-quality outputs in their daily roles.

⏱ 5 Days 📡 In-Person 🎯 All Levels From KES 80,000

About This Course

In today's fast-paced workplace, proficiency in the Microsoft Office Suite is no longer optional — it is a baseline expectation for virtually every professional role. Yet many employees use only a fraction of the tools available to them, relying on manual workarounds where automation exists and missing collaboration features that could save hours every week. This course bridges that gap by providing structured, hands-on training across the full Office ecosystem.

Designed for working professionals across all sectors, the Microsoft Office Suite Training programme covers the five core applications that drive business productivity: Word, Excel, PowerPoint, Outlook, and Microsoft Teams. Each application is explored in depth, with a clear focus on real workplace tasks — from drafting polished reports and building dynamic dashboards to delivering compelling presentations and managing team communication efficiently.

TrainingComplex has designed this programme around practical application rather than passive instruction. Participants work through realistic business scenarios, complete guided exercises using their own or sample organisational data, and leave each session with templates and techniques they can deploy immediately. The course is structured to benefit both beginners building foundational confidence and intermediate users looking to close skill gaps and unlock advanced features.

Upon completion, participants will hold a TrainingComplex Certificate of Completion in Microsoft Office Suite Productivity, demonstrating verified competence across all major Office applications. Organisations that invest in this training consistently report measurable improvements in document quality, reduced rework, faster report generation, and stronger cross-team collaboration.

Who Should Attend

Learning Objectives

Course Modules

Module 1: Navigating the Microsoft 365 Ecosystem

  • Overview of Microsoft 365 applications and how they interconnect
  • The Microsoft 365 interface: ribbon, quick access toolbar, and backstage view
  • File management best practices: naming conventions, folder structures, and OneDrive storage
  • Version history, AutoSave, and document recovery in Microsoft 365
  • Accessibility features and keyboard shortcuts for improved efficiency
  • Setting up your Microsoft 365 environment for maximum personal productivity

Module 2: Microsoft Word — Document Foundations

  • Formatting text and paragraphs with consistency using styles and themes
  • Working with page layout: margins, sections, headers, footers, and page numbers
  • Inserting and formatting tables, images, SmartArt, and shapes
  • Using the Navigation Pane and Outline View for long documents
  • Track Changes, comments, and document review workflows for collaborative editing
  • Protecting and restricting documents with passwords and editing permissions

Module 3: Microsoft Word — Advanced Document Production

  • Creating and managing heading styles for automatic table of contents generation
  • Mail merge for bulk letters, labels, certificates, and email campaigns
  • Building and reusing custom templates for organisational consistency
  • Cross-references, bookmarks, footnotes, and endnotes in formal reports
  • Working with fields and content controls for dynamic, fillable documents
  • Finalising documents: inspecting, accessibility-checking, and converting to PDF

Module 4: Microsoft Excel — Spreadsheet Fundamentals

  • Workbook structure: sheets, rows, columns, cells, and named ranges
  • Data entry best practices: number formats, date handling, and data types
  • Essential formulas: SUM, AVERAGE, COUNT, IF, and nested IF statements
  • Absolute versus relative cell references and when to use each
  • Sorting, filtering, and using tables to manage structured data efficiently
  • Basic charts: selecting the right chart type and formatting for clarity

Module 5: Microsoft Excel — Intermediate Functions and Data Analysis

  • Lookup functions: VLOOKUP, HLOOKUP, and the modern XLOOKUP
  • INDEX and MATCH for flexible, robust data retrieval
  • Conditional formatting to highlight trends, exceptions, and key data points
  • Data validation: drop-down lists, input restrictions, and error alerts
  • Text functions: CONCATENATE, LEFT, RIGHT, MID, TRIM, and TEXT for data cleaning
  • Date and time functions for project tracking, ageing analysis, and scheduling

Module 6: Microsoft Excel — PivotTables, Dashboards, and Automation

  • Building PivotTables and PivotCharts to summarise large datasets dynamically
  • Grouping, filtering, and slicing PivotTable data for interactive reporting
  • Designing professional dashboards using linked charts, slicers, and named ranges
  • Recording, editing, and running macros to automate repetitive tasks
  • Introduction to basic VBA: understanding and modifying recorded macro code
  • Protecting workbooks and worksheets: locking cells, hiding formulas, and setting permissions

Module 7: Microsoft PowerPoint — Presentation Design Principles

  • Understanding slide masters and layouts for consistent branded presentations
  • Designing for clarity: applying colour theory, typography, and whitespace principles
  • Working with images, icons, SmartArt, and custom shapes effectively
  • Animations and transitions: when to use them and how to keep them professional
  • Embedding and linking live Excel charts and tables into PowerPoint slides
  • Presenter View: using speaker notes, rehearsing timings, and managing slide shows

Module 8: Microsoft PowerPoint — Advanced Storytelling and Delivery

  • Structuring a business presentation: opening hook, problem-solution flow, and call to action
  • Transforming data into visual stories using infographics and custom charts
  • Working with video, audio, and screen recordings within PowerPoint
  • Creating handouts, exporting to PDF, and publishing presentations to the web
  • Collaborating on presentations in real time using co-authoring and version control
  • Preparing for hybrid audiences: presenting effectively to both in-room and remote participants

Module 9: Microsoft Outlook — Professional Email and Calendar Management

  • Composing professional emails: formatting, signatures, and etiquette best practices
  • Organising your inbox with folders, categories, rules, and the Focused Inbox
  • Calendar mastery: scheduling meetings, managing recurring events, and sharing availability
  • Tasks and To-Do integration: managing personal action lists within Outlook
  • Managing contacts and distribution lists for efficient communication
  • Outlook security: recognising phishing, managing safe senders, and archiving email

Module 10: Microsoft Teams and Office Integration for Collaboration

  • Setting up and navigating Teams: channels, tabs, and team structure best practices
  • Conducting effective virtual meetings: breakout rooms, polls, and recording sessions
  • File collaboration in Teams: co-authoring Word and Excel files in real time
  • Integrating Teams with Outlook, SharePoint, and Planner for unified workflows
  • Cross-application productivity: linking Word to Excel, embedding objects, and using Paste Special
  • Building a personal Microsoft 365 productivity system: combining apps to manage tasks, communication, and deliverables seamlessly

Requirements & Prerequisites

Participants should have basic computer literacy, including the ability to create, save, and open files, and familiarity with using a keyboard and mouse. No prior formal training in Microsoft Office is required, though some everyday experience with one or more Office applications is helpful. Delegates should bring a laptop with Microsoft Office 2016 or later (or Microsoft 365) installed and activated for use during practical exercises.

Training Methodology

Organisational Benefits

Where Is Productivity Software: Microsoft Office Suite Training Offered?

This course runs in-person across: Nairobi, Zanzibar, Dubai, Nakuru, Abuja, Johannesburg, Kampala, Lagos, Mombasa, Kigali, Cape Town, Naivasha, Riyadh, Dar es Salaam, Arusha, Accra, Addis Ababa, Kisumu, Pretoria, plus Live Virtual (online) cohorts. Browse live dates for your city below.

Upcoming Schedules

LocationFormatDatesPrice
Nairobi, Kenya In-Person 5 Oct 2026 – 9 Oct 2026 KES 105,000
Zanzibar, Tanzania In-Person 5 Oct 2026 – 9 Oct 2026 USD 2,500
Dubai, United Arab Emirates In-Person 5 Oct 2026 – 9 Oct 2026 USD 4,100
Nakuru, Kenya In-Person 12 Oct 2026 – 16 Oct 2026 KES 115,000
Abuja, Nigeria In-Person 12 Oct 2026 – 16 Oct 2026 USD 2,800
Johannesburg, South Africa In-Person 19 Oct 2026 – 23 Oct 2026 USD 3,500
Kampala, Uganda In-Person 19 Oct 2026 – 23 Oct 2026 USD 1,900
Lagos, Nigeria In-Person 19 Oct 2026 – 23 Oct 2026 USD 2,500
Mombasa, Kenya In-Person 19 Oct 2026 – 23 Oct 2026 KES 120,000
Kigali, Rwanda In-Person 19 Oct 2026 – 23 Oct 2026 USD 1,900
Cape Town, South Africa In-Person 19 Oct 2026 – 23 Oct 2026 USD 3,800
Naivasha, Kenya In-Person 19 Oct 2026 – 23 Oct 2026 KES 115,000
Riyadh, Saudi Arabia In-Person 19 Oct 2026 – 23 Oct 2026 USD 4,500
Dar es Salaam, Tanzania In-Person 26 Oct 2026 – 30 Oct 2026 USD 2,300
Live Virtual Online 26 Oct 2026 – 30 Oct 2026 KES 80,000

+236 more dates — view live schedule →

Frequently Asked Questions

Do I need to have prior Microsoft Office training to attend this course?

No formal prior training is required. The course is designed to accommodate both beginners and intermediate users, starting with foundations and progressively building to advanced features. A basic level of computer literacy and some everyday use of Office applications will help you get the most from the programme.

What version of Microsoft Office do I need to have installed?

Participants should have Microsoft Office 2016, Office 2019, or Microsoft 365 installed and activated on their laptop. Microsoft 365 is recommended as it includes the latest features covered in the course, such as XLOOKUP and Microsoft Teams integration.

Will I receive a certificate after completing the course?

Yes. All participants who attend and complete the full five-day programme will receive a TrainingComplex Certificate of Completion in Microsoft Office Suite Productivity. This certificate can be shared on LinkedIn and added to your professional portfolio.

Is this course available online for remote participants?

Yes. TrainingComplex offers this programme in both in-person and live virtual formats. The virtual delivery mirrors the in-person experience, with live instructor-led sessions, interactive exercises, and real-time participant support throughout.

Will participants receive any course materials or resources to take away?

Yes. Every delegate receives a comprehensive digital workbook, all exercise files and datasets used during the training, a library of reusable templates for Word, Excel, and PowerPoint, and a Microsoft Office quick-reference guide. These resources are designed to support continued learning and immediate application after the course.

View Live Schedule & Book →