A series of new excel functions were added to Microsoft
Microsoft Excel
Recently, Microsoft announced a series of new excel functions. Equally important, Microsoft Excel has added new features to their bucket list.
Notably, the function is covered in web, Mac and Windows version. However, the function for web has more number of updates.
Microsoft on Friday announced that excel will have a new feature of inserting images. The new tool can be used to insert images in the cells as an alternative to text.
Further, Microsoft added that all the features are a result of users feedback. The new functions added are as follows: “Formula by Example”, “Formula Suggestions”, “Formula Suggestions”, “Suggested Links” and “Add search bar in queries pane.”
Microsoft have a hunch of this new images tool in August. However, they landed to announce it in December. Users can use this contemporary images tool to source images from a location which can be added into the cells. Likewise, users can alter images with this tool for sorting, filtering, moving and resizing.
Formula by Example
More to it, the newly added features that were added alongside the images features is “Formula by Example”. Furthermore, it identifies pattern intelligence and when users perform a task manually with repetitive data then a “Flash Fill” like option is shown to the users which shows suggestions that replaces static texts.
Formula Suggestion
This feature suggests that SUM, AVERAGE, MIN, MAX, COUNTA and COUNTA by typing the “=” sign in a cell or on the formula bar. In addition, it is based on contextual insights from the data on the spread sheet that already exists.
Suggested Links
The “Suggested Links” feature on the other hand offers collusion for broken external links to Cloud workbooks. Using this feature, Excel will give suggestions regarding new locations directly to fix the broken links and allow a new cloud workbook storing the data.
Search Bar in Queries pane
The new search bar offered to Excel for web within the Queries search pane will offer a better way to look and find files.
In accordance to these new features rolled out, there are some more features that might be added and offered to Insiders in the upcoming time.