Forum Discussion
NotMyThing
Nov 14, 2024Copper Contributor
Such a disappointment
One of my team members recently left, and with a critical meeting coming up next week, I had to step into the role quickly. I thought MS Copilot could assist with updating Excel and PowerPoint, but i...
HelloBenTeoh
Nov 22, 2024Bronze Contributor
As you've found, right now, Copilot can't do it. I'd recommend getting to know the basics of what it can do with the recommended prompts and work from there.
But just some thoughts from my experience:
In Excel:
- Outside of formatting, Copilot won't updated existing data, but you can create new columns etc based on formulas. Honestly, I think this if for the best. When you have exact data, I wouldn't necessarily want a LLM generating content.
- I don't think it does a great job at analysing existing pivot tables. You'd need to go back to the original data.
- Out of all the M365 products, I've found that you need to be a lot more specific with Excel to get the result. I usually need to iterate on what I've done a couple of times to be clearer with what I want.
In PowerPoint
- Again, not currently great with editing content on a slide. Hopefully the new changes announced at Inspire will address this.
- It's been a bit hit and miss trying to work outside of the set examples provided in the prompt ideas and standard