Capability Development / Work Productivity
Workplace Productivity with Microsoft Tools
This program turns everyday digital work into a faster, smarter and more collaborative experience. Participants build practical, hands-on skills across Microsoft 365 — Excel, Word, PowerPoint, Outlook, Teams, OneDrive, SharePoint, OneNote, To Do, Planner, Power Automate, Power BI and Copilot — to create high-quality documents, manage data confidently, communicate with precision, collaborate securely, automate repetitive tasks and turn information into actionable insights in a modern, AI-enabled workplace.
Program Overview
This program turns everyday digital work into a faster, smarter and more collaborative experience. Participants build practical, hands-on skills across Microsoft 365 — Excel, Word, PowerPoint, Outlook, Teams, OneDrive, SharePoint, OneNote, To Do, Planner, Power Automate, Power BI and Copilot — to create high-quality documents, manage data confidently, communicate with precision, collaborate securely, automate repetitive tasks and turn information into actionable insights in a modern, AI-enabled workplace.
Audience Profile
Working professionals, team leads and managers who use Microsoft 365 every day and want to plan and track work better, produce polished business outputs, coordinate teams through Outlook, Teams, OneDrive and SharePoint, automate routine processes with Power Automate, and apply Copilot to drafting, summarising, analysis and meeting preparation.
Course Syllabus
Microsoft Excel
Topics
- Fundamentals and productivity setup: navigation, shortcuts, professional formatting
- Data management and cleaning: sort, filter, remove duplicates, validate, tables and named ranges
- Formulas and analysis: logical, lookup, text, date and statistical functions; XLOOKUP, SUMIFS, FILTER, UNIQUE
- Reporting: PivotTables, PivotCharts, slicers, timelines and simple KPI dashboards
- Power Query and Copilot in Excel: import, transform, merge, append and refresh data; Copilot for formulas and insights
Microsoft Word
Topics
- Document creation and formatting: fonts, spacing, themes, styles and templates
- Structured content: headings, table of contents, captions, cross-references, tables, images and SmartArt
- Review and compliance: comments, track changes, compare, accessibility and inspection checks
- Automation and Copilot: mail merge, quick parts, headers and footers, drafting and rewriting with Copilot
PowerPoint
Topics
- Presentation planning: audience, objective, slide flow, themes, layouts and slide masters
- Visual storytelling: clean slides, hierarchy, contrast, spacing and data-to-visual summaries
- Advanced features: animations, transitions, presenter view, timings, comments and versions
- Copilot in PowerPoint: draft decks, generate speaker notes, improve flow and messaging
Outlook
Topics
- Email productivity: inbox views, folders, categories, flags, search and professional writing
- Calendar and meetings: scheduling, reminders, availability, shared calendars, agendas and follow-ups
- Automation and Copilot: rules, quick steps, mailbox clean-up, Copilot summaries and replies
Microsoft Teams
Topics
- Collaboration: chats, channels, mentions, announcements, tabs, files and apps
- Meetings and calls: scheduling, screen sharing, recordings, notes, decisions and tasks
- Apps and Copilot: Planner, OneNote, SharePoint, Loop, Forms and Power BI tabs; Copilot recaps and action items
OneDrive and SharePoint
Topics
- OneDrive: secure storage, sync across devices, offline files, secure sharing, permissions and version restore
- Copilot and smart file productivity: summarise and compare files, naming and security practices
- SharePoint sites and libraries: pages, navigation, lists, metadata, views and folders
- Collaboration and governance: access, approvals, version history and retention
- Integration: Teams, OneDrive, Power Automate, Power BI and Copilot to find and summarise content
OneNote, To Do and Planner
Topics
- OneNote: notebooks, sections, pages, tags, templates; meeting agendas, minutes and action points; Copilot summaries and task extraction
- To Do: tasks, due dates, reminders, priorities, My Day, converting emails into tasks and syncing across devices
- Planner: plans, buckets, owners, labels, board, grid and schedule views
- Project tracking: progress, dependencies, comments, attachments; Copilot for plans, timelines, progress and risks
Power Automate
Topics
- Automation concepts: triggers, actions, connectors and conditions
- Approval and notification flows
- Business process automation across Outlook, Teams and SharePoint; monitoring flows and handling errors
- Copilot in Power Automate: describe, modify and explain flows in natural language
Power BI
Topics
- Fundamentals: Desktop and Service, datasets, workspaces; connecting Excel, CSV and SharePoint data
- Data preparation and modeling: Power Query, relationships, basic DAX measures and KPIs
- Visualization and sharing: interactive reports, slicers, filters, drill-through, publishing dashboards securely
- Copilot and AI-assisted analytics: report ideas, explaining visuals and trends, turning insights into decisions
Copilot (Basic and Premium)
Topics
- Copilot fundamentals and prompting: Copilot Chat basics, clear prompts, reviewing and refining outputs
- Copilot across Microsoft 365 apps: drafting, summarising, analysing and completing tasks
- Agents, automation and real-world role-based scenarios for operations and reporting
- Security, data privacy and responsible use: protecting sensitive information and validating AI output