Network Security Internet Technology Development Database Servers Mobile Phone Android Software Apple Software Computer Software News IT Information

In addition to Weibo, there is also WeChat

Please pay attention

WeChat public account


Microsoft reviews the new features of Excel in November: adding "workbook links", introducing GROUPBY and PIVOTBY functions, etc.

2024-04-25 Update From: SLTechnology News&Howtos shulou NAV: SLTechnology News&Howtos > IT Information >


Shulou( Report-- November 30, Microsoft recently issued a press release reviewing the features introduced for Excel applications in November this year.

One of them is to add the Workbook links panel, Microsoft said: "the workbook link task window improves the experience and reliability of handling linked files, including the long-requested 'find' feature to help you determine where the link is used."

Microsoft also invited Microsoft Insiders members to test Excel's new GROUPBY and PIVOTBY functions on Windows and macOS platforms. You can use a single formula to aggregate data, and users only need to enter three parameters: the grouping basis, the value to be aggregated, and the function to be used for aggregation.

Microsoft officials say GROUPBY and PIVOTBY are lightweight, fully descriptive, automatically updated, and can rely on other computing results. They also use the lambda function for aggregation, unlocking new aggregation capabilities.

The web version of Excel adds more Trendline Equation Formatting controls, including numbers and font / fill / outline formats in the chart formatting task pane. previously reported that Microsoft has introduced new features for Loop users to make it easier for users to automatically export forms created in Loop to Excel.

When the team works together to advance the project, team members can choose to add Loop tables to collect data and perform relevant calculations.

Users can now export these tables to Excel applications to facilitate subsequent related operations. To ensure compatibility, Loop's table data types are mapped to the relevant format after they are imported into Excel.

The process is simple: Microsoft business users can go to, create a new table or open an existing table, click the six-point menu on the table, and then select the "Export to Excel" option.

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.

Views: 0

*The comments in the above article only represent the author's personal views and do not represent the views and positions of this website. If you have more insights, please feel free to contribute and share.

Share To

IT Information


© 2024 SLNews company. All rights reserved.