Office ICT Basic Skills Training Course

Introduction

The Office ICT Basic Skills Training Course is designed to equip participants with the foundational digital competencies needed to navigate common office tasks, enhance productivity, and communicate efficiently. Whether you are entering the workforce, changing careers, or looking to improve your existing skills, this course provides the essential toolkit for success in a modern office setting.

The course offers hands-on training in widely used software applications and digital tools, including word processing, spreadsheets, presentations, email management, and internet navigation. Participants will learn to create professional documents using Microsoft Word, organize and analyze data with Excel, and design impactful presentations using PowerPoint. Emphasis is placed on practical, real-world tasks such as formatting reports, using formulas, creating charts, and managing email correspondence.

In addition to software skills, the course introduces key concepts in file management, computer security, cloud storage, and basic troubleshooting. Learners will gain confidence in using digital devices and platforms responsibly and effectively. The training also emphasizes communication etiquette, collaboration tools (e.g., Zoom, Microsoft Teams, Google Workspace), and adapting to virtual work environments.

By the end of the course, participants will have developed a solid foundation in essential ICT skills required for administrative, clerical, and support roles across all sectors. They will be better prepared to contribute to office workflows, adapt to new technologies, and pursue further specialized training in ICT. This course is particularly valuable for those seeking to boost employability, re-enter the job market, or build a strong digital literacy base.

Duration

5 days

Course Objectives

By the end of this course the learners should be able to:

·       Demonstrate fundamental knowledge of computer hardware, software, and operating systems used in an office environment.

·       Create, edit, format, and manage professional documents using Microsoft Word or similar word processing software.

·       Use spreadsheet software such as Microsoft Excel to perform basic data entry, apply formulas, generate charts, and organize information.

·       Develop and deliver effective presentations using Microsoft PowerPoint or similar tools, incorporating visuals and animations.

·       Manage email communications professionally, including composing, sending, organizing, and archiving emails using platforms like Outlook or Gmail.

·       Navigate the internet safely and efficiently to search for information, access online tools, and use cloud-based applications.

·       Apply basic file management skills, including creating folders, saving and retrieving files, and using storage devices.

·       Understand and apply basic principles of cybersecurity, data privacy, and responsible digital behavior in an office setting.

·       Utilize online collaboration tools such as Zoom, Microsoft Teams, and Google Workspace for virtual meetings and teamwork.

·       Build confidence in using ICT tools to support daily office tasks, improve productivity, and adapt to changing technology trends.

Who should Attend?

This course is ideal for

·       Administrative assistants, clerical staff, and office support personnel

·       Individuals re-entering the workforce after a career break

·       Professionals transitioning from non-digital roles to ICT-enabled environments

·       Community workers, NGO staff, and small business employees seeking to enhance productivity

·       Anyone with little or no prior experience in using office computer applications who wants to become confident and competent in basic ICT functions

Course Outline

Module 1: Advanced File Management and Digital Workspace Organization

• File and folder automation (batch renaming, shortcuts, search filters)
• File compression and encryption (ZIP, PDF security, password-protection)
• Cloud integration: syncing Google Drive, OneDrive, Dropbox
• Efficient use of File Explorer / Finder features
• Managing shared folders and permissions

Module 2: Advanced Word Processing Techniques (Microsoft Word / Google Docs)

• Creating and using advanced templates and styles
• Mail merge for letters, labels, and emails
• Building dynamic tables of contents, footnotes, and cross-references
• Document comparison and version tracking
• Restricting editing and securing documents

Module 3: Data Management and Analysis in Spreadsheets (Excel / Google Sheets)

• Advanced formulas: VLOOKUP, HLOOKUP, IFERROR, COUNTIF, SUMIFS
• Conditional formatting for dynamic reports
• PivotTables and PivotCharts for summarizing data
• Data validation and dropdown lists
• Importing/exporting data from/to external sources (CSV, databases)

Module 4: Professional Presentations and Multimedia Integration (PowerPoint / Google Slides)

• Slide master customization and branding
• Advanced animations, transitions, and interactive elements
• Embedding videos, audio, and live content
• Recording and exporting narrated presentations
• Collaborating on live presentations (real-time editing and sharing)

Module 5: Productivity and Collaboration with Microsoft 365 / Google Workspace

• Using Teams, Outlook, and OneNote for project coordination
• Advanced use of Gmail, Google Calendar, and Google Meet
• Collaborating on shared documents in real time
• Managing group tasks and shared drives
• Integration between apps (e.g., Excel to Word or Sheets to Docs)

Module 6: Email Management and Digital Communication Skills

• Advanced email organization: rules, filters, and categories
• Using calendar invitations, reminders, and scheduling tools
• Creating professional email signatures and autoresponders
• Managing shared inboxes and group emails
• Email security: recognizing phishing and spam filters

Module 7: Internet Research, Digital Tools, and Online Resources

• Using advanced search operators (Google, Bing)
• Evaluating online sources and checking authenticity
• Using online tools for collaboration (e.g., Trello, Slack, Canva)
• Form builders: Google Forms, Microsoft Forms, SurveyMonkey
• Converting and editing PDFs, Word, and image files

Module 8: Digital Security and ICT Best Practices

• Password managers and two-factor authentication (2FA)
• Safe use of public Wi-Fi and VPNs
• Managing digital footprints and privacy settings
• Recognizing and responding to cyber threats
• Organizational data protection policies and ethical computing

Module 9: Customizing Office Tools and Automating Tasks

• Creating Macros in Microsoft Word and Excel
• Using Quick Access Toolbar and customizing ribbons
• Automating repetitive tasks using templates, forms, and macros
• Introduction to Microsoft Power Automate or Google Apps Script
• Keyboard shortcuts and productivity hacks

Training Approach

This course will be delivered by our skilled trainers who have vast knowledge and experience as expert professionals in the fields. The course is taught in English and through a mix of theory, practical activities, group discussion and case studies. Course manuals and additional training materials will be provided to the participants upon completion of the training.

Tailor-Made Course

This course can also be tailor-made to meet organization requirement. For further inquiries, please contact us on: Email: training@upskilldevelopment.com Tel: +254 721 331 808

Training Venue

The training will be held at our Upskill Training Centre. We also offer training for a group at requested location all over the world. The course fee covers the course tuition, training materials, two break refreshments, and buffet lunch.

Visa application, travel expenses, airport transfers, dinners, accommodation, insurance, and other personal expenses are catered by the participant

Certification

Participants will be issued with Upskill certificate upon completion of this course.

Airport Pickup and Accommodation

Airport pickup and accommodation is arranged upon request. For booking contact our Training Coordinator through Email: training@upskilldevelopment.com, +254 721 331 808

Terms of Payment

Unless otherwise agreed between the two parties payment of the course fee should be done 3 working days before commencement of the training so as to enable us to prepare better.