Get started with Copilot in Excel
Applies To
Excel for Microsoft 365 Excel for Microsoft 365 for Mac Excel for iPad Excel Web AppCopilot in Excel helps you do more with your data by generating formula column suggestions, showing insights in charts and PivotTables, and highlighting interesting data.
Tip: For more great ideas on using Copilot in Excel check out the Excel blog at http://aka.ms/ExcelCopilotBlog.
-
Open Excel.
-
Open a workbook stored on OneDrive or SharePoint.
Important: Your data needs to be formatted in specific ways (see Format data for Copilot in Excel).
-
Select Copilot on the ribbon to open the chat pane.
-
Enter your prompts and start working with Copilot.
Here are some samples to get you started: • "Create a bar graph showing the sales growth between Q2 and Q3." • "Bold the top 3 values in Annual Sales." • "Add a new column showing the percentage difference between column A and column C."
Explore more Copilot prompts.