Copilot in Excel is getting huge  upgrades as it comes out of preview in June.

Microsoft will be taking Copilot in Excel out of preview next month and are adding a bunch of new and needed features.

The Microsoft 365 Roadmap calls out a key feature (ID: 394275) which will allow users to receive more conversational answers to various Excel-related questions and prompts. This aims to provide less expert Excel users with step by step help on formulas, ability to do more things using natural language and also finally the ability to work on data sets that aren’t confined to being encapsulated in an excel table.

The aim: to emoower everyone to use Excel better whether beginners to more advanced users.

Copilot can assist users in completing tasks by providing helpful steps, including formulas to copy and use. It can also explain formula errors and offer corrected formulas along with additional guidance.

Here’s a breakdown of what can be done with this newer functionality coming to Copilot in Excel:

  • Understand your questions and requests in a more natural way, making it easier to get the help you need and how to perform what you need in excel
  • Be able to answer a broader range of Excel-related questions, not just specific tasks and will also be able to provide clear instructions, including relevant formulas.
  • Help with formula errors by explaining the issue and suggesting corrected formulas with additional guidance.