Work with your own data | andersjensenorg

Autoplay
Autocomplete

Previous Lesson Complete and Continue

Master Microsoft Copilot 365: Beginner to Pro

Introduction

Welcome (0:22)
Important: Video setting (0:36)
Receive the course files (5:07)
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)

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
Navigate to Outlook 365 (0:35)
Summarize (0:55)
Draft a reply (and edit the prompt) (3:51)
Create our own tone (2:07)
Coaching by Copilot (4:05)
Draft with Copilot (1:38)
Prompt your Outlook emails, part 1 (1:23)
Prompt your Outlook emails, part 2 (0:49)
Chat with your Outlook calendar (0:41)

Word

Draft with Copilot (+ use files as reference) (7:43)
Ask questions (3:32)
Get feedback and edit (4:28)

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

0 comments