formulas

San Francisco: Tech giant Microsoft has announced that it is making formulas easier in its spreadsheet service Excel with new features. The new features are designed to help save users' time and make them learn more about Excel formulas, the tech giant said in a blogpost. The company introduced five new features in Excel for the web which include-- 'Formula Suggestions', 'Formula by Example', 'Suggested Links', the ability to add a search bar in the queries pane and the 'IMAGE Function'. https://www.youtube.com/watch?vrG0MJIdav0k 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. Also ReadSamsung to launch affordable Galaxy F04 in India as New Year begins Whereas, 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. The tech giant also introduced four new features in Excel for Windows-- the ability to add a keyboard shortcut to open the power query editor, create nested power query data types (Insiders), add get data from dynamic arrays (Insiders), and 'IMAGE Function'. 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. 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.

formulas

Microsoft makes Excel’s formulas easier

Bangladesh’s former prime minister Khaleda Zia returns to country after treatment in UK

Kiara Advani flaunts baby bump at MET Gala, hubby Sidharth is smitten

Ahead of Miss World 2025 contest, Hyderabad police ban drones in 10 areas

Iltija Mufti seeks relief for Pak women living in Kashmir for decades

Air India extends Tel Aviv flight suspension till May 8