From the course: Project Management with Microsoft Copilot

Unlock the full course today

Join today to access over 24,700 courses taught by industry experts.

Analyzing vendor performance

Analyzing vendor performance - Microsoft Copilot Tutorial

From the course: Project Management with Microsoft Copilot

Start my 1-month free trial Buy for my team

Analyzing vendor performance

“

- [Instructor] Holding vendors to their commitments helps ensure quality on your project. Copilot can help us by evaluating vendor performance. In this scenario, I'm in Excel desktop and I'm tracking vendors for on-time delivery and quality with the Delivery Failure column and the Number of Delivery Failures. Let's click Copilot. I want to know if any of my vendors are inconsistent performers who I can't rely on. And let's press the Enter key. I have Copilot looking for delivery failures of yes. And let's take a look. So it said it could add it to a new sheet, let's click on that option. Also as a tip, that new sheet it created is a PivotTable and there are some limits with Copilot and PivotTables. Let me scroll back so you can review that message. Well, now I have a list of vendors I need to take some action on. Can Copilot give me some assistance? Let's find out. And I'll press the arrow, and here we are. Copilot gave it best practices for vendor management, and we can feel free to…

Contents