Isn't that great if you become an Excel wizard without spending all the time and effort you need to learn how to get around Excel and make it do what you want? Formula is one of the biggest problems, and Microsoft knows that. So Microsoft will add new AI features to Excel to alleviate all of that.
New features are called The completion of the formula Also, according to a new Microsoft Excel blog post, “As soon as you type “=”, it drives you to “actively propose and autocomplete the formula.”
The days of finding ways to choose the right cells and remembering the right formula to use, referencing the right arguments and data sources, and debugging broken syntax are over.
As soon as you enter “=” into the cell, the AI model behind Excel analyzes the context and configuration of the current workbook to predict what you are trying to do, and generates one or more proposed formulas to accomplish that. Each suggestion comes with a handy preview and an explanation of what it aims to achieve in a plain language. Additionally, as you continue to type more characters into the formula field, Excel will continuously update your proposals to suit your intentions.
Completing the formula can handle the complexity of various workbooks, such as calculating financial data, generating regex statements, and even creating dynamic expressions. However, at the time of writing, the completion of the formula is not available to reference other workbooks.
The Microsoft Excel formula is currently being expanded to Copilot users on Excel Web to English-only Copilot users. Formula completion for Excel desktop and other languages will be provided at a later date.
Read more: Microsoft fixes the worst scam in Excel PivotTable
This article was originally published in the sister publication PCFör Alla, translated and localized from Sweden.
