Get started with Copilot in Excel

Easily import data: Copilot can help you import data from the web, saved files in OneDrive or SharePoint, or communications from within your organization.

Highlight, sort, and filter your data: Use Copilot to easily highlight data that you're interested in or to create helpful custom filters. For example, you could ask Copilot to show you cells that contain numbers, or filter for numbers greater than five.

Generate and understand formulas: Easily create new columns and rows that perform calculations based on your existing data. Copilot can also explain how each formula works.

Identify insights: You can ask Copilot questions about your data. Copilot shows insights as charts, Pivot Tables, summaries, trends, or outliers.

Format your data in a table or supported range for Copilot to read.

You'll find the Copilot icon on the ribbon in the home tab. Choose the icon to see conversation starters and chat with Copilot. You can select from the listed options to create something new, suggest formulas or formatting, summarize data, or something else.

You can also select a specific cell and choose the Copilot ​​​​​​​sparkle icon that appears.