Work with your own data | andersjensenorg

Autoplay
Autocomplete

Previous Lesson Complete and Continue

Master Microsoft Copilot 365: Beginner to Pro

Introduction

Welcome (0:31)
Important: Video setting (0:36)
Recieve the course files (3:23)
How to open a Microsoft 365 application: Legacy and Cloud (1:47)

AI and Copilot 365

Introduction
What is Artificial Intelligence (AI)?
What is a Large Language Model (LLM)?
What is GPT and ChatGPT?
Microsoft and OpenAI
How does Copilot work?
Licensing and pricing

Copilot Chat

Introduction
Sign in (0:33)
Our first prompts (7:36)
Web content (1:31)
Work with your own data (3:17)
Ask data-driven questions (2:54)
Stop responding (0:58)
Response options (2:56)
The "perfect" Copilot prompt: Task (1:40)
The "perfect" Copilot prompt: Context (1:49)
The "perfect" Copilot prompt: Format (1:12)
The "perfect" Copilot prompt: Tone (0:59)
The "perfect" Copilot prompt: Role (1:23)
The "perfect" Copilot prompt: Example (1:04)
Refer to your previous created text (2:18)
Web (3:16)
Recent activity (1:48)
Conversation (9:21)
Reuse prompts (Build a prompt library) (3:20)

Excel

Introduction
Activate Copilot 365 in Excel (3:22)
Excel for beginners (2:27)
Copilot in Excel features (1:29)
Simple data insights (1:37)
Create formulas and add columns (5:39)
Formatting (1:03)
Conditional formatting (2:16)
Additional formatting (0:51)
Create charts/graphs (7:51)
Automation/Office Scripts (2:50)
Pivot tables and limitations (4:51)

Teams

Copilot Chat in Teams (3:09)
Copilot in the meeting (6:28)
Copilot after the meeting (3:09)
Remember (0:12)

Outlook

Introduction
Outlook New vs Outlook Classic (0:23)
Summary by Copilot + Chat with email (2:23)
Copilot 365 sidebar in Outlook (3:05)
Draft a reply with Copilot (2:26)
Edit the reply prompt (1:26)
Copilot for new emails (1:22)
Coaching by Copilot (1:34)
Schedule by Copilot (1:05)

Word

Draft with Copilot (2:10)
Improve the output (2:15)
Reference files (2:04)
Add content/inspire me (0:33)
Save the document (0:42)
Summary when opening a document (0:33)
The sidebar (2:15)
Use stock images and create AI images (2:09)
Prompt suggestions (0:43)
Edit a document with Copilot (2:36)
Copilot benefits of using Word in the cloud (1:44)

PowerPoint

Excisting slide deck (4:09)
Create new presentation (1:42)
Edit presentation (2:22)
Designer (0:19)
Organize (0:46)
Using the prompting guide (1:43)
Your files as the foundation (1:58)

OneNote

OneNote Intro (0:16)
Create (4:52)
Edit with Copilot (2:27)
Ask and Summarize (2:57)

Forms

Draft with Copilot (3:28)
Improve the draft (1:26)
Share your Forms (1:47)

Whiteboard

Intro to Whiteboard (6:10)
Suggest with Copilot (1:53)
Categorize with Copilot (0:57)
Summarize with Copilot (0:42)
Bonus tips (0:50)
Whiteboard and Copilot in Teams (1:48)

Now what?

AI and Automation Black Belt

Work with your own data

Complete and Continue

Discussion

2 comments