Copilot in Excel will summarize text columns and create custom and PivotTable charts

The new updates will be released in July.

2 min. read

Published onJune 19, 2024

published onJune 19, 2024

Share this article

Read our disclosure page to find out how can you help Windows Report sustain the editorial teamRead more

Great news for those using Copilot in Excel. Microsoft will update the AI model to support column text summarization and the ability to create custom charts and PivotTable.According to the latest entriesin the Microsoft 365 Roadmap, these updates will be rolling out gradually to users starting next month, in July.

You can now ask for more specific charts and PivotTables, including specifying the x and y axis of charts.

Copilot can analyze columns of text to give you summaries of the information. For example, Copilot will find the main themes in survey responses from open-ended questions.

Copilot in Excelis already capable of summarizing, but not at this level; the AI model can also extract data from different sheets so that you can create reports or plans more easily and quickly, but the Redmond-based tech giant is taking it to the next level.

PivotTables in Excel are used to calculate, summarize, and analyze data, letting you see comparisons, patterns, and trends in your data. Copilot’s ability to analyze your sheets and create such tables could greatly streamline workflows and allow you to have the information at hand when needed in a short amount of time.

Microsoft says in the description that Copilot will consider details about these charts, including the x and y axes, so users won’t have to worry about incomplete information.

With KB5043178 to Release Preview Channel, Microsoft advises Windows 11 users to plug in when the battery is low#

Copilot in Outlook will generate personalized themes for you to customize the app#

Microsoft will raise the price of its 365 Suite to include AI capabilities#

Death Stranding Director’s Cut is now Xbox X|S at a huge discount#

Outlook will let users create custom account icons so they can tell their accounts apart easier#

Copilot in Excel will summarize text columns and create custom and PivotTable charts#

With KB5043178 to Release Preview Channel, Microsoft advises Windows 11 users to plug in when the battery is low

Copilot in Outlook will generate personalized themes for you to customize the app

Microsoft will raise the price of its 365 Suite to include AI capabilities

Death Stranding Director’s Cut is now Xbox X|S at a huge discount

Outlook will let users create custom account icons so they can tell their accounts apart easier

Copilot in Excel will summarize text columns and create custom and PivotTable charts