Excel is one of the most used and popular app from Microsoft as it is used widely around the world by users. Microsoft has brought new features to Excel to enhance the user experience. The new Excel features come for web users, Windows users as well as Mac users. Here are some of the key features rolled out for Excel:
Formula by Example
In a blog post, Microsoft said that as users are performing manual and repetitive data entry in a column, “Excel will now suggest you to fill the entire column with a formula in case we identify a pattern.” In case anyone is wondering if that sounds familiar, then this is similar to the Flash Fill feature on Excel. However that was limited to static text, the new feature will suggest formulas. It will be available on Excel for web.
New Image function
The Image function inserts images into cells from a source location, along with the alternative text. “Your images can now be part of the worksheet, instead of floating on top. You can move and resize cells, sort, filter, and work with images within an Excel table,” said Microsoft in the blog post. The feature will be available on Excel for Mac, Windows as well as web.
Formula Suggestion
Excel will now auto-suggest the best formula based on contextual insights from your data. As soon as a user types the “=” sign in a cell or the formula bar, Excel will automatically suggest formulas. For the time being, formulas that can be suggested are SUM, AVERAGE, COUNT, COUNTA, MIN, and MAX. The feature will be available soon for Web users.
Suggested Links
Microsoft said that Suggested Links will “allow for new cloud workbook storing for data that detects when an external link to a Cloud workbook is broken and suggests you a new location to fix the broken link.”
Search bar
Users can now easily find their queries within the Queries search pane.
Formula by Example
In a blog post, Microsoft said that as users are performing manual and repetitive data entry in a column, “Excel will now suggest you to fill the entire column with a formula in case we identify a pattern.” In case anyone is wondering if that sounds familiar, then this is similar to the Flash Fill feature on Excel. However that was limited to static text, the new feature will suggest formulas. It will be available on Excel for web.
New Image function
The Image function inserts images into cells from a source location, along with the alternative text. “Your images can now be part of the worksheet, instead of floating on top. You can move and resize cells, sort, filter, and work with images within an Excel table,” said Microsoft in the blog post. The feature will be available on Excel for Mac, Windows as well as web.
Formula Suggestion
Excel will now auto-suggest the best formula based on contextual insights from your data. As soon as a user types the “=” sign in a cell or the formula bar, Excel will automatically suggest formulas. For the time being, formulas that can be suggested are SUM, AVERAGE, COUNT, COUNTA, MIN, and MAX. The feature will be available soon for Web users.
Suggested Links
Microsoft said that Suggested Links will “allow for new cloud workbook storing for data that detects when an external link to a Cloud workbook is broken and suggests you a new location to fix the broken link.”
Search bar
Users can now easily find their queries within the Queries search pane.
Related Posts
Denial of responsibility! TechnoCodex is an automatic aggregator of the all world’s media. In each content, the hyperlink to the primary source is specified. All trademarks belong to their rightful owners, all materials to their authors. If you are the owner of the content and do not want us to publish your materials, please contact us by email – [email protected]. The content will be deleted within 24 hours.
