Copilot Comes to Excel - Use AI to Analyze Data, Create Formulas, Charts with New Excel Feature
-
You need a Microsoft 365 and Copilot Pro subscription to use Copilot in Excel. Enable AutoSave and store files in OneDrive/SharePoint.
-
Convert your Excel data into a table format for Copilot to analyze it.
-
Make requests to add formulas, highlight cells, sort data, filter, and analyze your Excel tables.
-
Review Copilot's actions and undo or refine requests if needed.
-
Insert pivot tables and charts to visualize Excel data, and get AI-driven insights from Copilot.