Skip to content
CBT Nuggets
DemoBook a Demo

AI Essentials with Microsoft Copilot

Microsoft Copilot is built into the tools you use every day: Excel, Word, and PowerPoint. But to get real value, you need to know how to guide it. This training shows you how to create documents instantly with Microsoft Word AI, analyze data and formulas in Excel, and design complete presentations in PowerPoint. You’ll also learn to use Copilot Chat for prompts and image generation, and avoid the common mistakes that waste time. With the right inputs, Copilot becomes an AI partner that helps you save hours, sharpen your work, and boost productivity across Microsoft 365.

Updated September 2025

6Skills
33Videos
5hTotal

Who This Course Is For

This course is designed for professionals who rely on Word, Excel, or PowerPoint and want to streamline their work with AI. Project managers, analysts, admins, and marketers will especially benefit from practical Microsoft Copilot training that saves time and improves results.

Skills Your Team Will Gain

  • How to use Microsoft 365 Copilot effectively
  • Creating documents faster with Word and Copilot
  • Building presentations with Copilot in PowerPoint
  • Using Copilot formulas and AI analysis in Excel
  • Generating images and prompts with Copilot Chat
  • Writing better prompts for smarter AI results

Course Curriculum

One skill is free to watch — no signup needed. The other 5 premium skills unlock for your whole team with a CBT Nuggets plan.

Free skill preview

Explore AI and Its Different Types

Jonathan BarriosDuration: 53m11 videos

Watch this complete skill free — the same trainer, videos, and labs your team gets with a plan.

Watch free skill
  • Explore AI and Its Different TypesFree53m · 11 videos
  • Premium skill.Explore Prompt Engineering with Microsoft Copilot49m · 13 videos
  • Premium skill.Create Documents Instantly with Copilot & Word47m · 11 videos
  • Premium skill.Complete Presentations with Copilot & PowerPoint52m · 11 videos
  • Premium skill.Leverage AI Formulas and More with Copilot & Excel45m · 11 videos
  • Premium skill.Leverage Copilot with Create, Chat, Images & More53m · 11 videos
Want to browse the locked skills?
with no purchase required. Already have an account?

An account gets you the full catalog to browse, pre-assessments, quiz questions on free skills, and IT Trainerbot, with every answer citing its source video.

Put this course to work for your team

Every subscription includes this course with the full library, virtual labs, and practice exams — or talk it through with sales.

For IT leaders

What IT leaders need to know before assigning this course

Copilot licenses don't deliver value on their own. When staff send vague requests, they get generic drafts, confident-sounding errors, and rework that cancels out the time saved. This course gives your team a shared, repeatable way to guide Copilot in Word, Excel, and PowerPoint.

Risk and quality controls: Learners build a reusable prompt toolkit:

  • CRE (context, role, expectation) to structure requests
  • Zero-, one-, and few-shot examples for style and format
  • "Ask two" clarifying questions to reduce guessing
  • A safety line that limits Copilot to the supplied document, has it reply "not found" when information is missing, and keeps PII out of the output

The course also covers where AI makes things up and how to use Copilot for practical creation tasks, including documents, spreadsheets, presentations, and infographics.

Role fit: This is beginner-level training for project managers, analysts, admins, and marketers. No data analysis background is required for the Excel skill. The course does not cover IT setup, licensing, admin settings, or Copilot Studio agents, so pair it with admin-focused training for your M365 administrators.

Time investment: About 5 hours per learner across six skills. A single business case runs through every skill, which makes it easy to schedule in weekly blocks.

Change management: A common prompt framework gives Team Leads one standard to reinforce after rollout. Use Playlists to sequence this course with follow-on AI training.

Team Impact

How this training helps your team succeed

Most teams already have Copilot inside Word, Excel, and PowerPoint. The gap is knowing how to direct it. This course builds that skill through one connected business scenario: a fictional wellness startup, Thrive 365, carried from document to spreadsheet to slide deck. Your team practices the same reusable prompt workflow at each step.

  • Faster, more consistent first drafts in Word: Learners move from loose, naive requests to structured prompts using CRE (context, role, expectation). They add examples only when they need them, then refine a full business document with service tiers, onboarding steps, and check-ins.
  • Fewer AI errors reaching stakeholders: Teams add an "ask two" step, where Copilot asks two clarifying questions before it writes. They also add a safety line, such as "use only this document, reply 'not found' if info is missing, and leave out PII." Both habits reduce the risk of hallucinated or sensitive content.
  • Pitch decks and budget asks built with clearer constraints: In PowerPoint, learners use structured prompts to shape presentation output around the audience, slide limits, and a clear call to action. The same approach helps teams prepare internal funding requests.
  • More structured financial work in Excel: Learners apply the prompt workflow to Excel-based financial work, using clear context and expectations so spreadsheet output is easier to review, revise, and explain. Teams see how the same prompt engineering habits apply whether the spreadsheet task is simple or more involved.

The course also sets realistic expectations. Learners test Copilot Create on infographics and see where it falls short, so they know when AI output still needs a person to finish it.

After completion

Capabilities your team walks away with

Knowledge

  • How classic rule-based software (Software 1.0) differs from machine learning, deep learning, and generative AI, and where Copilot fits in that mental model
  • Why AI models can make things up while sounding confident, and how that risk shapes everyday Copilot use
  • The CRE framework (context, role, expectation) for writing prompts in plain English
  • When to use zero-shot, one-shot, or few-shot prompting, and why more than two examples usually adds noise
  • The difference between excerpts (the facts you supply) and examples (the style and format you want)
  • Known Copilot limits, including why outputs need review and where Copilot Create fits for image and infographic work

Ability

  • Turn rough requests into structured Word prompts that produce complete, editable business documents, such as service packages, onboarding steps, and pricing tables
  • Build and reorganize PowerPoint decks from a blank file or existing documents, with set section order, slide limits, and merged overlapping content
  • Add an "ask two" clarifying-question step and a safety line that limits Copilot to supplied source material, returns "not found" when information is missing, and excludes PII
  • Use Copilot in Excel to work with formulas and structured spreadsheets that update when inputs change
  • Use Copilot Chat to write role-based image prompts and identify how Copilot Create supports generating and modifying images
  • Reuse one prompt toolkit across Word, PowerPoint, Excel, and Copilot Chat so teams get consistent results

Readiness check

Confirm prerequisite knowledge before training begins

A short placement assessment on the CBT Nuggets assessments platform measures whether a learner already has the foundation this course assumes. IT leaders use it to put the right people in the right training — and any learner can take it right now to make sure they'll get full value from day one.

  • Questions generated from this course's own video transcripts — what gets measured is exactly what gets taught
  • Instant, per-learner results that show whether the prerequisite foundation is in place
  • Results roll up into team readiness reporting, so training hours go where they change outcomes
Runs on assessments.cbtnuggets.com — sign in with an Adept account so results roll up into team readiness reporting. Need one?
.

If gaps show up, start here

AI Productivity for Professionals

This entry-level AI productivity tools training course shows you how to make AI work for you. You’ll practice prompting ChatGPT, Copilot, Gemini and similar tools to summarize inboxes and research, turn meeting transcripts into task lists, and automa...

~6h

This course is included with every plan

Unlock this one course, or get one learner — or your whole team — access to all 295 courses, virtual labs, and practice exams.

Course Unlock

Just need this course?

$15one time

No subscription

One year of access to Microsoft Copilot

CBT Nuggets Individual

Includes IT Trainerbot Plus

$49per month

Billed annually

Every course, for one learner

See Individual pricing
For IT teams

CBT Nuggets Teams

IT Trainerbot for every seat

$59per seat / mo

Billed annually

From 1 learner seat · unlimited admin seats

Checking your access…

Frequently Asked Questions

Who should take this Copilot course?

This course is designed for anyone who uses Microsoft Word, Excel, or PowerPoint and wants to save time with AI. If you write reports, build spreadsheets, or create presentations, Microsoft Copilot training helps automate repetitive tasks and improve quality. No technical background is needed, just curiosity and a desire to get more from tools you already use.

Does this course cover Copilot in both Excel and Word?

Yes. You’ll learn how to use Copilot in Excel for formulas, data analysis, and insights, as well as how to use Microsoft Word AI to draft, edit, and summarize text. The course also includes Microsoft Copilot for PowerPoint, showing you how to create polished, professional slides in minutes.

Is learning how to use Microsoft Copilot worth it?

Absolutely. Copilot is built directly into Microsoft 365 apps, which millions of professionals already use daily. Learning how to use Microsoft Copilot effectively means faster work, fewer mistakes, and better results. This training teaches you how to write the right prompts so Copilot becomes a productivity tool, not a frustration.

What’s the main difference between Microsoft Copilot vs ChatGPT?

ChatGPT is a standalone AI chatbot for general tasks, while Microsoft Copilot is built into Word, Excel, PowerPoint, and other 365 apps. Copilot works with your actual files (helping you create reports, analyze spreadsheets, or design presentations) without leaving the Microsoft Office environment.

What jobs can I get with Microsoft Copilot training?

This course won’t hand you a brand-new job on its own, but it will make you sharper in the one you already have. Roles like project manager, analyst, marketer, admin, or team lead can all benefit. Employers value professionals who are capable of producing the results that Microsoft Copilot can help you achieve in moments rather than days or weeks.

Ready to upskill your team?

See how IT leaders fit this course into a team training plan, and what a plan costs for your team's size.