Prompt copied to clipboard!
From Beginner to Advanced

Microsoft Copilot

Masterclass 2026

  • Master AI Chat
  • Learn Professional Prompt Engineering
  • Explore Custom Instructions
  • Work with Files and AI Agents
  • Use Copilot in Microsoft 365
  • Build Real-World AI Workflows

Presented by Nirmal Rabari

Microsoft Copilot Masterclass 2026Slide 01 / 50
Introduction02 / 50

Your AI Productivity Journey Starts Here

Stop Just Asking AI Questions. Start Getting Work Done.

🎯

Effective Usage

Use Microsoft Copilot effectively and write prompts that deliver better results.

⚙️

Customization

Customize your AI experience and create/use specialized agents.

💼

Real-World Application

Work smarter with Office, understand plans, and apply AI to business problems.

Microsoft Copilot Masterclass 2026Slide 02 / 50
Overview03 / 50

What is Microsoft Copilot?

Your AI Assistant for Everyday Work helps you:

Content Creation

Write, rewrite and summarize content.

Discovery

Research topics and explore ideas.

Data Intelligence

Analyze information and data.

Output Generation

Generate reports and presentations.

Comprehension

Understand documents and conversations.

Productivity

Support everyday productivity.

Important Reminder

Copilot assists your work. You remain responsible for important decisions and verification.

Microsoft Copilot Masterclass 2026Slide 03 / 50
Ecosystem04 / 50

Understanding the Copilot Ecosystem

One Name. Different Experiences.

  • Microsoft Copilot: General-purpose AI assistance.
  • Microsoft 365 Copilot Chat: AI chat for eligible accounts.
  • Copilot in Office Apps: AI assistance within supported Microsoft 365 applications.
  • Copilot Agents: Specialized AI assistants.
  • Microsoft Copilot Studio: Advanced agent building and integrations.
Key Takeaway

Different experiences have different features, licensing and access requirements.

Microsoft Copilot Masterclass 2026Slide 04 / 50
Access05 / 50

Where to Access Microsoft Copilot

Start Your Copilot Journey

Navigation

Home and navigation, New Chat, Prompt input.

Resources

Available tools, Files and sources, Agents.

Configuration

Settings and account information.

Practical Task

Open Copilot and identify the features available in your own account.

Microsoft Copilot Masterclass 2026Slide 05 / 50
Interface06 / 50

Understanding the Copilot Interface

Know Your Workspace:

💬

New Chat

Start a conversation.

🕒

Chat History

Revisit previous conversations where available.

✍️

Prompt Box

Enter instructions and questions.

📎

File Attachments

Provide supported documents.

🛠️

Tools & Agents

Access available capabilities and specialized assistants.

⚙️

Settings

Manage available preferences.

Practical Task

Explore the interface before writing your first prompt.

Microsoft Copilot Masterclass 2026Slide 06 / 50
Context07 / 50

Web Chat VS Work Context

Choose the Right Information Source

Web Context

  • Research public information.
  • Explore industry trends.
  • Discover external sources.

Work Context

  • Work with authorized organizational information.
  • Reference supported files and work content.
  • Use eligible workplace capabilities.
Important

Access depends on the account, licence, permissions and available features.

Microsoft Copilot Masterclass 2026Slide 07 / 50
Customization08 / 50

Explore Copilot Settings

Customize Your AI Experience

Personalization

Custom instructions and personalization options.

History & Memory

Chat history, temporary chat, and memory preferences (where available).

Account & Privacy

Privacy controls and account/subscription details.

Practical Task

Open Settings and understand the purpose of each available option.

Microsoft Copilot Masterclass 2026Slide 08 / 50
Custom Instructions09 / 50

Your Personal AI Rulebook

Tell Copilot How You Want It to Work

Example Instructions

  • Act as my professional productivity assistant.
  • Use clear, concise English.
  • Explain complex topics step by step.
  • Use tables and bullet points when useful.

Advanced Directives

  • Identify risks and missing information.
  • Never invent facts, figures or sources.
  • Follow my requested output format.
  • Ask questions when essential information is missing.
Result

More consistent responses with less repetitive prompting.

Microsoft Copilot Masterclass 2026Slide 09 / 50
Personalization10 / 50

Personalization, Memory and Chat History

Make AI Work Better for You

Personalization & Instructions

Tailor supported experiences to preferences and set general response rules.

Memory

Retain supported preferences or information across sessions where available.

Chat History

Revisit and continue previous conversations.

Temporary Chat

Use a separate, non-saved chat experience where available.

Important

These are different capabilities. Their availability and behaviour depend on the Copilot experience.

Microsoft Copilot Masterclass 2026Slide 10 / 50
Prompt Engineering11 / 50

Prompt Engineering: The Real Skill

Better Instructions. Better Outcomes.

❌ Basic Prompt

"Explain AI."

⚠️ Improved Prompt

"Explain AI to a beginner using simple language and three practical examples."

✅ Advanced Prompt

"Act as an AI trainer. Explain artificial intelligence, machine learning, deep learning and generative AI. Compare them in a table and provide business applications."

Lesson

Give AI a clear objective, relevant context and a defined output.

Microsoft Copilot Masterclass 2026Slide 11 / 50
Prompt Engineering12 / 50

The CTCF Prompting Framework

A Practical Framework for Better Prompts

C
Context

Explain the situation and audience.

T
Task

Define exactly what to do.

C
Constraints

Set rules and limitations.

F
Format

Specify the output structure.

Example:

"Analyze this sales workbook, identify the highest-profit products, flag missing values and present the findings in a table with recommendations."

Microsoft Copilot Masterclass 2026Slide 12 / 50
Prompt Engineering13 / 50

The Master Prompt Template

Build a Professional Prompt in Seconds

👤 ROLE

Who should the AI act as?

🌍 CONTEXT

What is the situation?

🎯 TASK

What must it complete?

📁 SOURCE

Which files or information should it use?

🚧 CONSTRAINTS

What must it avoid or verify?

📊 FORMAT

How should the answer be presented?

✅ QUALITY CHECK

What should be reviewed before delivering the result?

Microsoft Copilot Masterclass 2026Slide 13 / 50
Prompt Gallery14 / 50

Prompt Gallery: Start With Proven Ideas

Do Not Start From Scratch Every Time. Use prompt examples to:

Discover

Discover useful tasks and adapt prompts to your work.

Customize

Replace placeholders with relevant info, add context/constraints.

Iterate

Save, reuse, and improve prompts through experimentation.

Practical Task

Find a relevant prompt, customize it and compare the result.

Microsoft Copilot Masterclass 2026Slide 14 / 50
Prompt Lab15 / 50

Prompt Lab: Find, Customize and Reuse

Turn Prompt Examples Into Your Own Workflow

  • Discover Microsoft-curated prompts.
  • Explore saved prompts.
  • Edit examples for your requirements.
  • Reuse useful prompts.
  • Share prompts where supported.
Important Note

The standalone Prompt Lab app was discontinued in July 2025. Use the current Prompt Lab experience within supported Copilot apps rather than looking for the discontinued standalone app.

Microsoft Copilot Masterclass 2026Slide 15 / 50
Prompt Coach16 / 50

Prompt Coach: Improve Your Prompting

From Vague Instructions to Clear Objectives

Weak Prompt

"Analyze my sales."

Improved Prompt

"Analyze the attached sales workbook. Identify top-performing products, monthly revenue trends, low-margin products and unusual values. Explain calculations and provide 5 actionable recommendations."

Practical Task

Use Prompt Coach where available, improve a weak prompt and evaluate the result.

Microsoft Copilot Masterclass 2026Slide 16 / 50
Iterative Prompting17 / 50

Iterative Prompting

Do Not Stop at the First Answer. Improve output step by step:

1
Generate

Initial response.

2
Structure

Improve formatting.

3
Detail

Add missing info.

4
Refine

Remove assumptions.

5
Adjust

Fix tone & length.

6
Verify

Check claims.

7
Finalize

Final result.

Nirmal's Principle

Treat AI as a collaborator. Give feedback, refine and improve.

Microsoft Copilot Masterclass 2026Slide 17 / 50
Mistakes18 / 50

8 Common Prompting Mistakes

❌ Giving vague instructions.

❌ Forgetting context.

❌ Ignoring target audience.

❌ No output format.

❌ Insufficient source info.

❌ Expecting immediate perfection.

❌ Accepting unsupported facts.

❌ Failing to verify response.

Challenge

Improve the prompt "Create a marketing plan" using CTCF.

Microsoft Copilot Masterclass 2026Slide 18 / 50
Files19 / 50

Working With Files in Copilot

Turn Documents Into Useful Insights using supported workflows:

Text Analysis

Summarize documents, extract important information.

Comparisons

Compare reports, identify inconsistencies.

Data & Outlines

Analyze spreadsheets, prepare structured reports & outlines.

Practical Task

Upload a supported sample document and ask Copilot to summarize it.

Microsoft Copilot Masterclass 2026Slide 19 / 50
Files20 / 50

The Master File Analysis Prompt

Extract maximum value from any uploaded document:

Analyze the attached document and provide: 1. Executive summary. 2. Ten important findings. 3. Key figures and dates. 4. Risks and inconsistencies. 5. Missing information. 6. Five actionable recommendations. Use the source document as evidence. Do not invent information. Identify relevant pages or sections where possible.
Microsoft Copilot Masterclass 2026Slide 20 / 50
Files21 / 50

How to Use / for File References

Reference the Right File in Supported Interfaces

Example:

/Sales-Report.xlsx Analyze monthly sales trends and identify the highest-profit products.

1. Enter / where supported.

2. Review suggestions.

3. Select the file.

4. Enter your task.

5. Review against source.

Remember

The / shortcut is interface-dependent. Use the file attachment or source-selection control if it is unavailable.

Microsoft Copilot Masterclass 2026Slide 21 / 50
Files22 / 50

File Upload VS Work Data

Understand Where Your Information Comes From

  • File Upload: Provide a supported document for a task.
  • File Reference: Refer to a file using a supported shortcut.
  • Source Selection: Select available information through the interface.
  • OneDrive & SharePoint: Access authorized content where supported.
  • Work Data: Use eligible organizational context subject to permissions and licensing.
Key Lesson

Copilot cannot automatically access every file or data source.

Microsoft Copilot Masterclass 2026Slide 22 / 50
Agents23 / 50

What Are Microsoft Copilot Agents?

From General AI to Specialized AI

Agents can be configured for particular tasks, knowledge sources or workflows.

Business Research

Market and competitor analysis.

Sales Analyst

Data and pipeline review.

HR Policy

Employee Q&A based on manuals.

Customer Support

Resolution guidance.

Learning Assistant

Training and onboarding.

Depending on the environment, agents may include instructions, knowledge sources, suggested prompts, actions and sharing controls.

Microsoft Copilot Masterclass 2026Slide 23 / 50
Agents24 / 50

How to Call Agents Using @

Select the Right Agent for the Task

Example:

@Prompt Coach Improve my prompt for analyzing a sales workbook.

1
Trigger

Enter @ in interface.

2
Select

Choose from suggestions.

3
Instruct

Enter the task.

4
Review

Check the response.

Important

Agent invocation differs between Copilot experiences. Use the Agents menu if the shortcut is unavailable.

Microsoft Copilot Masterclass 2026Slide 24 / 50
Agents25 / 50

Create Your First Custom Agent

Project: Business Sales Analyst

Name: Business Sales Analyst Purpose: Analyze sales performance and business trends. Instructions: - Inspect the available data. - Identify important columns. - Calculate profit only when the required data exists. - Rank products by performance. - Compare monthly results. - Flag missing information. - Provide evidence-based recommendations. Output: Executive summary, findings table, risks and next steps.
Microsoft Copilot Masterclass 2026Slide 25 / 50
Agents26 / 50

Agent Builder: Configuration & Settings

Build. Configure. Test. Improve.

Identity

Name and description.

Behavior

Instructions.

Data

Knowledge sources.

UX

Suggested prompts.

Skills

Supported actions.

QA

Testing.

Deployment

Publishing and sharing.

Important

The available controls depend on whether you are using a consumer agent builder, Microsoft 365 environment or Copilot Studio.

Microsoft Copilot Masterclass 2026Slide 26 / 50
Agents27 / 50

Agent Testing and Troubleshooting

A Good Agent Must Be Tested. Test it with:

  • A normal question.
  • A question requiring source evidence.
  • A request with missing information.
  • An ambiguous question.
  • A request outside its scope.
Verification Protocol

Check accuracy, source grounding, permissions and instruction compliance. Practical task: Identify one weak response and improve the agent instructions.

Microsoft Copilot Masterclass 2026Slide 27 / 50
M36528 / 50

Microsoft Copilot in Word

Create Professional Documents Faster

Supported Tasks

Draft documents, rewrite content, summarize reports, improve clarity, develop outlines, prepare proposals.

Practical Prompt

"Create a professional business proposal for an AI automation project. Include objectives, scope, implementation phases, timeline, risks, success metrics and next steps. Label assumptions and placeholders clearly."
Microsoft Copilot Masterclass 2026Slide 28 / 50
M36529 / 50

Microsoft Copilot in Excel

Turn Data Into Decisions

Supported Tasks

Understand datasets, generate/explain formulas, analyze trends, identify outliers, create charts, summarize findings.

Practical Prompt

"Analyze this sales table. Calculate gross profit using the available revenue and cost data. Rank products, compare monthly performance, identify unusual values and recommend suitable charts. Explain calculations and flag missing fields."
Microsoft Copilot Masterclass 2026Slide 29 / 50
M36530 / 50

Microsoft Copilot in PowerPoint

Transform Ideas Into Presentations

Supported Tasks

Develop outlines, create slides from prompts/docs, summarize content, improve wording, refine structure, prepare speaker notes.

Practical Prompt

"Create a 10-slide presentation on AI-powered business productivity. Include challenges, use cases, implementation, security, metrics. Keep text concise and flag claims needing evidence."
Microsoft Copilot Masterclass 2026Slide 30 / 50
M36531 / 50

Microsoft Copilot in Outlook

Make Email Work Easier

Supported Tasks

Summarize threads, draft emails, adjust tone, extract action items, identify deadlines, review calendar info where supported.

Practical Prompt

"Summarize this email thread. Identify decisions, action items, owners, deadlines and outstanding questions. Do not invent commitments or deadlines."
Microsoft Copilot Masterclass 2026Slide 31 / 50
M36532 / 50

Copilot Across Microsoft 365

One Ecosystem. Multiple Productivity Opportunities.

Word

Documents & Proposals.

Excel

Data analysis & Formulas.

PowerPoint

Presentations & Outlines.

Outlook

Email workflows.

Teams

Meetings & collaboration.

OneDrive/SharePoint

Authorized content access.

Key Takeaway

Application integration and work-data access depend on the account, licence and permissions.

Microsoft Copilot Masterclass 2026Slide 32 / 50
Use Cases33 / 50

7 Real-World Copilot Use Cases

Business Owners

Proposals and management reports.

Sales Teams

Performance analysis and follow-ups.

Marketing Teams

Campaigns and content calendars.

HR Teams

Job descriptions and policy summaries.

Finance Teams

Report reviews and variance explanations.

Educators/Students

Lesson plans, study guides, notes.

Challenge

Identify one repetitive task you can improve using Copilot.

Microsoft Copilot Masterclass 2026Slide 33 / 50
Advanced34 / 50

Researcher and Advanced Research

Research Smarter, Not Just Faster

Use Researcher for:

  • Market research.
  • Competitor analysis.
  • Industry trends.
  • Business opportunities.
  • Structured research reports.

Practical Prompt

"Research AI adoption among small and medium-sized businesses. Cover use cases, implementation challenges, security, skills and recommendations. Prioritize reliable sources and distinguish confirmed facts from estimates."
Microsoft Copilot Masterclass 2026Slide 34 / 50
Advanced35 / 50

Notebooks and Source-Grounded Work

Work With Organized Reference Material

Organize

Organize sources.

Interrogate

Ask questions about documents.

Compare

Compare multiple reports.

Synthesize

Summarize research.

Present

Develop source-based presentations.

Best Practice

Check every important conclusion against the original source.

Microsoft Copilot Masterclass 2026Slide 35 / 50
Automation36 / 50

Tasks, Automation and Recurring Work

Move From One-Time Prompts to Repeatable Workflows

Potential Applications

  • Scheduled summaries.
  • Recurring report preparation.
  • Research briefings.
  • Reminders and follow-ups.

Requirements for Reliability

A reliable workflow needs a trigger, approved data sources, defined output, permissions and review procedures.

Important

A prompt does not automatically create a recurring task. Use a supported scheduling or automation feature.

Microsoft Copilot Masterclass 2026Slide 36 / 50
Automation37 / 50

The Complete Business Productivity Workflow

An end-to-end practical scenario:

1
Excel

Analyze sales data.

2
Word

Prepare executive report.

3
PowerPoint

Build presentation.

4
Outlook

Draft management email.

5
Human Review

Verify numbers & sources.

Outcome

A practical, fully AI-assisted business workflow.

Microsoft Copilot Masterclass 2026Slide 37 / 50
Verification38 / 50

How to Verify Copilot Output

Trust the Process. Verify the Result.

Names, dates, figures.

Formulas & math.

Sources & citations.

Missing data.

Unsupported assumptions.

Data permissions.

Business implications.

Golden Rule

Never accept a critical result simply because it sounds confident.

Microsoft Copilot Masterclass 2026Slide 38 / 50
Plans39 / 50

Microsoft Copilot Plans Explained

Know What You Are Paying For

Free Copilot

General AI assistance. Usage limits may apply.

M365 Personal/Family

Eligible apps. AI benefits restricted to owner on Family plan.

M365 Premium

Higher-tier AI capabilities and allowances.

Business & Enterprise

Capabilities depend on M365 plan, assigned Copilot licence and administrator settings.

Important

Check current plan details and regional pricing before purchasing.

Microsoft Copilot Masterclass 2026Slide 39 / 50
Plans40 / 50

Copilot Chat VS Microsoft 365 Copilot

Understand the Difference Before You Upgrade

Copilot Chat

  • AI chat for eligible accounts.
  • Web-grounded assistance where supported.
  • File/tool capabilities depend on experience.

Microsoft 365 Copilot

  • Additional app-specific capabilities.
  • Work-data grounding where licensed.
  • Advanced workplace workflows.
Key Lesson

Microsoft 365 access does not automatically mean every Copilot feature is included.

Microsoft Copilot Masterclass 2026Slide 40 / 50
Troubleshooting41 / 50

Can You Use Copilot in Desktop Office?

Yes, If Your Account and Subscription Are Eligible

If the button is missing:

1. Check signed-in account.

2. Verify subscription/licence.

3. Update Office.

4. Review privacy settings.

5. Check org policies.

6. Consult MS docs.

Important

Do not assume that every Microsoft 365 subscription provides identical desktop AI features.

Microsoft Copilot Masterclass 2026Slide 41 / 50
Limitations42 / 50

Copilot Limitations You Must Know

  • AI can generate incorrect information.
  • Calculations require validation.
  • File access depends on permissions.
  • Usage limits vary by plan and feature.
  • Not every account has the same tools.
  • Shortcuts may not work everywhere.
  • Agent creation may need admin access.
  • AI doesn't auto-execute every action.
Professional Practice

Verify, test and review before relying on important outputs.

Microsoft Copilot Masterclass 2026Slide 42 / 50
Ethics43 / 50

Privacy, Security & Responsible AI

Use AI Responsibly

Accounts

Use authorized accounts.

Policies

Follow org security rules.

Sharing

Review file permissions.

Confidentiality

Protect sensitive info.

Verification

Check facts/math.

Review

Check before sending.

Accountability

Apply human approval to decisions.

Remember

Productivity without responsible data handling creates risk.

Microsoft Copilot Masterclass 2026Slide 43 / 50
Project44 / 50

Capstone Project: Business Sales Analysis

Your Practical Copilot Challenge (Using a sample sales workbook):

1. Inspect data.

2. Identify missing values.

3. Analyze performance.

4. Calculate gross profit.

5. Compare monthly trends.

6. Prepare executive report.

7. Create PPT outline.

8. Draft email.

Final Deliverable

A reviewed report, presentation outline and email.

Microsoft Copilot Masterclass 2026Slide 44 / 50
Project45 / 50

The Master Business Workflow Prompt

The ultimate prompt to complete the capstone challenge:

Act as a business productivity consultant. Analyze the provided sales workbook. First, inspect the available columns and identify data-quality issues. Second, calculate relevant metrics using the available data and explain the formulas. Third, summarize validated findings, trends, risks and limitations. Fourth, prepare an executive report and a 10-slide management presentation outline. Finally, draft a professional email summarizing the conclusions and next steps. Do not invent figures. Clearly identify missing information, assumptions and items requiring manual review.
Microsoft Copilot Masterclass 2026Slide 45 / 50
Summary46 / 50

The Biggest Mistakes Copilot Users Make

❌ Writing weak prompts.

❌ Assuming every feature is available.

❌ Confusing revenue with profit.

❌ Accepting unverified citations.

❌ Sharing confidential data in unauthorized environments.

❌ Assuming @ and / work everywhere.

❌ Confusing Chat with licensed M365 Copilot.

❌ Trusting every generated recommendation.

❌ Failing to verify the final result.

Microsoft Copilot Masterclass 2026Slide 46 / 50
Roadmap47 / 50

Your Basic-to-Advanced Learning Roadmap

L1
Beginner

Navigate Copilot and write clear prompts.

L2
Intermediate

Use structured prompts, files and personalization.

L3
Advanced

Work with agents and Microsoft 365 apps.

L4
Professional

Build repeatable workflows, verify results, apply governance.

Your Challenge

Improve one repetitive task every day.

Microsoft Copilot Masterclass 2026Slide 47 / 50
Quiz48 / 50

Test Your Knowledge

Q1: What makes a prompt effective?

A. More words without context.
B. Clear goals, context, constraints, format.
C. Unrelated questions.

Correct: B

Q2: Does M365 include every feature?

A. Yes.
B. No, depends on plan, licence & config.

Correct: B

Q3: Before using AI financial analysis?

A. Accept it immediately.
B. Verify formulas, data and assumptions.

Correct: B

Microsoft Copilot Masterclass 2026Slide 48 / 50
Microsoft Copilot Masterclass 2026Slide 49 / 50
Thank You

Microsoft Copilot Masterclass 2026

"Learn. Experiment. Verify. Improve."
Use AI to work smarter, create better and solve real problems.

Presented by Nirmal Rabari

Subscribe for more practical AI tutorials and technology training.

Microsoft Copilot Masterclass 2026Slide 50 / 50