daBongo LMS AI Training Courses

← Back to Course

Mastering Copilot – Microsoft 365 Integration and Power-User Workflows

Lesson 2: Copilot in Word, Excel, and PowerPoint – Documents, Data, and Presentations

Lesson Objectives

By the end of this lesson, students should be able to:

  • Use Copilot in Word to draft, revise, and summarize documents (where available)
  • Use Copilot in Excel to analyze data, explain formulas, and surface insights (where available)
  • Use Copilot in PowerPoint to generate presentations from prompts and documents (where available)
  • Apply appropriate review and verification habits specific to each application

Lesson Content

**Feature Availability Notice**: The features described in this lesson require Microsoft 365 Copilot. Specific in-app features vary by subscription tier. Verify your access at microsoft.com. Copilot in Excel data analysis features are especially subject to change and evolving capability.

Copilot in Word – document creation and revision.

Where available, Copilot in Word can:

  • Generate a document from a prompt or brief: Describe what you need, and Copilot can draft a full document structure
  • Transform and revise sections: Rewrite selected content with different tone, length, or style
  • Summarize long documents: Get a concise summary of a long document without reading the full text
  • Reference other Microsoft 365 content (where configured): Generate content that references your organization's existing files, data, and knowledge (subject to access permissions)

Effective use: apply the architecture-first workflow from the writing course before asking Copilot to generate long documents. A brief-driven generation produces far better first drafts than "write me a report about X."

Copilot in Excel – data analysis.

Where available, Copilot in Excel can:

  • Analyze data and surface insights: "What are the top trends in this dataset?"
  • Explain formulas: Paste a complex formula and ask for a plain-language explanation
  • Generate formulas: Describe what you want to calculate in plain language and receive a formula
  • Create charts and visualizations: Request a chart type and Copilot can build it

Critical Excel verification step.

AI-generated formulas and data analysis are not guaranteed to be correct. Before presenting any Copilot-assisted Excel analysis:

  • Verify formulas manually with a small test dataset
  • Check calculated totals against known values
  • Verify that the analysis is drawing on the correct data range
  • Have a colleague review high-stakes financial models

Copilot in PowerPoint – presentations.

Where available, Copilot in PowerPoint can:

  • Generate a presentation from a prompt: "Create a 10-slide presentation on [topic] for [audience]"
  • Generate a presentation from a Word document: Convert your document into a structured slide deck
  • Suggest design improvements: Redesign slides for better visual clarity
  • Summarize existing presentations: Get the key points from a long slide deck

Critical PowerPoint review step.

Copilot-generated presentations: verify every factual claim on every slide, review all automatically generated data visuals for accuracy, and ensure the narrative arc of the presentation serves your specific audience and purpose. Auto-generated presentations are starting points – not finished deliverables.

Practical Example

A senior analyst needs to convert a 20-page market analysis report into a 10-slide executive presentation.

He uses Copilot in PowerPoint to generate the initial deck from the Word document.

The result: a structurally sound 10-slide deck with the right sections – but with several slides where the AI summarized too aggressively and omitted key nuance.

He reviews every slide: keeps 6 as strong starting points, substantially revises 3, and rewrites 1 from scratch.

Total time: 40 minutes from report to final presentation, versus 3 hours from scratch.

Lesser-Known Tip

In Excel, when Copilot generates a formula, ask a follow-up: "Walk me through step by step what this formula is doing and why." This surfaces any misalignment between what you described and what the formula actually calculates – before you apply it to your real data.

Safety Notes

Copilot-assisted financial analysis in Excel carries specific risk: AI-generated formulas can appear correct while calculating incorrectly. Never present Copilot-generated financial analysis to leadership or clients without independent verification against known values. For high-stakes financial models, have a qualified analyst verify the formula logic end-to-end.

Log in and enroll to access lesson quizzes.

← Back to Course

Scroll to Top