daBongo LMS AI Training Courses

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.