Thread by @itsPaulAi

Copilot's integration in Excel is impressive

You can process data and create charts without formulas.

Here's how to do it with a single prompt 🧵

1. Turn your data into a table

- Select the first cell of your data.

- In the top menu, click on "Format as a Table".

- Then choose the appearance of your table

Note:

This step is necessary to enable Copilot to read the data.

2. Write your prompt

Select any cell in your table and open Copilot.

Here's a sample prompt you can use:

"Create a [CHART TYPE] that shows [DESCRIPTION]"

For my data, my prompt is:

"Create a bar chart that shows the average weight for each sport"

Copilot takes care of understanding the data, calculating (here the average weight) and displaying a preview of the chart.

3. Insert the chart

Copilot automatically suggests that you insert the chart.

Click on this button to create the new sheet.

It contains the necessary data and the new chart.

Note:

You can, of course, modify the chart's appearance and layout just like any other Excel chart.

I'm still working on a project involving Copilot and Copilot for Microsoft 365.

So feel free to subscribe to my personal newsletter and follow me if you're interested.

And of course, ask me any question you may have!