Microsoft adds new features to make formulas easier in Excel
Tech giant Microsoft is reportedly making formulas easier in its spreadsheet service Excel with new features. The company introduced five new features in Excel for the web like ‘Formula Suggestions’, ‘Formula by Example’, ‘Suggested Links’, the ability to add a search bar in the queries pane and the ‘IMAGE Function’.
With the ‘Formula Suggestions’ feature, when a user types the " sign in a cell or the formula bar, Excel will automatically suggest the best formula based on contextual insights from the data. With the ‘Formula by Example’ feature, the spreadsheet will now suggest users to fill the entire column with a formula in case it identifies a pattern when users are performing manual and repetitive data entry in a column.
Users can now press Alt + F12 (Win32) or Option + F12 (Mac) to open the Power Query Editor quickly. Whereas, with the ability to create nested power query data types, users can now organise their data even better by creating nested data types. This feature is currently rolling out to Insiders users for Windows.
The tech giant also introduced four new features in Excel for Windows which includes the ability to add a keyboard shortcut to open the power query editor, create nested power query data types, add get data from dynamic arrays and the ‘IMAGE Function’. Microsoft is also rolling out the ‘IMAGE Function’ feature for Mac which allows users to insert images into cells from a source location, along with the alternative text.
See What’s Next in Tech With the Fast Forward Newsletter
Tweets From @varindiamag
Nothing to see here - yet
When they Tweet, their Tweets will show up here.