Last week, Microsoft announced that the web version of Excel will be receiving an update that adds formula suggestions

The concept is simple. Let’s say you’re adding number values in a column. The numbers can represent anything, such as sales, a personal budget, etc. If you then try to add a formula at the very bottom of the column starting with the equal sign (=), Excel will try to guess what formula you’re trying to add based on the immediate context and present that formula for you to use. It may be =SUM(), for example.

In the below video, you can see an example of how this works.

At the same time, Excel on the web will now also suggest formulas to simplify repetitive data entry. The below video demonstrates how this is intended to work. 

Both of these features are only available in the web version of Excel and should be available in December 2022.

Source: Microsoft Excel Blog