Forum Discussion
M365 Copilot in Excel and PowerPoint
Can M365 Copilot structure the unstructured data in Excel for us? Can M365 Copilot design my PowerPoint based on a certain template adhering to the brand and the guidelines? Currently, we have a...
In order to do more analyzing, we will need to first restructure the data, right? What if we want M365 to help us structure the unstructured data in Excel as it takes a lot of our time, then analyze it? Currently we cannot do that. Any suggestions or updates on this part?
By structured do you mean in a Table vs not? I have seen Copilot prompt me it works with Table data and do I want to it to make a table.
- Yes, I have raw data in Excel which are not in the form of proper tables. I'd like Copilot to help me structure those into tables to further analyze the data.
I asked Excel Copilot if it can make a table. This is the response I got. So you may just need to send it a prompt with the data you need to make a table. May need a small table in the workbook to get Excel Copilot activated.
"Sure, I can help you create a table. Do you have any specific data or information that you would like to include in the table? Also, could you please specify the format and layout of the table you have in mind?"- This is interesting. I will share this with my team. Thank-you Chris.