6 Real Ways I Used Microsoft Copilot and Cowork This Week (Real Work, No Canned Demos)

TL;DR: Forget the perfect demos. Here are six real tasks I knocked out this week with Microsoft Copilot and Copilot Cowork. Replying to meeting emails from my real calendar, turning 74 survey responses into boss-ready talking points, tracking down a lost slide deck, dropping a screenshot of my kids’ soccer schedule straight onto my calendar, learning a brand-new feature that had no docs, and co-authoring a statement of work, plus the one habit (validate everything) that keeps it all safe.

Most AI demos are a little too perfect, aren’t they? Clean data, an idealistic scenario, and everything works on the first click. That’s not what real work feels like and sure as heck isn't how my day goes. So this time I’m doing the opposite, no staged demos, just 6 actual things I did for myself this week with Microsoft Copilot and Copilot Cowork, and the productivity I got out of each.

You’ll get the exact prompts I used, where these tools genuinely shine, where they still trip up, and the simple guardrail I put on every single one. Some are big team wins, some are small personal time-savers but all of them are things you can copy tomorrow.

Prefer to watch the full walkthrough? Check out the video here: https://youtu.be/AnqsiqKs8sw

Reply to this email with the times I am actually available to meet

This is the one my whole team got most excited about, and it probably has the widest impact. I get a lot of emails from people who want to meet, and most of them (customers, folks outside the company) don’t have access to my calendar. Bookings tools exist, but I like a reply that feels a bit more personal.

So in Outlook I hit Reply, clicked the Copilot icon, and give it a prompt like: “Help me reply to this email by checking my calendar and listing the times I’m available next Friday. In the response, include the time zone.” Copilot opens M365 Copilot, reads my actual calendar, and drafts a reply with real open times. Awesome!

The gotcha: the magic words are “check my calendar.” Once I started including that part of the prompt, it stopped guessing and it’s been 100% accurate on my availability since. One boundary I hit: I couldn’t get it to reliably pull a second person’s calendar into the same reply. I tried “check my calendar and a coworker’s calendar” on an email that involved both of us, and it never quite nailed the other person’s availability.

And even now, I still validate the times before I send. For the first ten or so replies I checked every one. It’s earned my trust, but I keep verifying. Since I found this, I am using it multiple times a day. 😎 Turns out lots of people like to meet with me.

How do you turn a pile of survey results into talking points for your boss?

As we work to get our arms around how AI is being used across the company, I built a survey in Microsoft Forms and collected 74 responses so far. What tools people are excited about, where AI is helping on client projects, and where they want to learn more. The moment I shared it, our CEO asked for some talking points tied to the survey for an event she was speaking at. She needed them fast.

Reading all 74 responses one by one (which I did) is overwhelming when someone needs an answer right now. So I downloaded the responses as an Excel file, opened Copilot in Excel, and prompted something like: “My boss needs me to review these survey results and give her the key themes, specific quotes of where AI is helping us win, any key stats, and other helpful info she can use in a presentation she’s giving.”

Boom! It surfaced themes, pull quotes, and statistics even including a standout where one team said AI was saving them about 50% on part of their work. Seriously, it did way better than what my analysis was "They are using AI well". 🤣

Here’s the important part: I did not copy, paste, and send. I went in and curated the strongest quotes and the most useful stats, and I still crunched the deeper numbers myself. Copilot didn’t do the thinking for me; it got me the pull quotes and the quick look in minutes so I could hand my boss exactly what she needed. I added the human touch, knowing the stuff she likes and doesn't, the discernment is often overlooked.

Can you use Copilot as a smart search tool to find your files?

This is the least flashy one and the one a lot of people use themost. I was prepping a few slides for a Dynamics user group event and wanted a single image off one specific slide. Problem: I couldn’t find the deck. So I asked Copilot: “I’ve done a session where I talk about sprinkling AI into Power Apps and Power Automate to get started. I don’t remember if I have a PowerPoint deck for that. Can you look for me?”

What makes this better than regular search: it doesn’t just match on the title or the file’s metadata, it looks inside the slides. It pointed me straight to the most likely deck and listed a few other candidates too. Not bad.

If “just using AI for search” is where you start, don’t let anyone talk you out of it. It’s a fantastic on-ramp, and even years in, I still reach for it constantly. Nobody enjoys playing hiding go seek with their data, let Copilot do that.

How do you turn a screenshot into calendar events with Cowork?

My favorite, even if not exactly work. 🤫 This one crosses over into Copilot Cowork, and it’s a perfect example of killing tedious work. My kids’ fall soccer schedule dropped, and I wanted every game on my calendar. In past years I added them one game at a time. This year I took a screenshot with the dates, times, and locations and handed it to Cowork with a rambling-but-detailed prompt: put every game on my calendar, mark them busy, start at the earliest time listed, end two hours after the last time listed, set the subject to Away or Home plus the opponent’s name, and drop both game times in the body (the first is JV, the second is varsity).

A couple of minutes later, done. Then I asked it to add another family member as an invitee across all of their calendars, and it worked through every one. Their time was blocked too.

What did that cost? If you’re curious, type /cost in Cowork and it tells you. Mine used 283 credits. Which is about $2.83 at the pay-as-you-go rate to save me 15 to 20 minutes of manual entry. Easy trade.

And yes, I validated every event afterward. Trust, but verify. The work tie-in is real, too: I travel a lot and work late, and I’m not going to schedule over my kids’ games. Having those blocks on my calendar helps everyone make better decisions when booking my time. AKA back off people!

How do you learn a brand-new AI feature when there’s no documentation?

Cowork just started supporting triggers and there are no docs yet. So instead of hunting around, I asked the tool itself: “I understand you now support triggers. When someone messages me in Teams, for example can you give me a list of the different triggers you support?” It told me it could trigger on email, on Teams messages, and even on a webhook. Then I asked it to explain how the webhook trigger works, and it broke that down for me. A couple of minutes and I was up to speed.

The bigger lesson: use AI to learn AI. Stuck building a skill? Ask it, “How do I build a skill. What should that look like?” About to set up an AI prompt in Power Apps? Ask it what to do. Don’t be afraid to have the tool teach you how to use the tool.

How do you co-author a statement of work and beat the blank-screen problem?

I’m part of a statement of work where I own the AI enablement piece. I am in chagre of delivering AI training for the whole company and for their power users, and keeping them in the loop on what’s happening in the AI space with the tools they use. The trouble: sales and delivery drafted “Shane’s section” with way too much detail, committing me to things I didn’t want to be committed to, and making this slacker work too hard. 🤣 I tried to just rewrite their version, but it was structured in a way my brain couldn’t untangle.

So I took their text over to Copilot, gave it a big run-on paragraph of everything I didn’t like about it, then a second paragraph describing how I’d shape it, and told it to keep their context so it morphed what was already in the SOW instead of starting from scratch. About fifteen to thirty seconds later, I had a new AI enablement section.

No image for this one, SOWs seem dicey to share.

Then the part that matters: I didn’t just ship what it wrote. I massaged it into my own voice. I even dumbed some of it down so it sounded like me and not an AI. That’s co-authoring, not outsourcing. The real win is that it got me off the blank screen and into a structure I could actually sculpt. (I went deeper on this idea of AI slop vs. AI dribble vs. AI boost in last week’s video, if you’re fighting the blank-page problem with content.)

Frequently asked questions

What’s the one prompt trick that makes Copilot’s calendar replies accurate?

Tell it to “check my calendar.” Without that instruction, Copilot may suggest meeting times without reading your real availability. Adding it forces Copilot to pull your actual open slots and it’s worth including your time zone in the prompt as well.

Can Microsoft Copilot check someone else’s calendar in the same reply?

In my testing, not reliably. Even with access to a coworker’s calendar, Copilot handled my own calendar perfectly but wouldn’t consistently pull a second person’s availability into one reply. Verify anything that depends on more than one calendar.

How much does a task in Copilot Cowork cost, and how do I check?

Type /cost in Cowork and it shows the credits used for what you just did.

What triggers does Copilot Cowork support?

Based on what Cowork told me directly, it can trigger on email, on Teams messages, and on a webhook. Because these features are changing quickly, the best move is to ask Cowork for the current list rather than relying on a static answer.

Should I just copy and paste whatever Copilot writes?

No. Every single time, I rewrite the output by picking the best quotes, cutting overcommitments, or putting it in my own voice. AI gets you a strong first draft fast; you’re the one who makes it correct and makes it sound like you.

Key takeaways

• Add “check my calendar” to any Copilot email-reply prompt so it uses your real availability instead of inventing times and include your time zone.

• Copilot can turn dozens of survey responses into themes, pull quotes, and stats in seconds, but you should always curate before sharing.

• Copilot search looks inside file content, like slide text, which makes it far better than title-only search for finding a lost deck.

• Copilot Cowork can read a screenshot and create calendar events from it.

• When a feature has no documentation, ask the AI tool to explain its own capabilities. That’s how I learned Cowork’s email, Teams, and webhook triggers.

• Beat the blank-screen problem on documents like SOWs by having AI reshape existing text, then rewrite the draft in your own voice. But, be sure to co-author, don’t copy-paste.

• Always validate AI output. Trust, but verify.

  
  

Need help making sense of the AI story?

If figuring out your AI story feels like a lot right now, you’re not alone. I’m having this exact conversation every week with CTOs, VPs of IT, and AI leaders, helping them make sense of the Microsoft side of AI. If you’d like help with your AI enablement the team at PowerApps911 can help. Reach out by clicking the Contact button and let’s figure it out together.