11 cool things Copilot can do in Excel

For best results with Copilot in Excel, put your data in table format.
Click the Copilotbutton in the toolbar to invoke the Copilot sidebar.
Enable Agent Mode for advanced Copilot features in Excel.
Type in the action you want Copilot to take
Copilot takes action on your data and tells you what it did.
Copilot has generated a new table with the data from the “Plane Tickets” row, arranged as described in the prompt.
Copilot can quickly create a pivot table from specified source data.
Here Copilot is suggesting a heatmap color scheme for the data.
Using Copilot to create charts and graphs is a big timesaver.
Copilot can explain formulas to you.
If you’re not sure how to write a formula, just tell Copilot what you want the formula to do.
Copilot can summarize spreadsheet data.
It can then create an email draft highlighting the summary findings.
Copilot might find trends or errors in your data.
You can use Copilot to create what-if scenarios.
Cell D12 and below shows Copilot’s analysis of the data in cells B7 to G7. If those source values change, Copilot’s analysis is updated as well.

About Author

AndyC

Andy Curtis is an award-winning security consultant, researcher and public speaker. He has been working in the computer security industry since the early 1990s, having been employed by state and federal government, leading healthcare and banking providers across three continents. He has given talks about computer security for some of the world’s largest companies, worked with law enforcement agencies on investigations into hacking groups, and is a regular voice on TV and radio explaining IT security threats.

See author's posts