Shulou(Shulou.com)11/24 Report--

CTOnews.com August 31, Microsoft recently released a preview of Office for August, which brings a number of new features to Excel.

Starting with Excel for web, 14 new text and array manipulation functions have been introduced, including TEXTBEFORE, TEXTAFTER, VSTACK, HSTACK, CHOOSEROWS, and CHOOSECOLS. Users who want aesthetic text customization can also take advantage of the new options in the Excel ribbon to play with rich text formatting. You can now also sort cells by color.

In terms of data manipulation and visualization, new operations can be run on the Power Query group, and the integration between the Excel PivotTable and Power BI datasets has been sorted out. You can now edit files with old data connections, including files that use the old shared workbook feature. The Elements is diagram is shown in that the delete key and backspace key can be deleted in a simpler way, and the formula bar can be expanded to see a multi-line formula with better readability.

CTOnews.com learned that in terms of Excel for Windows, the same 14 text and array manipulation functions of the above Web version are supported and extended to the current channel. Beta channel insiders can also use the IMAGE feature to seamlessly insert images into cells, as well as the same Power BI enhancements described above. Another feature is the option to track changes in the workbook, which is useful in a collaborative environment. Currently, this applies only to internal testers in the CC preview channel.

"the IMAGE feature allows the user to insert the image directly into the cell. Previously, when images were inserted into cells, presentations were not seamless because they floated at the top. In addition, users can adjust and rearrange cells to make it easier to perform tasks, such as tracking inventory, creating employee dashboards, or building games and scaffolds. To access this feature, the user needs to join the preview plan, and then type the following in the cell where you want to insert the image:

= IMAGE ("https://support.content.office.net/en-us/media/2d9e717a-0077-438f-8e5e-f85a1305d4ad.jpg"," Sphere ")

However, there are several known issues with this update. First, users will not be able to insert images from sites that require authentication. When you zoom in and out of an image in a cell, the image may also be distorted. Finally, if you change the device while using this feature, it may cause irregular image rendering. "

There are some similar changes on other platforms, the main points are as follows:

Excel for Mac

New Excel function

IMAGE feature (Beta Preview)

Show changes (CC preview)

Android

New Excel function

IMAGE feature (Beta Preview)

IOS

New Excel function

IMAGE feature (Beta Preview)

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.