microsoft: Microsoft Excel: Users can now easily access formulas with this new update

Microsoft announced additional enhancements to the autocomplete functionality in its web edition of Excel, which is accessible with Microsoft 365. The latest changes include formulae recommendations and formulas by example, which are intended to accelerate the process of performing formerly manual activities. Excel for Windows now includes four new features from the tech behemoth.

Formula by example, similar to the existing Flash Fill feature, will propose formulae to users as they repeatedly enter data in a column. If Excel notices a pattern in the information being input, it will suggest using an equation to fill the entire column to expedite the process.

When users write the “=” sign in a cell or the formula bar, Excel will now recommend the best formula according to the context and analytical capabilities. The formulae available are SUM, AVERAGE, COUNT, COUNTA, MIN, and MAX. This tool is presently only available in English and is in the process of being rolled out to online users.

Suggested Links will make working with cloud workbooks simpler. When an outside url to a Cloud workbook is broken, Suggested Links will easily detect it and offer a new place to fix the broken connection. This functionality will soon be rolled out to web users.

Other features offered by Microsoft include the option to add a search bar in the query pane and the ‘IMAGE Function’ to Excel for online. Microsoft also adds four new features to Excel for Windows, including a power query editor shortcut, nested data types, a dynamic array data source, and the IMAGE Function. The IMAGE Function is also available in Excel for Mac.

Microsoft Excel is a spreadsheet programme developed by Microsoft that is available for Windows, macOS, Android, and iOS. It includes calculating or arithmetic skills, graphical utilities, tables, and Visual Basic for Applications which is a macro programming language. Excel is part of the Microsoft Office software suite.


Q1. Who made Microsoft?

Bill Gates is the founder of Microsoft.

Q2. Which is the latest version of Microsoft Windows?

The latest version is Windows 11.

Disclaimer Statement: This content is authored by an external agency. The views expressed here are that of the respective authors/ entities and do not represent the views of Economic Times (ET). ET does not guarantee, vouch for or endorse any of its contents nor is responsible for them in any manner whatsoever. Please take all steps necessary to ascertain that any information and content provided is correct, updated, and verified. ET hereby disclaims any and all warranties, express or implied, relating to the report and any content therein.

Source link


Leave a Reply

Your email address will not be published. Required fields are marked *