Course Overview

Advanced Microsoft Office is a practical, hands-on course designed to develop advanced skills in Microsoft Word, Excel, PowerPoint, Outlook, and integrated Office applications. Participants will learn advanced data analysis, automation, professional document design, advanced presentations, collaboration, reporting, and productivity techniques that can be applied to complex workplace tasks and decision-making.

Target Participants

  • Professionals and administrators
  • Managers and supervisors
  • Executives and team leaders
  • Accountants and finance professionals
  • Data and business analysts
  • Project managers and officers
  • Human resource professionals
  • Entrepreneurs and business owners
  • Government and NGO employees
  • Participants with intermediate Microsoft Office skills

Course Objectives

By the end of the course, participants will be able to:

  • Apply advanced Microsoft Office features to improve workplace productivity.
  • Develop complex and professionally formatted Word documents.
  • Use advanced Excel formulas, functions, PivotTables, charts, and data-analysis tools.
  • Create interactive and executive-level PowerPoint presentations.
  • Apply advanced Outlook features for communication and time management.
  • Integrate data and content across Microsoft Office applications.
  • Automate repetitive tasks and improve workflow efficiency.
  • Develop professional management reports and dashboards.
  • Apply data visualization techniques to support decision-making.
  • Use Microsoft Office tools for complex real-world business applications.

Course Outline

Module 1: Advanced Microsoft Office Productivity

  • Advanced Office interface and customization
  • Keyboard shortcuts and productivity techniques
  • Templates and reusable resources
  • File management and collaboration
  • Microsoft 365 productivity features

Module 2: Advanced Microsoft Word

  • Advanced document formatting
  • Styles and customized templates
  • Automatic table of contents
  • Cross-references and captions
  • Advanced tables and document layouts
  • Track Changes and document collaboration
  • Mail merge
  • Professional reports and long documents

Module 3: Advanced Microsoft Excel

  • Advanced formulas and functions
  • IF, SUMIFS, COUNTIFS and lookup functions
  • XLOOKUP and INDEX/MATCH
  • Dynamic arrays
  • Data validation
  • Advanced conditional formatting
  • Advanced sorting and filtering
  • Excel Tables
  • Named ranges

Module 4: Excel Data Analysis and Reporting

  • PivotTables and PivotCharts
  • Advanced data summarization
  • Data cleaning and preparation
  • What-if analysis
  • Scenario analysis
  • Goal Seek
  • Advanced charts
  • Interactive dashboards
  • Management reporting

Module 5: Excel Automation

  • Introduction to Excel automation
  • Macros and VBA concepts
  • Recording and using macros
  • Automating repetitive tasks
  • Creating efficient reporting workflows
  • Practical automation applications

Module 6: Advanced Microsoft PowerPoint

  • Professional presentation design
  • Master slides and templates
  • Advanced animations and transitions
  • Interactive presentations
  • Charts, SmartArt, and multimedia
  • Executive dashboards and presentations
  • Presentation delivery techniques

Module 7: Advanced Microsoft Outlook

  • Advanced email management
  • Rules and automated email organization
  • Calendar and meeting management
  • Tasks and follow-up systems
  • Contact management
  • Email productivity techniques

Module 8: Microsoft Office Integration

  • Linking Excel data to Word
  • Embedding Excel charts in PowerPoint
  • Importing and exporting data
  • Integrating Office applications
  • Collaborative document workflows
  • Sharing and co-authoring documents

Module 9: Microsoft 365 and Cloud Collaboration

  • OneDrive and cloud storage
  • SharePoint fundamentals
  • Microsoft Teams integration
  • Real-time collaboration
  • Document sharing and permissions
  • Cloud-based productivity 

Course Schedules:

Dates Fees Location Apply
23/11/2026 - 27/11/2026 $4500 Pretoria, South Africa Physical Class Online Class
23/11/2026 - 27/11/2026 $1500 Nairobi, Kenya Physical Class Online Class
23/11/2026 - 27/11/2026 $2500 Kigali, Rwanda Physical Class Online Class
23/11/2026 - 27/11/2026 $2000 Mombasa, Kenya Physical Class Online Class
23/11/2026 - 27/11/2026 $6000 Mauritius Physical Class Online Class
23/11/2026 - 27/11/2026 $4000 Johannesburg, South Africa Physical Class Online Class
30/11/2026 - 04/12/2026 $6000 Mauritius Physical Class Online Class
30/11/2026 - 04/12/2026 $1500 Nairobi, Kenya Physical Class Online Class
30/11/2026 - 04/12/2026 $2500 Kigali, Rwanda Physical Class Online Class
30/11/2026 - 04/12/2026 $2500 Dar es Salaam, Tanzania Physical Class Online Class
07/12/2026 - 11/12/2026 $5000 Singapore, Singapore Physical Class Online Class
07/12/2026 - 11/12/2026 $1500 Nairobi, Kenya Physical Class Online Class
07/12/2026 - 11/12/2026 $5000 Dubai, UAE Physical Class Online Class
14/12/2026 - 18/12/2026 $4000 Johannesburg, South Africa Physical Class Online Class
14/12/2026 - 18/12/2026 $4500 Pretoria, South Africa Physical Class Online Class
14/12/2026 - 18/12/2026 $1500 Nairobi, Kenya Physical Class Online Class
14/12/2026 - 18/12/2026 $2000 Mombasa, Kenya Physical Class Online Class
21/12/2026 - 25/12/2026 $4500 Pretoria, South Africa Physical Class Online Class
21/12/2026 - 25/12/2026 $1500 Nairobi, Kenya Physical Class Online Class
28/12/2026 - 01/01/2027 $1500 Nairobi, Kenya Physical Class Online Class
28/12/2026 - 01/01/2027 $2000 Mombasa, Kenya Physical Class Online Class
28/12/2026 - 01/01/2027 $2500 Kigali, Rwanda Physical Class Online Class
28/12/2026 - 01/01/2027 $5000 Dubai, UAE Physical Class Online Class
28/12/2026 - 01/01/2027 $2500 Dar es Salaam, Tanzania Physical Class Online Class
04/01/2027 - 08/01/2027 $1500 Nairobi, Kenya Physical Class Online Class
04/01/2027 - 08/01/2027 $4000 Johannesburg, South Africa Physical Class Online Class
11/01/2027 - 15/01/2027 $2500 Dar es Salaam, Tanzania Physical Class Online Class
11/01/2027 - 15/01/2027 $6000 Mauritius Physical Class Online Class
11/01/2027 - 15/01/2027 $1500 Nairobi, Kenya Physical Class Online Class
11/01/2027 - 15/01/2027 $5000 Singapore, Singapore Physical Class Online Class
18/01/2027 - 22/01/2027 $4000 Johannesburg, South Africa Physical Class Online Class
18/01/2027 - 22/01/2027 $1500 Nairobi, Kenya Physical Class Online Class
18/01/2027 - 22/01/2027 $2500 Kigali, Rwanda Physical Class Online Class
25/01/2027 - 29/01/2027 $2000 Mombasa, Kenya Physical Class Online Class
25/01/2027 - 29/01/2027 $6000 Mauritius Physical Class Online Class
25/01/2027 - 29/01/2027 $1500 Nairobi, Kenya Physical Class Online Class
25/01/2027 - 29/01/2027 $5000 Singapore, Singapore Physical Class Online Class
25/01/2027 - 29/01/2027 $5000 Dubai, UAE Physical Class Online Class
01/02/2027 - 05/02/2027 $5000 Dubai, UAE Physical Class Online Class
01/02/2027 - 05/02/2027 $2500 Dar es Salaam, Tanzania Physical Class Online Class
01/02/2027 - 05/02/2027 $4500 Pretoria, South Africa Physical Class Online Class
01/02/2027 - 05/02/2027 $1500 Nairobi, Kenya Physical Class Online Class
08/02/2027 - 12/02/2027 $1500 Nairobi, Kenya Physical Class Online Class
08/02/2027 - 12/02/2027 $4000 Johannesburg, South Africa Physical Class Online Class
15/02/2027 - 19/02/2027 $1500 Nairobi, Kenya Physical Class Online Class
15/02/2027 - 19/02/2027 $2000 Mombasa, Kenya Physical Class Online Class
15/02/2027 - 19/02/2027 $4500 Pretoria, South Africa Physical Class Online Class
15/02/2027 - 19/02/2027 $2500 Kigali, Rwanda Physical Class Online Class
15/02/2027 - 19/02/2027 $5000 Singapore, Singapore Physical Class Online Class
22/02/2027 - 26/02/2027 $2500 Dar es Salaam, Tanzania Physical Class Online Class
22/02/2027 - 26/02/2027 $1500 Nairobi, Kenya Physical Class Online Class
22/02/2027 - 26/02/2027 $6000 Mauritius Physical Class Online Class
01/03/2027 - 05/03/2027 $5000 Singapore, Singapore Physical Class Online Class
01/03/2027 - 05/03/2027 $5000 Dubai, UAE Physical Class Online Class
01/03/2027 - 05/03/2027 $1500 Nairobi, Kenya Physical Class Online Class
01/03/2027 - 05/03/2027 $6000 Mauritius Physical Class Online Class
01/03/2027 - 05/03/2027 $4000 Johannesburg, South Africa Physical Class Online Class
08/03/2027 - 12/03/2027 $2000 Mombasa, Kenya Physical Class Online Class
08/03/2027 - 12/03/2027 $1500 Nairobi, Kenya Physical Class Online Class
15/03/2027 - 19/03/2027 $1500 Nairobi, Kenya Physical Class Online Class
15/03/2027 - 19/03/2027 $2500 Kigali, Rwanda Physical Class Online Class
15/03/2027 - 19/03/2027 $5000 Dubai, UAE Physical Class Online Class
15/03/2027 - 19/03/2027 $4500 Pretoria, South Africa Physical Class Online Class
22/03/2027 - 26/03/2027 $4500 Pretoria, South Africa Physical Class Online Class
22/03/2027 - 26/03/2027 $1500 Nairobi, Kenya Physical Class Online Class
22/03/2027 - 26/03/2027 $2500 Dar es Salaam, Tanzania Physical Class Online Class
22/03/2027 - 26/03/2027 $2000 Mombasa, Kenya Physical Class Online Class
29/03/2027 - 02/04/2027 $1500 Nairobi, Kenya Physical Class Online Class
29/03/2027 - 02/04/2027 $6000 Mauritius Physical Class Online Class
05/04/2027 - 09/04/2027 $1500 Nairobi, Kenya Physical Class Online Class
12/04/2027 - 16/04/2027 $4000 Johannesburg, South Africa Physical Class Online Class
12/04/2027 - 16/04/2027 $2500 Kigali, Rwanda Physical Class Online Class
12/04/2027 - 16/04/2027 $5000 Singapore, Singapore Physical Class Online Class
12/04/2027 - 16/04/2027 $5000 Dubai, UAE Physical Class Online Class
12/04/2027 - 16/04/2027 $1500 Nairobi, Kenya Physical Class Online Class
19/04/2027 - 23/04/2027 $1500 Nairobi, Kenya Physical Class Online Class
19/04/2027 - 23/04/2027 $2000 Mombasa, Kenya Physical Class Online Class
19/04/2027 - 23/04/2027 $6000 Mauritius Physical Class Online Class
19/04/2027 - 23/04/2027 $4000 Johannesburg, South Africa Physical Class Online Class
19/04/2027 - 23/04/2027 $5000 Singapore, Singapore Physical Class Online Class
26/04/2027 - 30/04/2027 $1500 Nairobi, Kenya Physical Class Online Class
26/04/2027 - 30/04/2027 $4500 Pretoria, South Africa Physical Class Online Class
26/04/2027 - 30/04/2027 $2500 Dar es Salaam, Tanzania Physical Class Online Class
03/05/2027 - 07/05/2027 $1500 Nairobi, Kenya Physical Class Online Class
03/05/2027 - 07/05/2027 $2500 Kigali, Rwanda Physical Class Online Class
03/05/2027 - 07/05/2027 $5000 Dubai, UAE Physical Class Online Class
10/05/2027 - 14/05/2027 $1500 Nairobi, Kenya Physical Class Online Class
10/05/2027 - 14/05/2027 $5000 Singapore, Singapore Physical Class Online Class
17/05/2027 - 21/05/2027 $2500 Dar es Salaam, Tanzania Physical Class Online Class
17/05/2027 - 21/05/2027 $2000 Mombasa, Kenya Physical Class Online Class
17/05/2027 - 21/05/2027 $4000 Johannesburg, South Africa Physical Class Online Class
17/05/2027 - 21/05/2027 $1500 Nairobi, Kenya Physical Class Online Class
24/05/2027 - 28/05/2027 $5000 Dubai, UAE Physical Class Online Class
24/05/2027 - 28/05/2027 $6000 Mauritius Physical Class Online Class
24/05/2027 - 28/05/2027 $4500 Pretoria, South Africa Physical Class Online Class
24/05/2027 - 28/05/2027 $2500 Kigali, Rwanda Physical Class Online Class
24/05/2027 - 28/05/2027 $1500 Nairobi, Kenya Physical Class Online Class
31/05/2027 - 04/06/2027 $1500 Nairobi, Kenya Physical Class Online Class
31/05/2027 - 04/06/2027 $2500 Dar es Salaam, Tanzania Physical Class Online Class
31/05/2027 - 04/06/2027 $6000 Mauritius Physical Class Online Class
31/05/2027 - 04/06/2027 $5000 Singapore, Singapore Physical Class Online Class
07/06/2027 - 11/06/2027 $1500 Nairobi, Kenya Physical Class Online Class
07/06/2027 - 11/06/2027 $4500 Pretoria, South Africa Physical Class Online Class
07/06/2027 - 11/06/2027 $2500 Kigali, Rwanda Physical Class Online Class
14/06/2027 - 18/06/2027 $2000 Mombasa, Kenya Physical Class Online Class
14/06/2027 - 18/06/2027 $1500 Nairobi, Kenya Physical Class Online Class
14/06/2027 - 18/06/2027 $4000 Johannesburg, South Africa Physical Class Online Class
21/06/2027 - 25/06/2027 $1500 Nairobi, Kenya Physical Class Online Class
21/06/2027 - 25/06/2027 $6000 Mauritius Physical Class Online Class
28/06/2027 - 02/07/2027 $5000 Dubai, UAE Physical Class Online Class
28/06/2027 - 02/07/2027 $1500 Nairobi, Kenya Physical Class Online Class
28/06/2027 - 02/07/2027 $4500 Pretoria, South Africa Physical Class Online Class
05/07/2027 - 09/07/2027 $5000 Singapore, Singapore Physical Class Online Class
05/07/2027 - 09/07/2027 $1500 Nairobi, Kenya Physical Class Online Class
05/07/2027 - 09/07/2027 $2500 Dar es Salaam, Tanzania Physical Class Online Class
12/07/2027 - 16/07/2027 $2500 Kigali, Rwanda Physical Class Online Class
12/07/2027 - 16/07/2027 $1500 Nairobi, Kenya Physical Class Online Class
12/07/2027 - 16/07/2027 $2000 Mombasa, Kenya Physical Class Online Class
12/07/2027 - 16/07/2027 $4000 Johannesburg, South Africa Physical Class Online Class
19/07/2027 - 23/07/2027 $4000 Johannesburg, South Africa Physical Class Online Class
19/07/2027 - 23/07/2027 $1500 Nairobi, Kenya Physical Class Online Class
26/07/2027 - 30/07/2027 $4500 Pretoria, South Africa Physical Class Online Class
26/07/2027 - 30/07/2027 $5000 Dubai, UAE Physical Class Online Class
26/07/2027 - 30/07/2027 $2500 Dar es Salaam, Tanzania Physical Class Online Class
26/07/2027 - 30/07/2027 $1500 Nairobi, Kenya Physical Class Online Class
26/07/2027 - 30/07/2027 $6000 Mauritius Physical Class Online Class
02/08/2027 - 06/08/2027 $2500 Kigali, Rwanda Physical Class Online Class
02/08/2027 - 06/08/2027 $5000 Singapore, Singapore Physical Class Online Class
02/08/2027 - 06/08/2027 $5000 Dubai, UAE Physical Class Online Class
02/08/2027 - 06/08/2027 $2000 Mombasa, Kenya Physical Class Online Class
02/08/2027 - 06/08/2027 $2500 Dar es Salaam, Tanzania Physical Class Online Class
02/08/2027 - 06/08/2027 $1500 Nairobi, Kenya Physical Class Online Class
09/08/2027 - 13/08/2027 $1500 Nairobi, Kenya Physical Class Online Class
09/08/2027 - 13/08/2027 $4000 Johannesburg, South Africa Physical Class Online Class
16/08/2027 - 20/08/2027 $6000 Mauritius Physical Class Online Class
16/08/2027 - 20/08/2027 $1500 Nairobi, Kenya Physical Class Online Class
16/08/2027 - 20/08/2027 $2500 Kigali, Rwanda Physical Class Online Class
16/08/2027 - 20/08/2027 $5000 Singapore, Singapore Physical Class Online Class
16/08/2027 - 20/08/2027 $2000 Mombasa, Kenya Physical Class Online Class
23/08/2027 - 27/08/2027 $4500 Pretoria, South Africa Physical Class Online Class
23/08/2027 - 27/08/2027 $1500 Nairobi, Kenya Physical Class Online Class
23/08/2027 - 27/08/2027 $5000 Dubai, UAE Physical Class Online Class
30/08/2027 - 03/09/2027 $2500 Dar es Salaam, Tanzania Physical Class Online Class
30/08/2027 - 03/09/2027 $6000 Mauritius Physical Class Online Class
30/08/2027 - 03/09/2027 $4500 Pretoria, South Africa Physical Class Online Class
30/08/2027 - 03/09/2027 $1500 Nairobi, Kenya Physical Class Online Class
06/09/2027 - 10/09/2027 $2000 Mombasa, Kenya Physical Class Online Class
06/09/2027 - 10/09/2027 $1500 Nairobi, Kenya Physical Class Online Class
13/09/2027 - 17/09/2027 $4000 Johannesburg, South Africa Physical Class Online Class
13/09/2027 - 17/09/2027 $2500 Kigali, Rwanda Physical Class Online Class
13/09/2027 - 17/09/2027 $5000 Singapore, Singapore Physical Class Online Class
13/09/2027 - 17/09/2027 $1500 Nairobi, Kenya Physical Class Online Class
20/09/2027 - 24/09/2027 $1500 Nairobi, Kenya Physical Class Online Class
20/09/2027 - 24/09/2027 $2500 Dar es Salaam, Tanzania Physical Class Online Class
20/09/2027 - 24/09/2027 $6000 Mauritius Physical Class Online Class
20/09/2027 - 24/09/2027 $5000 Singapore, Singapore Physical Class Online Class
27/09/2027 - 01/10/2027 $1500 Nairobi, Kenya Physical Class Online Class
27/09/2027 - 01/10/2027 $2000 Mombasa, Kenya Physical Class Online Class
27/09/2027 - 01/10/2027 $4000 Johannesburg, South Africa Physical Class Online Class
27/09/2027 - 01/10/2027 $2500 Kigali, Rwanda Physical Class Online Class
27/09/2027 - 01/10/2027 $5000 Dubai, UAE Physical Class Online Class
04/10/2027 - 08/10/2027 $1500 Nairobi, Kenya Physical Class Online Class
04/10/2027 - 08/10/2027 $4500 Pretoria, South Africa Physical Class Online Class