Tool guide · by Microsoft

Microsoft Copilot in Excel

AI inside the spreadsheet you already use.

Best for

  • Working directly in your workbook: formulas, sorting, filtering and highlighting
  • Creating PivotTables and charts from a question in plain words
  • Spotting trends and outliers in a data set
  • Organisations already on Microsoft 365, where IT manages data protection

Watch out for

  • Works best on data formatted as an Excel table with clear headers.
  • Files usually need to be saved to OneDrive or SharePoint with AutoSave on.
  • Check every formula it inserts. Undo (Ctrl + Z) is your friend.
  • Use it on client files only with your organisation’s approval.

Get started

  1. Check that your Microsoft 365 plan includes Copilot: look for the Copilot button on Excel’s Home tab.
  2. Save the workbook to OneDrive or SharePoint and turn on AutoSave.
  3. Select your data and press Ctrl + T to format it as a table with headers.
  4. Open Copilot and ask in plain language, for example with the prompt below.

Features worth knowing

Formula suggestions

Describe the column you want (“days overdue from the due date to today”) and Copilot proposes a formula, with an explanation, before inserting it.

Analysis

Ask for totals by category, the top 10 customers or month-on-month changes. Copilot can add PivotTables and charts.

Highlight, sort and filter

“Highlight invoices more than 90 days overdue in red” applies the conditional formatting for you.

Copilot chat

The free Copilot app on the web, Windows and phones works like other chatbots for questions and drafting.

Try this prompt

Prompt
Add a column that shows the days overdue from the Due Date column to today. Then create a PivotTable showing the total Amount by Customer for invoices more than 60 days overdue.

Put it to work

Recipes that suit Microsoft Copilot in Excel

Other tool guides

Plans, limits, menus and feature names change often. Checked November 2026; see the official website for the latest. This site is independent and not affiliated with Microsoft.