Module 4: Microsoft 365 Copilot for Content Creation & Data Analysis

Microsoft 365 Copilot is fully integrated into your Microsoft 365 environment, embedded into the apps you use every day, with the ability to interact with your information in Microsoft 365.

In this 90-minute session, attendees will be introduced to Microsoft 365 Copilot, with a focus on capabilities for content creation and data analysis within Word, Excel and PowerPoint.

Contents

Introduction to Microsoft 365 Copilot

• Data Access
• Security, Compliance and Privacy
• Web or Work?
• Microsoft 365 Experiences

Copilot in Word

• Draft new content in a document
• Proof and re-draft content in a document
• Ask for coaching to improve a document
• Create a new document from an existing document(s)
• Generate ideas to extend a document
• Translate content in a document

Copilot in PowerPoint

• Create a new presentation about a topic
• Proof and re-draft content in a presentation
• Get advice on how to improve a presentation
• Create a presentation from an existing file

Copilot in Excel

• Prepare and clean data
• Generate formulas and functions
• Sort and filter data
• Apply conditional formatting
• Visualise data
• Generate insights and recommendations
• Compare data files in Biz Chat

This session will also explore the art of a good “prompt”, exploring the use of questions and the importance of responsible usage.