Claude with Microsoft 365: Two Workflows That Save Hours
Nobody signs up for one of my classes because they cannot find a menu. They sign up because of Monday morning. The numbers are sitting in an Excel export, the decisions are buried in a Teams meeting nobody wrote down, and somebody needs a clean summary in their inbox by noon. Learning to use Claude with Microsoft 365 is the piece most people are missing, and it does not require installing a single thing.
Here is what surprises people in my sessions: Claude does not bolt onto Excel the way Copilot does. There is no ribbon button. You copy something out of Office, you paste it into Claude, and you paste the result back. It sounds low-tech. It is also fast, and it works no matter which license tier your company actually bought.
These are the two workflows I demonstrate most often, and they are the two that people tell me they started using that same afternoon.
Tip 1: Use Claude with Microsoft 365 to Turn a Raw Excel Export Into a Written Summary
Think of the report you rebuild every month — the export out of your accounting system, your CRM, your ticketing tool. The numbers themselves are fine. The problem is that a human being has to read them and write three paragraphs explaining what happened.
In Excel, select the data range including the header row and press Ctrl+C. Paste it straight into Claude. Excel copies as tab-delimited text, so Claude receives real columns and rows, not a picture. For anything over a few thousand rows, use File > Save As > CSV UTF-8 and attach the file instead. Then give it a prompt with the shape of the answer already baked in:
Here is a sales export. The columns are Region, Rep, Month, Units, Revenue. Give me: (1) three sentences on what changed versus the prior month, (2) the two regions that moved the most and by exactly how much, (3) a bulleted list of anything that looks like a data-entry error. Do not round the revenue figures. If something cannot be answered from this data, say so.
What makes this worth doing is not the speed. It is item three. Claude will flag the negative quantity, the invoice number that appears twice, the region spelled two different ways in the same column. That is exactly the stuff that gets caught in the meeting, after you have already sent the report around.
The gotcha: do not paste a screenshot of the sheet. A picture leaves the AI squinting at your numbers, and that is where wrong figures come from. Paste the actual cells or attach the CSV. And strip out customer names, account numbers, and anything else your company policy says should not leave the building before you paste it anywhere.
Tip 2: Turn a Teams Meeting Transcript Into an Owner-by-Owner Action List
The recap email after a project meeting is one of the great time sinks of office life. Forty minutes of scrolling back through your own notes, trying to remember who agreed to what.
If the meeting was recorded in Teams, the transcript already exists. In Teams go to Calendar, open the meeting that already happened, click the Recap tab, and under Transcript choose Download and pick the .docx or .vtt file. Attach that file to Claude and ask for structure, not a summary:
This is the transcript of a 45-minute project meeting. Produce: (1) a table of decisions with who made each one, (2) a table of action items with owner and due date, one row per item, (3) a list of anything raised that was never resolved. If an owner or a date was never actually stated out loud, write "not stated" — do not infer it.
Copy the tables out of Claude and paste them into an Outlook message. Outlook keeps the table formatting, so a recap that used to eat most of an hour goes out in about five minutes — and the “never resolved” list is usually the most valuable part, because those are the items that quietly fall off the edge of the project.
The gotcha: transcripts misattribute speakers when two people talk over each other, so read down the owner column before you hit send. And do not drop that “not stated” instruction. Without it, an AI will helpfully assign a Friday deadline that nobody in the room ever agreed to.
Plenty more on the calendar
If you want to see both of these done live, with your questions answered as we go, I am running Claude + Microsoft 365 on Monday, August 31. We spend the session moving real work between Claude and Excel, Word, Outlook and Teams — the prompts, the copy-and-paste mechanics, and where the guardrails belong.
The full current schedule is right on the front page of PCWebinars.com, and new dates go up as they are confirmed. Register for this one, or have a look through the others and find the topic that matches the thing eating your week.
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 any of that sounds useful, come find the next session that fits you at PCWebinars.com.
