Forum Discussion

Ibakordor's avatar
Ibakordor
Copper Contributor
Feb 12, 2024

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 hard time using M365 Copilot in Excel as it is not that helpful as we need to first structure our data to get more insights.
For M365 Copilot in PowerPoint, the design is not as how I expected when it generated a PPT, also it is not able to design based on the template I shared.

What are the upcoming updates? Will M365 Copilot be further improved?

  • frankfalvey's avatar
    frankfalvey
    Iron Contributor
    Certainly! Microsoft Copilot in Excel is designed to assist you in making the most of your data within Excel tables. Here’s how it can help: Formula Column Suggestions: Copilot generates formula column recommendations, making it easier for you to create calculated columns based on your data. Insights in Charts and PivotTables: Copilot can provide insights by suggesting relevant charts or PivotTables based on your data. This helps you visualize patterns and trends more effectively. Highlighting Interesting Portions of Data: Copilot identifies significant data points, allowing you to focus on relevant information and gain deeper insights.
    • Ibakordor's avatar
      Ibakordor
      Copper Contributor
      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?
      • Chris_Ferraro's avatar
        Chris_Ferraro
        Steel Contributor

        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.

Resources