From the course: Copilot for Project Management: Build an AI-Powered Budget Tracker and Forecaster (No Code Required)

Unlock this course with a free trial

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

Measuring actual versus planned days with a Copilot prompt

Measuring actual versus planned days with a Copilot prompt - Microsoft Copilot Tutorial

From the course: Copilot for Project Management: Build an AI-Powered Budget Tracker and Forecaster (No Code Required)

Start my 1-month free trial Buy for my team

Measuring actual versus planned days with a Copilot prompt

“

- [Instructor] Just as we measured the variance for our project budget earlier in this course, we can also ask Copilot to help us measure the variance between a project's planned versus actual days. With the project plan in view that Copilot helped us create in the previous video, we're going to start by going to Copilot on the home ribbon and then we'll enter our instruction here. Now, there's several ways that you could phrase this instruction. We could say something like, measure the variance between the actual start and end dates and the estimated start and end dates. We're going to enter a more simplified instruction that says, measure the variance between the actual dates and the estimated dates. We'll send that through, Copilot returns a suggestion. Let's go ahead and review it. So let's scroll back to the top. Here's the original prompt and here's the response. It's letting us know the range that it's looking in, and that it has two columns for us to review before we insert…

Contents