This can simplify your complicated spreadsheets and deepen your understanding of the underlying data.

AI prompts can be especially useful in unearthing data connections.

Leveraging artificial intelligence in spreadsheets can be a powerful data analysis tool.

iPhone 16e with iPhone 16 Plus and iPhone 16 Pro in hand against grey wall.

And for those who aren’t good at math and formulas, the feature could be indispensable.

Highlighting specific cells, rows, and columns goes hand in hand with AI-assisted conditional formatting.

Another AI feature lets you ask Copilot for a formula that summarizes column data into one cell.

An Excel table with a named range.

Excel customers can leverage Copilot by clicking Try in within each prompt card on theCopilot Lab website.

There are Copilot Lab prompts for other office apps, including Word and PowerPoint.

Copilot Lab is also accessible from within Microsoft 365 apps and on mobile.

Using Copilot to apply conditional formatting to a Microsoft Excel spreadsheet.

Microsoft

However, you will need aCopilot Pro subscriptionto use this feature and other AI enhancements.

Using the Copilot sidebar in Microsoft Excel to create a formula from a prompt.

Microsoft