Copilot for Microsoft Excel

Introduzione a Microsoft Copilot

Nia Joseph

AI Product Builder, Microsoft

Copilot in Excel

 

Screenshot 2024-09-24 at 00.07.29.png

Introduzione a Microsoft Copilot

Where is Copilot in Excel?

Screenshot of Excel worksheet with the Copilot icon highlighted.

Introduzione a Microsoft Copilot

Where is Copilot in Excel?

  • Save file in OneDrive or SharePoint to use Copilot.

Screenshot of Excel worksheet with auto-save highlighted.

Introduzione a Microsoft Copilot

Organize Data into tabular format

  • The data needs to be in table format An open Excel document showing how to format data as a table.
Introduzione a Microsoft Copilot

Identify insights

Screenshot 2024-09-25 at 20.10.40.png

  • Identify trends
  • Find outliers
  • Provide statistical summaries
Introduzione a Microsoft Copilot

Identify insights

An open Excel document showing data for clothing products and a Copilot chat open on the side with a user asking to show data insights.

Introduzione a Microsoft Copilot

Create charts and visualizations

An open Excel document showing charts created with Copilot.

Introduzione a Microsoft Copilot

Use formula suggestions

An open Excel document showing data for clothing products and a Copilot chat open on the side with a user prompting to calculate the average marketing spend per product on the current sheet

Introduzione a Microsoft Copilot

Use formula suggestions

An open Excel document showing data for clothing products and a Copilot chat open on the side with an output of the formula

Introduzione a Microsoft Copilot

Convert data

An open Excel document showing data for clothing products and a Copilot chat open on the side with a user asking to convert values to euros.

Introduzione a Microsoft Copilot

Sort data

An open Excel document showing data for clothing products and a Copilot chat open on the side with a user asking to sort on the Year column.

Introduzione a Microsoft Copilot

Let's practice!

Introduzione a Microsoft Copilot

Preparing Video For Download...