Microsoft · AB-730
Copilot in Word, Excel, and PowerPoint
AB-730 · Lesson 5 of 8 · 31:30
YouTube loads only after you press play. This chapter opens at its timestamp in the full course. Watch on YouTube ↗
In this lesson
Prepare for the AB-730 exam (Microsoft Certified: AI Business Professional). In this lesson: Draft with Copilot and Edit with Copilot in Word, preparing data for Copilot in Excel and Copilot with Python, Idea Coach and the Allow editing and Chat only modes in PowerPoint, images, Copilot connectors (synced or federated), insights with Work IQ, and checking drafts against sources and goals. Includes three original practice questions.
Preview the topics
- Copilot in Excel will not sort or filter a sales sheet that has merged cells and blank rows, and that is saved on a laptop’s desktop. What should the analyst do first?
- A manager must present to regional executives with different priorities, and does not know yet which three messages to lead with. Which tool should they use first?
- A sales team wants Copilot to answer questions using customer records stored in their CRM, outside Microsoft 365. What makes that possible?