Improving office productivity through Microsoft Copilot

This workshop will guide participants through the essential and advanced features of Microsoft Word, focusing on creating well-structured and professional documents. Attendees will learn how to import and format text, images, and other elements, with Copilot assisting in drafting and rewriting for clarity. The session will cover the use of styles and templates for consistent formatting, inserting tables, charts, and hyperlinks to enrich content, and collaborating effectively using comments and track changes

Learning objectives

The overall learning objectives for this workshop will include:

• Importing and formatting text, images, and other elements in a document, with Copilot aiding in first draft creation
• Streamlining document formatting and editing tasks with Copilot's assistance, including rewriting for clarity
• Using styles and templates for consistent formatting, with Copilot suggesting optimal styles
• Inserting tables, charts, and hyperlinks to enhance content, with Copilot converting text into tables
• Collaborating using comments, track changes, and sharing features

This workshop is designed to help participants create engaging and visually effective presentations. It will cover slide design using themes and layouts, importing and formatting multimedia content, and applying animations and transitions to enhance presentation flow. Copilot will assist in drafting slides, summarising and organising content, and offering design suggestions for charts, graphs, and tables. By the end of the session, participants will be equipped to communicate ideas clearly and confidently through well-crafted presentations.

Learning objectives

The overall learning objectives for this workshop will include:

• Designing slides using themes, layouts, and design principles for effective communication, with Copilot's recommendations
• Importing and formatting text, images, and multimedia elements within slides, aided by Copilot for first draft creation
• Summarising and organising deck content effectively, supported by Copilot
• Customising charts, graphs, and tables to visually represent data, with Copilot assisting in design choices
• Using animations and transitions to enhance presentation flow, guided by Copilot's suggestions

This intermediate workshop is designed for those who want to take their Excel knowledge to the next level. A solid knowledge in basic Excel functions will act as a strong foundation, as you will expand your knowledge with the use and application of Data Validation, Pivot Tables, Table and Lookup functions. Beyond the application of these functions, this training will also include basic theoretical perspectives on information management, enabling you to manage large datasets and to harness the power of Excel functionality.

Learning objectives

The overall learning objectives for this workshop will include:

• Utilising text functions (LEFT, RIGHT, MID, LEN, CONCAT, FIND) for advanced data manipulation.
• Employing the Text to Columns feature to organise complex data.
• Applying conditional functions (IF, IFS) for decision-making analysis.
• Using COUNTIF and COUNTIFS to perform data counting based on criteria.
• Implementing SUMIF and SUMIFS for conditional summation of data.
• Leveraging date functions (YEAR, MONTH, DATE, DATEDIF) for effective date analysis.
• Applying data validation techniques to ensure data integrity.
• Implementing XLOOKUP for efficient data retrieval across datasets.
• Sorting and filtering data using the SORT and UNIQUE functions.
• Creating and analysing Pivot Tables to summarise and visualise data insights.
• Identifying key data points using the LARGE and SMALL functions.

This integrated workshop covers essential communication and collaboration tools. Participants will learn to manage emails, calendars, and tasks in Outlook, and use Teams for real-time messaging, meetings, and file sharing. Copilot will assist with drafting emails, summarising threads and chats, and extracting action points, enabling more efficient and organised workflows.

Learning objectives

The overall learning objectives for this workshop will include:

• Organise and manage emails, contacts, and tasks efficiently using folders, flags, and to-do lists, with Copilot assisting in drafting and summarising
• Schedule and manage meetings in Outlook and Teams, including screen sharing, recording, and video settings
• Communicate via chat, audio, and video, and collaborate in real time with file sharing and channel organisation
• Use Copilot to summarise chats and emails, extract action points, and generate follow-ups
• Integrate Outlook and Teams with OneNote, SharePoint, and Planner for unified task and project management

This combined session introduces tools for information capture, content management, and data collection. Participants will learn to create and organise digital notebooks in OneNote, manage documents and sites in SharePoint, and design surveys and quizzes in Forms. Copilot will support note-taking, and content organisation, while collaboration features across all three tools will streamline teamwork and data handling.

Learning objectives

The overall learning objectives for this workshop will include:

• Create and customise forms, notebooks, and SharePoint sites to structure and collect information effectively
• Collaborate in real time on forms, notes, and documents using shared folders, Teams, and co-authoring features
• Manage access and permissions to protect data and ensure GDPR compliance
• Capture and organise content in various formats, including text, images, audio, and files
• Analyse form responses with dashboards and manage documents with version control and syncing across devices