Microsoft Copilot tips, prompts and shortcuts 🪄
Learn how to save time in Outlook, Teams, Word, Excel and PowerPoint with Copilot.rishonapowerplatform.comJoined September 2026
An inherited spreadsheet full of mystery formulas doesn't need to be reverse engineered cell by cell.
Open Copilot in Excel and ask:
"Explain all of the formulas used in this spreadsheet and their purpose"
You'll get a plain English breakdown of what each part does.
One-shot with Opus 5.5 💪
I gave it images of sewing pattern instructions, and asked it to turn it into a visual, step-by-step guide for a beginner.
Even added in a sizing calculator!
A table pasted into your Word doc as an image can't be sorted, edited or updated. Ask Copilot to read the image and rebuild it as a real table.
PROMPT 🖊️
"Turn the table in the selected image into an editable table"
Coming back to a document full of open comments is overwhelming. Ask Copilot in Word for a review summary first 💬
PROMPT:
"Go through all unresolved comments and create a short Review Summary section at the top that captures (1) proposed changes in the document and (2) open questions from comments"
When every stock photo starts to look the same, describe the visual you need and let Copilot in PowerPoint create it for your slide. Then refine it with follow up prompts.
PROMPT:
"Create an image for slide [number] showing [description], using the colours in this presentation"
Typing a table of contents by hand means fixing page numbers at the end. Ask Copilot in Word instead:
"Insert a table of contents"
It's built from your heading styles, so it can be updated as the document changes.
Try it in Word Online: word.cloud.microsoft
The Copilot in PowerPoint skill "Create Interactive Slides" is starting to roll out more widely now. I've used for creating an icebreaker activity for a training session and turning raw data from a spreadsheet into a dashboard. It can even create a cooking tutorial 🥪
Found the perfect icon in the wrong colour? Select it, open Copilot in PowerPoint and type:
"Update the colour to [colour/hex code/or attach your brand kit]"
Copilot can reuse images and icons and apply them throughout your PowerPoint presentation. Try this prompt:
"Use the icons on slide [number] throughout the presentation to make the slides more visually appealing. You do not have to use all icons, and you can reuse the same one. Make sure the icon used represents the content discussed on the slide."
Create icons for your PowerPoint presentation 🪄
To make your presentations more visually appealing, ask Copilot in PowerPoint to generate a set of icons for you.
PROMPT:
"Add a slide at the end with 20 business related icons, using the same colour palette as this presentation. make sure they have a transparent background."
Need to know who in your organisation has worked on something similar?
In Copilot, run the prompt with Work IQ on:
"Who has been involved in conversations or documents about [topic]?"
"I want to learn about the types of things Copilot in Excel can do. Can you generate a spreadsheet with mock data for me, then give me a list of 20 prompts I can try, which demonstrate your capabilities for a casual Excel user like me."
You don't have to test Copilot on your real work spreadsheets.
If you're looking for extra practice, ask it in Excel to build a practice workbook with mock data. You get a safe sandbox and a guided tour of what it can do, all in one go.
Prompt in the reply ⬇️
Fixing "Last, First" names one cell at a time in Excel is time you won't get back. Ask Copilot in Edit mode:
"Create a new column that shows people's first names, then a space, then their last names."
It works for splitting [email protected] email addresses too.
You shouldn't have to explain job to Copilot at the start of every chat. Tell it once:
"Remember that I [explain your common tasks/audience/other context about you]"
Copilot can then shape its future responses around that.
Your PowerPoint already has the approved messages, structure and visuals.
The only thing missing is you presenting it.
Copilot can write the narration, add a voiceover and turn the deck into a video people can watch without a live presenter.
Check out how Create feature can generate videos from your presentations within minutes: rishonapowerplatform.com/2026/08/27/tur…
@DerekJohnsonSV I've been seeing so many incredible creations with this. I'm glad we'll no longer be stuck watching presentations that are a block of heavy text on a slide 🙌
It's usually web browser version of the Microsoft apps that get the new Copilot features first.
If you are waiting for a new feature to drop, check if it's available there first. You can access all the browser apps (Word, PowerPoint, Excel, Outlook) from here m365.cloud.microsoft/apps
After running a task in Copilot's Researcher, try the "Infographic" option. It can take the detailed findings from Researcher and turn it into shareable overview.
123 Followers 847 FollowingFollower of Christ, Dawn's Husband, Eric & Audrey's Dad, Prosecutor, IndyCar & Chiefs fan. 🏁RT's or likes don't mean I always agree. Mexico, Missouri, USA.
1K Followers 117 FollowingEVP, Office Product Group at Microsoft | Reimagining work with Microsoft 365 Copilot across Word, Excel, PowerPoint, Outlook, ClipChamp + OneNote
439K Followers 4K FollowingBehind every transformation is a person finding a way forward. ✏️ Stories from educators and students using Microsoft tools to learn and teach.
43K Followers 728 FollowingThe official account of the Microsoft 365 Insider Program.
Join us and help shape the future of Microsoft 365. Find us on LinkedIn: https://t.co/6ti7pekGuE
4K Followers 518 FollowingThe pilot of Copilot | Microsoft MVP 🏆 | Power Platform Expert 🚀 | low code & AI orchestrator | Autonomous agents work 24/7, are cheaper and smarter than you