One office worker who struggles with Excel formulas said Copilot helped them build spreadsheets in minutes that would otherwise have taken days, and in PowerPoint it was handy for making small design changes across lots of slides at once.
In this presentation, [CHANGE, E.G. MAKE ALL SLIDE TITLES THE SAME FONT AND SIZE, AND MOVE THE LOGO TO THE BOTTOM RIGHT] on every slide except [SLIDES TO SKIP]. Then list what you changed so I can check it.
Replace the [PLACEHOLDERS] with your own details before you send it.
How to try it
- Open the file in PowerPoint or Excel with Copilot switched on (your workplace licence needs to include it).
- Describe the change or calculation you want in plain words, one task at a time.
- Check a few slides or formula results by hand before you send the file on.
More work use cases
Tailor your CV to a job advert with ChatGPT
A consultant's main CV advice to one jobseeker was to paste the job listing and CV into ChatGPT and ask it to reword the CV to get past automated filters. The jobseeker found that advice demoralising, so treat it as a tool, not a substitute for your own judgement.
Here's a job advert: [PASTE]. Here's my CV: [PASTE]. Show me which requirements in the advert my CV already covers, which are missing or buried, and suggest honest rewording of my existing experience to match the advert's language. Don't invent skills or experience I haven't listed.
Turn a week of rough notes into a weekly update with ChatGPT
On Hacker News, one worker said his company's weekly update format is a pain, so he keeps notes through the week and sends them to a custom GPT that writes the update in the required template. He spends about ten minutes tidying it, saving a couple of hours.
Turn these rough notes from my week into a weekly update using exactly this template: [PASTE TEMPLATE]. Notes: [PASTE NOTES]. Keep it factual, don't add anything that isn't in my notes, and flag any section where I haven't given you enough information.
Get answers from a huge spreadsheet with Copilot in Excel
One user said Microsoft Copilot took a 400,000-line Excel file and a single ten-word prompt and saved him three hours.
In this data, [QUESTION, E.G. WHICH 10 CUSTOMERS HAD THE BIGGEST DROP IN ORDERS THIS YEAR VS LAST?]. Show the result as a table and explain how you worked it out.
Reference: X @BangSwitch5000