Copilot for Excel

Question

Can we use copilot for m365 to compare two different ezcel tables? Can i use copilot for m365 to fetch data from a word file and fill an excel sheet? What actions can i do with an excel sheet?

Answer 1

Yes, you can use Copilot for Microsoft 365 to perform various tasks with Excel sheets, including comparing two different Excel tables and fetching data from a Word file to fill an Excel sheet. Here are some details on how you can use Copilot for these tasks:

1. Comparing Two Different Excel Tables: Copilot in Excel can help you compare two different tables by generating insights, highlighting differences, and suggesting formula columns for complex calculations. You can use Copilot to analyze and visualize your data, making it easier to identify discrepancies between the tables
2. Fetching Data from a Word File and Filling an Excel Sheet: Copilot can assist you in extracting data from a Word document and populating it into an Excel sheet. This can be particularly useful for tasks such as transferring structured data from a report or document into a spreadsheet for further analysis
3. Other Actions with an Excel Sheet: Copilot in Excel offers a wide range of functionalities to help you work more efficiently with your data. Some of the key actions you can perform include: Generating Formula Column Suggestions: Copilot can suggest formulas for new columns based on the data in your table Highlighting, Sorting, and Filtering Data: You can use Copilot to effortlessly highlight, sort, and filter your data to focus on what matters most Creating and Editing Data: Copilot can help you create and edit data, making it easier to manage and organize your information

Analyzing and Visualizing Data: Copilot can generate insights, charts, and PivotTables to help you understand and visualize your data better.

Answer 2

Hi @Syed Ahmed

Microsoft Copilot in Excel helps you do more with your data in Excel tables by generating formula column suggestions, showing insights in charts and PivotTables, and highlighting interesting portions of data. 

For more, please refer to "Get started with Copilot in Excel". You may click the contents on the left pane for instructions on these operations.

---

If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment". Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

---

Answer 3

But the question was about comparing to excel files and actions like filling Excel tables taking data from Word. Are these possible? If not with copilot Alone, is it possible to achieve this by power automate???