Un guide pour Microsoft 365 Copilot

Date de récolte : [[2024-04-10-mercredi]]

Microsoft 365 Copilot : 101 Guide

Mon avis :

date du 25 novembre 2023, ça a peut-être bougé depuis

Texte complet :

Mos Noppadol Rattanawisadrat

If you familiar with ChatGPT and started heard about Copilot…

Today, let’s talk about how to use it, when and why to use it in this Copilot 101 guide

4 topic we will cover today

What is Copilot ?
What to do before prompt
What’s Copilot can do in each app ( + Prompt guide)
A day in life in each role

Last update : 25 Nov 2023

1. What is Copilot ?

![[attachments/3f73def3a70ee57cc97f06f96ca24d6a_MD5.png]]

Behind the scene : As Microsoft invest OpenAI, So Copilot get GPT/Dall E/Codex model to power Microsoft product then rebrand it into “Copilot”

if ChatGPT is one of Large Language Model (LLM)

Copilot is

LLM that able to understand us.

MS Graph that understand our company data and context.

M365 App that able to Take action.

data from Internet

Which is now, Copilot is everywhere in Microsoft product but today we only talk about Copilot for Microsoft 365 Copilot

![[attachments/fb16bb4f4381e5c7bfdc5f9ab9753697_MD5.png]]

Current available in Copilot for Microsoft 365 — more will join very soon

![[attachments/ed7b6e24f424f069cc430f831b41f0b9_MD5.png]]

take a look at this overview video

![[attachments/8f1b961e050e82225d16385eb2060991_MD5.png]]

ChatGPT vs Copilot vs M365 Chat vs M365 Copilot

![[attachments/4f00aa21ae56a45ef7c619da776125a0_MD5.png]]

ChatGPT

A good Chatbot but limit in updated data

Copilot

A good Chatbot that access real time data ( in Internet )

M365 Chat

A good Chatbot that access both Internet data and Internal data, and also able to reference file

M365 Copilot

A features that able to use like Chatbot and able to take action like create Presentation or excel analysis

2. What to do before prompt

Question : What prompt should I use ?

![[attachments/83af6af21cbeaf626866f654ba4ebdd1_MD5.png]]

a good prompt include… Goal, Context, Source, Expectations

if it still too hard to start..

Microsoft give us a Prompt Guide in every app

![[attachments/296fb9dee5cc6d158715f42af3b6b357_MD5.png]]

3. What’s Copilot can do in each app

+ Prompt guide

in this section, I will go deep in use case and prompt example in each application.

![[attachments/ed7b6e24f424f069cc430f831b41f0b9_MD5.png]]

Microsoft 365 Chat

This is upgraded version of ChatGPT or Bing… That able to access company data and able to reference file in OneDrive and SharePoint or Email and Teams

to ask question that only have in internal data
to summarize Email, Chat, meeting
Reference file up to 3 files like Word, Excel, PowerPoint, PDF
Reference People, Meeting, email

![[attachments/327fbb6850b9a48320a19b28166908c2_MD5.png]]

use M365 Chat via Office.com/chat or at Microsoft Teams app

![[attachments/9efe50b29645095ce9e5ca2750aa3cf3_MD5.png]]

when you have question like internal Policy or Email in my inbox or chat.. M365 Chat

![[attachments/da04288c1ac01485a5e859e64adc11f8_MD5.png]]

Meeting ที่ถามถึง จะต้องมีการบันทึก Transcript เอาไว ้ถึงถามย้อนหลังได้

How much Copilot can access your data

OneDrive that you own or have access
SharePoint public and site that you’re a member
Exchange Online that you able to read ( exclude flie attachment )
Microsoft Teams Chat/Meeting that you have access

Plugin

Web — default will be turn off
many more that your admin allow

![[attachments/99bd8599a12846cae93913b97648cd4b_MD5.png]]

Prompt guide

What is the caretaker leave policy in Microsoft?
Highlight my email this week
Summarize emails where I was mentioned recently. Make it detailed, highlighting the sender and categorizing by topic of the email.

![[attachments/1d3e3e595db85e54069f3f31741ad9a4_MD5.png]]

Microsoft Teams Copilot

We can use teams copilot during meeting ,after meeting and even in chat with your colleges

in Chat / meeting Chat

To summarize to long chat or specific question in chat

To summarize meeting chat ( don’t need to be the same org as host )

![[attachments/122da2c4904c31ed13ade042b36a0cb9_MD5.png]]

Prompt guide

Highlights from the past day
ask specific question in the meeting room
ask that any mention to me

2. in Meeting room

Before using copilot, enable transcript in the meeting room first
( Next version don’t need to enable transcript but only work during meeting )
and you need to be the same tenants with host

![[attachments/d3300070af94c784c1800cf4171e36b8_MD5.png]]

Prompt guide

Get a summary of the meeting so far
Key discussion points
Who said what or what people said
Where do people disagree
Suggest action items

3. Recap after meeting

You may join the meeting late or even cant join the meeting
you can get a AI assistant to answer and summarize content for you instead of watching all long video

![[attachments/9e9c9e30b23203fe66f9cd25ac80002c_MD5.png]]

Prompt guide

Recap the meeting
List action items
Follow up questions
Highlight the different perspectives on a topic
List main ideas

![[attachments/b8f62502b3ac35f80ddb921e7e819fd1_MD5.png]]

Outlook Copilot

Copilot ใน Outlook will help you draft or reply email, coach your writing before you send and help summarize long email to save you time.

and we have 3 ways to using Outlook Copilot

![[attachments/972c39a53e5643bbdedba7990f621124_MD5.png]]

1. while writing

Copilot will popup in the writing canvas as (Draft with copilot) or in the menu bar

Magic will happen more when you reply and Copilot able to understand the context of your conversation.

![[attachments/01ed742749e2076ea2cba412df378a5b_MD5.png]]

after done writing, you can enable Coaching by Copilot to review your Tone, Reader sentiment or Clarity.

![[attachments/f08e66bd728087af8920d95530f19cbe_MD5.png]]

or get summarize an long email or a long thread that people forward to you.

![[attachments/d21f390d236883c25198f2342199f397_MD5.png]]

( if you want to get daily highlight from multiple email, i recommend to use M365 Chat )

Overview of Copilot for Office app

![[attachments/0f8d5fd80d0f3f8dd89094698ffbf1ad_MD5.png]]

PowerPoint Copilot

![[attachments/c75687ca78016930066d49f229889b34_MD5.png]]

Use case

Turn an idea into a presentation.
Turn a Word doc into a presentation.
Improve an existing presentation. ( e.g. change font in all slide!! )
Prepare to give a presentation by summarizing key points and creating slide notes
or just summarize a big ppt from others

Prompt Example

Create

Create a presentation from a description
Create a presentation from a Word document URL

![[attachments/810bd0f6045d0087d60dadfc29ff81e1_MD5.png]]

Refine (Edit)

Add a slide about a [topic]
Add an image based on a description
Change font family on all slides to Segoe UI
Organize the presentation by adding an agenda and creating Sections

Summarize (Organize)

Create a summary (love this prompt !! I have to read tons of ppt deck)
Show key slides — Provides a list of slides with important information.

![[attachments/36eb9aa30d34fe525c2175b1d7c51e3d_MD5.png]]

Discover (Understand)

Show action items and next steps
Ask questions about the presentation

Command (Ask)

Reformat text
Create a new slide

![[attachments/bb846d8da9dd1cfc548c6d5e7ac5c496_MD5.png]]

Word Copilot

Copilot in Word will help you write, edit, summarize and ask a specific question in document.

![[attachments/c764b7ba6e75ae288c88f84d4572078b_MD5.png]]

Word has 2 copilot buttons.

Copilot in upper right is to chat and ask.
Draft with Copilot to generate content.
Rewrite when you select the content.

![[attachments/34fb714f6867ad2928fb7ec3b5c2dd38_MD5.png]]

![[attachments/fc97fb6f1f786b43c324bce74ade48f0_MD5.png]]

Use case

Turn an outline or idea into text
Create new content from reference content like Word or PowerPoint

Generate Proposal to customer from /Sustainability at Microsoft.pptx align with my template /Proposal Template Master.docx

Rewrite existing text for length, tone, new phrasing
Add tables based on the text
Summarize or ask specific question.

What is the responsibility of on call engineer?

Prompt Example

Draft with Copilot

you can reference up to 3 files in 1 prompt

Create proposal from Thunderbolt e-bike file Thunderbolt e-bike.docx
Generate Proposal to customer from /Sustainability at Microsoft.pptx align with my template /Proposal Template Master.docx

Copilot

What is the responsibility of on call engineer?
What is the escalation process?
Summarize the doc for 7 years old kids

![[attachments/293d5e8df511b1ef86189f9e8e83392e_MD5.png]]

![[attachments/9605fb595fcdce18ae8fd941280c1e02_MD5.png]]

Excel Copilot

Best part of Excel Copilot is it help beginner user able to use excel much much more effective without knowing all formular and trick. Sales manager can get insight by just asking

To use excel copilot : File must store in OneDrive/SharePoint and data must be a Table format

![[attachments/5365ccbbaa85ed951356820788723b60_MD5.png]]

Good example

![[attachments/65ff83389c5503e2b361ac661c7f5c4f_MD5.png]]

Use case

find Data insight.
asking a question of data
adjust or create new column.

![[attachments/f2d25b8e82756196fcb93c56d37b38a1_MD5.png]]

![[attachments/5aa192af05edb1b7ddac8c7d162ed965_MD5.png]]

Limitation

only support single table at this time
Column is limit to some point

Prompt Example

What are the top 5 campaigns by revenue Budget for digital marketing over time
How does revenue generated by different campaign types compare?
How many campaign owners had over 1000 users targeted?
Give me column suggestions add a column that tells me which campaigns are successful.

Whiteboard Copilot

![[attachments/f3a4e46ec8581c543b0c5fa17650089f_MD5.png]]

Whiteboard is application in Web app, Desktop App, Mobile App and able to use via Microsoft teams meeting or Chat too

Copilot in whiteboard will help you do these 4 main task

Suggest ideas

![[attachments/decd3c63b8fa17d92622550af50ac210_MD5.png]]

Copilot will initiate ideas for you to start faster and better when you do a brainstrom session or design thinking workshop

![[attachments/59f4becb47b1d6412678469d118ee9aa_MD5.png]]

2.Visualize you persona

![[attachments/f3e617150c9016b5e7631217e694c6ef_MD5.png]]

3. Categorize the idea

![[attachments/a848e001e604e02f3f5b9091a6846b52_MD5.png]]

4. Summary what we’ve disscussed

![[attachments/c7f395d0af27fd3c2d8c0ab37d22c087_MD5.png]]

Forms Copilot

Copilot in forms will get us to where template can’t. to fully customize to your context base on your prompt.

![[attachments/503e608f68216ffe0cb5cbf6e88111de_MD5.png]]

![[attachments/f299e0d4eb9b9363f45bbebd071dfb88_MD5.png]]

to add well known knowledge into a choice

![[attachments/ec1067d7df5c768a92cfa9acdf68a09d_MD5.png]]

Stream Copilot

To summarize video content in Microsoft stream

![[attachments/f1279944804929e104ddde83a4ad1e6c_MD5.png]]

4. A day in life in each role

Copilot can do many thing….. and if you don’t know where to start. You can see these guide in each role.

A day in the life of an Executive

![[attachments/691c376b89b07fe796201f4ee5493979_MD5.png]]

A day in the life of an HR manager

![[attachments/9f2274c35604904e55ba4663e066f312_MD5.png]]

A day in the life of a Sales Lead

![[attachments/e39b9700998a8e01886302022bb78dca_MD5.png]]

A day in the life of a Marketing Manager

![[attachments/3ab97048674c0c4b26d80a61c89a571c_MD5.png]]

A day in the life of a Financial Analyst

![[attachments/edcee47091c6e9de2ef822f4e140588c_MD5.png]]

A day in the life of an IT administrator

![[attachments/a056fdc8989ad54ebe12a70d68d32383_MD5.png]]

FAQ

Limitation

Copilot in Word

Attaching a file to summarize or reference has limitation of approximately 15k words. In this scenario when a limited/partial response is generated, there is a warning to the user alerting them of the partial response.

Copilot in PowerPoint

Microsoft 365 Copilot can be used to transform a Word document into a PowerPoint presentation.
The Word document must be less than 12MB in size.
PowerPoint will only use the first 20 pages of a Word document to create a presentation.

Copilot in Excel

![[attachments/3e3fa8f9b4926659d8a9c2e7f94175e1_MD5.png]]