Try it

1. Open Excel in Microsoft 365.
2. Open a workbook stored on OneDrive or SharePoint.

   Note: Your data needs to be in a supported format. See Format data for Copilot in Excel and Format an Excel table for additional information.

3. From the Home tab, select the Copilot button on the ribbon.
   
   
4. Select Suggest a formula column or Show suggestions for formula columns from the Copilot chat panel on the right-hand side. You can also describe what columns or rows you’d like to add by typing it in your own words.
   
   
5. Copilot provides formula suggestions with an explanation on how each formula works. View the explanation by selecting Show explanation.
   
   
6. Select Insert column to add the formula column to your table.
   ​​​​​​​