Copilot for Project Management: From Kickoff Notes to Plan - PC Webinars blog post

Copilot for Project Management: From Kickoff Notes to Plan

Most project managers I meet in class are not short on tools. They have a tracker, a shared folder, a recurring meeting, and a chat channel. What they are short on is the half hour after every meeting where somebody turns forty minutes of talking into a list of who owes what by when. That half hour never gets scheduled, so it gets done badly, late, or not at all.

That gap is exactly where Copilot for project management earns its keep. Not as a strategy consultant, and not as a replacement for knowing your project — as the thing that reads the transcript you already have and the tracker you already keep, and hands back the boring part in a form you can act on.

Here are two specific ways to do it. Both use what is already on your screen, and either one takes about ten minutes to try.

Copilot for Project Management: Turn a Kickoff Into a Task List

After a Teams meeting, go to Teams → Calendar → open the meeting that already happened → the Recap tab. Copilot sits in a pane on the right. Most people ask it “summarize this meeting,” get a tidy paragraph, and stop there. A paragraph is not a plan.

Ask for the structure you actually need instead:

List every commitment someone made in this meeting. For each one, give me the owner, exactly what they agreed to deliver, and any date that was mentioned. Put it in a table with columns Owner, Deliverable, Date, and Quote. In the Quote column, paste the line from the transcript where they said it. If no date was mentioned, write "none stated."

Two things make that prompt work where the generic one fails. The Quote column gives you a spot check — you can see the sentence Copilot built each row from, so you are verifying in ten seconds instead of re-watching the recording. And “if no date was mentioned, write none stated” is the instruction that stops it from quietly inventing a deadline. Left to itself, an AI asked for a date column will produce dates. Tell it what to do with the blanks and it leaves them blank.

What comes back is a table you can paste straight into Planner, To Do, or the tracker you already use. The rows reading “none stated” are your follow-up list — the commitments that sounded firm in the room and were not.

The gotcha: Copilot reads the transcript, not the recording. If nobody turned on transcription, the Recap tab will show you attendance and nothing else, and Copilot will tell you it has no content to work from. Transcription is a separate toggle from recording. Turn it on once in your recurring meeting series and you stop thinking about it.

Make Copilot Read the Tracker You Already Keep in Excel

The second place this pays off is the spreadsheet where your tasks actually live. Open it, click anywhere in your data, and press Ctrl+T to format it as a table. Then go to the Home tab and click the Copilot button on the right side of the ribbon.

Now ask it to do arithmetic you would otherwise do by eye:

Add a formula column called Days Late that subtracts Due Date from Actual Finish, and leaves the cell blank when Actual Finish is empty. Then show me every row where Days Late is greater than 5, grouped by Owner.

Copilot writes that column into the sheet as a real formula — you can click the cell and read it, which matters, because a number you cannot audit is worthless in a status meeting. The grouped view is the useful part: it stops being “the project is behind” and becomes “four of the six late items belong to one team, and that team owns next week’s dependencies.” That is a conversation you can have with a sponsor.

A few prompts worth keeping in the same file:

  • Highlight every row where the Due Date is in the next 7 days and Status is not Complete.
  • Which owners have more than three open tasks due in the same week?

The gotcha: two conditions have to be met or the Copilot button does nothing useful. The data must be a genuine Excel Table, not a rectangle of cells with bold headers — that is what Ctrl+T does. And the file must be saved to OneDrive or SharePoint with AutoSave on; on a file sitting in your Downloads folder, Copilot politely declines. That second requirement is behind most of the “it doesn’t work for me” emails I get.

Plenty more on the calendar

I am running a live session on this, How to Use Copilot for Project Management, on Wednesday, November 18. We go further than the two prompts above — building the task table out of a real meeting recap, wiring it into a tracker, and the prompts that keep a status update honest when dates start moving. You can find it, and register, on PCWebinars.com.

The full current schedule lives on the front page of the site, and new dates go up as they are confirmed — usually something on Excel, Power BI, Copilot, Claude, or ChatGPT within the next week or two. Register for this one, or browse the others and pick the session that matches the problem on your desk right now.

About your trainer

I am Tom Fragale. I have been a computer trainer and consultant for more than 30 years, and I have taught well over 30,000 people how to get more out of the software they already own — Excel, Access, Power BI, Word, Outlook, and now the AI tools that sit on top of all of it: Claude, ChatGPT, and Microsoft Copilot.

My background is applied, not theoretical. Alongside teaching, I build real databases and reporting systems for clients in Excel, Access, and Power BI, so the examples I use in class are the problems I ran into last week, not textbook exercises. I also publish free tutorials on YouTube and longer courses online.

If something here was useful, there is a lot more of it waiting for you at PCWebinars.com.

Similar Posts

Leave a Reply

Your email address will not be published. Required fields are marked *