The Excel site has this option to find the appropriate formulas for each operation

Many readers may use it Excel Whether in school, university or daily work tasks. OK then, Microsoft Announcing a new software update Web version That promises to solve many headaches: a function that allows Create formulas automatically with hints.

the Suggestions tool From Formulas allow Have your spreadsheet program recommend a formula related to content the user has previously entered in the same cell, column, or row. It should be noted that the functionality is currently only available in Einglish.

How does the suggestion system work?

The spreadsheet generator simply needs to write a register ‘=’ in a cell (or in the formula bar at the top of the screen). Excel will display the file and options The most suitable, among which Microsoft itself stands out:

– addition.

– Average.

– number.

– digital count.

– who.

-the above.

The user will only need to do click at best suited to the needs of the moment. In this way, those from Redmond in A YouTube video For example, if you need to calculate the sum of clothing list prices, write ‘Average’ At the end of the column, Excel will suggest the sum formula. Obviously, the platform will perform the calculation automatically.

You may be interested:

More news for Excel

Microsoft has also added some additional features so that users can save time filling out spreadsheets:

– formula “for example”

Since the user frequently manually enters data into a column, Excel now suggests filling in the entire column with a formula if a problem is detected. pattern. Also, formulas can now be suggested instead of “static text”.

Suggested links

Suggested Links enables a new cloud book data store that “detects when an external link is broken in a book on CloudTherefore, a new place was proposed to fix the broken link. It should be noted that this feature is currently in production, according to the company.

Last but not least, Microsoft announced the feature picturewhich is now available in both windows As is the case in macOS. This granny Adds images with alt text to the source cells. User photos can now be part of the spreadsheet instead of hovering over them. You can move, resize, sort and filter cells, and manipulate images in an Excel spreadsheet.

You may be interested:

Two Excel tricks

How to remove blank cells in an Excel application

1. Select all the blank cells that you want to delete.

2. Press F5 And when it is an option ‘go to the’, Specify ‘distinct’.

3. Then click “empty cells” Then type the key combination CTRL + minus (-).

4. Finally, select the option that says “delete rows”

How to find duplicate values ​​in a list

1. Select a file data that you want to validate.

2. On the Home tab, select Group “patterns” Then click Conditional Formatting.

3. Then click Rules for distinguishing cells Finally select the option that says Duplicate values.

Read on: