Such a disappointment

Bonjour 
Je n'arrive pas à comprendre les articles qui font l'éloge de copilot 
L'avantage de copilot intégré à office 365 serait justement son intégration aux outils microsoft ...

Dernier exemple en date, j'ai un fichier word d'une trentaine de pages,

je demande à copilot s'il peut me générer des titres et sous-titres pour rendre plus lisible le document...
Il me répond qu'il ne peut pas le faire mais qu'il peut me dire comment je peux m'y prendre...
(je n'ai pas besoin de copilot pour savoir comment créer des titres et des sous-titres...)

je fais la même demande à Chatgpt. Quelques secondes plus tard, il m'a recréé un fichier word avec une vingtaine de titres et sous-titres. Après vérification, je ne trouve pratiquement rien à modifier.

Je me dis que je dois avoir un problème dans mon environnement, comment un outil dont le point fort est l'intégration aux outils microsoft peut-il être aussi mauvais par comparaison avec un autre outil qui n'est pas censé l'être (intégré aux outils microsoft) ?

Je n'ai toujours pas trouvé le moindre intérêt à copilote dans office. Cela fait donc un peu râler de payer un supplément non négligeable pour une fonctionnalité qui n'apporte rien...

Mais peut-être y at-il une manip à effectuer pour que le copilote serve à quelque chose ? 
Si vous pouviez m'éclairer ?
Merci bien pour vos conseils
Philippo

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

It seems a bit hit and miss in my experience.  Really finding it hard to promote due to the non consistent performance and accuracy of returns and using Excel/Outlook/Powerpoint benefits for desktop apps seems more issue than it's worth atm.  It also seems to have issues now with analyzing pictures and doesn't seem to recognize pic files (upon further investigation it doesnt seem to support them, but am sure it did at one stage).  AND another issue is besides these forums there doesn't seem to be one place of truth about what is going on with Copilot which feels a little like being left in the lurch with it.  I understand the sentiment of this poster.

We've been using Copilot and training orgs on Copilot for the better part of the year - it's very counterintuitive when trying to figure out what Copilot can and can't do. For Excel, it can only analyze the tables, not the data once composed as a pivot table. You may want to check out the Copilot Lab (make sure you're logged in with your work account as it shows more options). https://copilot.cloud.microsoft/ It may help you from ripping out your hair as you get used to it. I hope this helps.

I'm here to commiserate. I'm trying to analyse survey results in an Excel spreadsheet. I cannot get a response from CoPilot on any of the text (try again later!) so I'm cutting and pasting text into a Word document and trying to run in there. CoPilot seems to analyse no more than 3 pages at a time; the document of survey responses is 84 pages.

Using "Find" on search terms, and writing down the number of instances is getting me farther along on the top ten issues.  SMH