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. One, 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. Nope. This step is necessary to enable Copilot to read the data. Two write your prompt, select any cell in your table and open Copilot. Use a sample prompt you can use. Create a chart type that show
s 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. Three, 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. Nope. You can of course modify the chart's appearance and layout just like any other Excel char
t. Feel free to subscribe to my channel and follow me if you are interested in artificial intelligence. And of course, ask me any questions you may have in the comments.
Comments