Published on 29 Dec 2022 on Zacks via Yahoo Finance
Microsoft (MSFT) Excel's New Features to Make Formulas Simpler
Microsoft MSFT Excel has announced a handful of changes that are set to make formulas easier to use and even more powerful. The spreadsheet software updates are centered around web users, which cover all Microsoft 365 (formerly Office 365) users, even those without access to the full desktop clients.The first change for web users is the introduction of formula suggestions, which take into account contextual data to suggest a handful of supported formulas, including SUM, AVERAGE, COUNT, COUNTA, MIN and MAX.Secondly, the company has introduced Formula by Example, which is similar to the Flash Fill feature. After a user completes a series of similar entries, the web version of Excel can automatically detect and suggest content for remaining cells based on their previous actions or patterns.Further improvements include a tool that can detect broken cloud workbook links so that the data in your spreadsheet remains up-to-date and functioning and a new search bar in the queries pane for quicker navigation.Excel has rolled out a function for adding images with alt-text into tables coming to Windows, Mac and web; and the company is also adding nested Power Query data types and the ability to get data from dynamic arrays to the Insider version of the Windows app for testing.These endeavors are expected to further boost demand for the company’s 365 suite which has already witnessed robust adoption in the preceding quarters. In first-quarter fiscal 2023, Office 365 commercial revenues rallied 11% (up 17% at cc), driven by Office 365 Commercial seat growth of 14%. Continued momentum in the small and medium businesses, as well as in frontline worker offerings, drove top-line growth.
Microsoft Corporation Price and Consensus
