Forum Discussion
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...
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
I’d try a couple of things:
- if you see “advanced analytics” in the starter prompts in Excel, start there. It’ll introduce Python which should help with text
- you could also try using business chat and reference the file there. I’ve found that to be more helpful for text in Excel files
