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.
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.