[BI] Microsoft 365 Copilot for Excel

You need two subscriptions to use it

1. Microsoft 365 Enterprise subscription (or personal plan at $6.99 / month)

2. Copilot for Microsoft 365 (enterprise users) at $30 per user per month (Copilot Pro available for personal plan, at $20 per month)

Copilot for Microsoft 365

Features

Feature	Description
Figure out formulas	Copilot can figure out formulas for calculations like counting distinct customers.
Add new columns	Copilot can add new columns to a table, like calculating profit as revenue minus cost, or converting duration from seconds to minutes.
Generate charts	Copilot can generate charts based on data, like a line chart showing profit by month or a pie chart of view count by category.
Highlight cells	Copilot can highlight cells based on conditions, like highlighting profits above $2000 in green or using color scales.
Analyze data	Copilot can analyze data to identify trends, outliers, or answer questions like average video duration.
Sort data	Copilot can sort data columns in ascending or descending order based on prompts.
Filter data	Copilot can filter data to show only rows meeting certain criteria, like high view counts and like percentages.
Explain formulas	Copilot can explain the formulas it uses to generate results.
Insert pivot tables	Copilot can insert pivot tables to summarize data, like showing top salespeople by opportunity value.
Customize visuals	Copilot can potentially customize visuals like changing the line color in a chart (though it couldn't do it directly in the demo).
Create reports	Copilot can create reports like a sales pipeline report ranked by salesperson based on prompts.

Copilot for Powerpoint

Features

Feature	Description
Create presentations	Copilot can create entire new presentations from just a simple text prompt, like "create a presentation on the future of renewable energy".
Add slides	Copilot can add new slides to an existing presentation based on prompts, like "add a slide with a list of top renewable energy producing countries".
Update slide content	Copilot can update existing slide content, like adding descriptions to bullet points on a slide.
Organize slides	Copilot can reorganize and group slides in a logical flow based on the content.
Generate summaries	Copilot can provide a summary of the key information in a presentation, with links back to source slides.
Copilot Lab	Copilot Lab provides a repository of sample prompts to use with Copilot in PowerPoint.
Create from Word docs	For Enterprise/Business licenses, Copilot can create PowerPoint presentations from Word documents. (Not available for Copilot Pro licenses)
Speaking notes	The video mentioned generating speaking notes for slides, but Copilot was unable to do this (potentially a limitation or upcoming feature).