Nov 2023 Excel Update Features & Enhancements

What's New in Excel (November 2023)

Welcome to the November 2023 update. Microsoft sharing exciting new features available in Excel for web, Windows, and Mac. Users can look forward to GROUPBY and PIVOTBY, and Export Loop Tables to similar spreadsheet tools on both Windows and Mac Insiders.

• Excel for web:
  •  1. Trendline Equation Formatting
• Excel for Windows:
  •  1. Workbook Links #FIA
  •  2. GROUPBY and PIVOTBY Functions (Insiders)
  •  3. Export Loop Tables to Excel (Insiders)
• Excel for Mac:
  •  1. GROUPBY and PIVOTBY Functions (Insiders)
  •  2. Export Loop Tables to Excel (Insiders)

Summary of New Features in Spreadsheet Applications as of November 2023

The new features for the web version include improved formatting options for trendline equations in charts. This enhancement is now widely available to all web users and aims to offer better visualization for data trends.

For Windows users, several new capabilities have been introduced. These features enhance the software's functionality and are geared towards making data analysis more intuitive and robust.

• Workbook Links: These links improve reliability when working with external files and introduces a new feature to locate these links quickly.
• GROUPBY and PIVOTBY Functions: Available to insiders for advanced aggregation.
• Export Loop Tables: Users collaborating on a cloud platform can now export tables to further work on the data using the software's computation strength.

Mac users receive two powerful functions for data grouping and pivoting, enhancing data analysis on the platform. These functions are similar to those released for Windows and are currently available to insiders.

• GROUPBY and PIVOTBY Functions: Streamline data analysis by aggregating data with just a few arguments.
• Export Loop Tables: This insider function aids collaborative efforts, allowing Loop tables to be imported for further manipulation.

These updates underline the organization's commitment to enriching user experience based on feedback. Users are encouraged to submit feedback or engage with the community on various platforms to influence future updates.

Contributions from key community influencers and experts are also recognized, highlighting the community-driven approach to improving the application.