Certificate in ICT
This certificate program delivers hands-on training in Microsoft Office, preparing students to manage data, create professional presentations, and automate workflows. It emphasizes data logic and effective communication, teaching integration across tools such as using Excel data in Word reports or linking Access databases to automated mailing systems.
Career Relevance
The "Gold Standard": In 2026, MS Office proficiency is the most requested "baseline" skill in over 90% of white-collar job postings.
Administrative to Analytical: This course moves a student from being a "typist" to a Data Coordinator, which typically sees a 20% higher salary bracket.
Universal Applicability: Whether you work in a hospital, a law firm, a construction site, or a tech startup, these four tools are the universal language of business operations.
Schedule
Pricing
Curriculum Highlights
- Module 1: Microsoft Word (Expert Authoring) Focus: Mastering long-form documents and corporate branding.
- Unit 1.1: Advanced Formatting & Styles: Using the Style Pane to manage hierarchy and automated formatting.
- Unit 1.2: References & Citations: Generating automated Tables of Contents Footnotes and Bibliographies for research or legal papers.
- Unit 1.3: Mail Merge & Envelopes: Connecting Word to Excel/Access lists to generate 1000+ personalized letters or labels in seconds.
- Unit 1.4: Reviewing & Security: Tracking changes comparing two versions of a document and restricting editing permissions.
- Module 2: Microsoft Excel (Data Analytics) Focus: Turning rows of data into business intelligence.
- Unit 2.1: Advanced Formula Logic: Deep dive into XLOOKUP IF/THEN/ELSE and SUMIFS.
- Unit 2.2: Data Cleaning & Validation: Using "Data Validation" to create dropdown menus and "Remove Duplicates" to ensure data integrity.
- Unit 2.3: Pivot Tables & Slicers: Summarizing 10000+ rows of data into a one-page interactive report.
- Unit 2.4: Basic Automation (Macros): Recording simple mouse and keyboard actions to automate daily repetitive reports.
- Module 3: Microsoft PowerPoint (Visual Storytelling) Focus: Creating cinematic high-retention presentations.
- Unit 3.2: Interactive Navigation: Using "Zoom" and "Hyperlinks" to create non-linear presentations (where you can click to jump to any section).
- Unit 3.3: Multimedia Mastery: Embedding live web videos 3D models and screen recordings directly into slides.
- Unit 3.4: The Morph Transition: Using AI-driven transitions to create professional animations without complex video editing software.
- Module 4: Microsoft Access (Relational Databases) Focus: Organizing data that is too large or complex for Excel.
- Unit 4.1: Table Architecture: Understanding Primary Keys Foreign Keys and "One-to-Many" relationships.
- Unit 4.2: Query Design: Using the Query Wizard to ask questions (e.g. "Show me all customers who spent over $500 in March").
- Unit 4.3: Form Design: Building user-friendly "Entry Screens" so that non-technical staff can enter data without breaking the database.
- Unit 4.4: Report Generation: Creating professional printable summaries of database info that include totals averages and branding.
Learning Outcomes
- By the end of this certificate the student will be able to: Automate standard business correspondence using advanced Word features. Analyze complex datasets in Excel to provide "What-If" scenarios for management. Construct a fully functional relational database in Access to track inventory or personnel. Design high-stakes presentations that integrate live data and interactive motion. Troubleshoot common software integration issues (e.g. importing Access data into an Excel Pivot Table).
Ready to Join?
Please login or register to apply for this program.
Your Program Instructor
Abdullahi Bichi Shuaibu
Senior Data Scientist and Developer
As a Senior Data Scientist and Computer Scientist, I operate at the high-impact intersection of rigorous statistical analysis and scalable full-stack ...