The Excel website has this feature to find the appropriate formulas for each operation

Probably many readers use it Excel For both school and university or everyday work tasks. Okey then, Microsoft Announced a new update web version which promises to solve many headaches: a feature that enables Automatically create formulas with hints.

The “suggestions” tool begining The formulas allow Ask the spreadsheet program to recommend a formula related to content that the user previously entered in the same cell, column, or row. It should be noted that the feature is currently only available English.

How the suggestion system works

The spreadsheet creator just needs to type sign ‘=’ in a cell (or in the formula bar at the top of the screen). Excel shows parameters The most suitable, among which Microsoft itself emphasizes:

– addition

– average.

– Count it.

– Numerical counting.

– Min.

– Max.

The user will only need to do this Click on it In the one that best suits the needs of the moment. Thus, the Redmonds explain a youtube video For example, if you want to calculate the sum of the prices of a list of clothes and write it down “average” At the end of the column, Excel will suggest a sum formula. Obviously, the platform will do the calculation automatically.

You may be interested in:

More news for Excel

Microsoft has also added some additional features to help users save time filling out spreadsheets:

– formula “for example”

As the user repeatedly enters data into a column, Excel now suggests filling the entire column with a formula if a problem is detected. sample. Also, formulas can now be suggested instead of ‘static text’.

– Suggested links

Suggested Links enables a new cloud-based book data store that “marks when an external link is broken in a book cloud”, so a new location is suggested to repair the broken link. It should be noted that the company claims that this feature is currently in production.

Last but not least, Microsoft announced the feature IMAGEwhich is now available in both windows as in macOS. This news Adds images with alt text to source cells. User images can now be part of the spreadsheet instead of hanging over it. You can move and resize, sort and filter cells, and manipulate images in Excel spreadsheets.

You may be interested in:

Two Excel tricks

How to Remove Blank Cells in Excel

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

2. Press F5 And when the option ‘Go’, Select “Special”.

3. Then click “empty cells” and 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 data which you want to confirm.

2. In the main tab, select a group “styles” and then click “Conditional Format”.

3. Then click “Cell highlighting rules” And finally select the option that says “Duplicate values”.

Continue reading: