What's New in Excel (November 2023)

Welcome to the November 2023 update. This month we are excited to share a number of new features rolling out across Excel for the web, Windows, and Mac. GROUPBY and PIVOTBY, and Export Loop Tables to Excel are both available to Windows and Mac Insiders. Trendline Equation Formatting is now out to all web users, and Workbook Links are now live for Windows users.

 

Many of these features are the result of your feedback. THANK YOU! Your continued Feedback in Action (#FIA) helps make Excel better for everyone. 

 

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)

Excel for web

1. Trendline Equation Formatting

Additional trendline equation formatting controls are now available in the chart format task pane. This includes number and font/fill/outline formatting.

Excel for Windows

#FIA

1. Workbook Links

The Workbook Links task pane improves the experience and reliability for working with linked files including the long asked for Find feature to help you figure out where the links are used. Read more here >

Workbooks Links Refresh

2. GROUPBY and PIVOTBY Functions (Insiders)

GROUPBY and PIVOTBY allow you to perform data aggregations using a single formula. All you need is just 3 arguments: i) What to group by, ii) the values to aggregate, and iii) the function you'd like to use for the aggregation. Read more here >

GROUPBY Function

 PIVOTBY Function

 3. Export Loop Tables to Excel (Insiders)
When you’re collaborating as a team on a project, you may choose to add Loop tables to gather data and perform calculations. You can now export the tables to applications such as Excel so you can leverage its capabilities to perform any needed calculations. Read more here >
Export Loop Tables to Excel

Excel for Mac

1. GROUPBY and PIVOTBY Functions (Insiders)

GROUPBY and PIVOTBY allow you to perform data aggregations using a single formula. All you need is just 3 arguments: i) What to group by, ii) the values to aggregate, and iii) the function you'd like to use for the aggregation. Read more here >

GROUPBY Function

 PIVOTBY Function

2. Export Loop Tables to Excel (Insiders)
When you’re collaborating as a team on a project, you may choose to add Loop tables to gather data and perform calculations. You can now export the tables to applications such as Excel so you can leverage its capabilities to perform any needed calculations. Read more here >
Export Loop Tables to Excel

 

 

Check if a specific feature is in your version of Excel Click here to open in a new browser tab

 

Your feedback helps shape the future of Excel. Please let us know how you like a particular feature and what we can improve upon—"Give a compliment" or "Make a suggestion"..  You can also submit new ideas or vote for other ideas via Microsoft Feedback.

 

Subscribe to our Excel Blog and the Insiders Blog to get the latest updates. Stay connected with us and other Excel fans around the world – join our Excel Community and follow us on X, formerly Twitter.

 

Special thanks to our Excel MVPs David Benaim and Bill Jelen for their contribution to this month's What's New in Excel article. David publishes weekly YouTube videos and regular LinkedIn posts about the latest innovations in Excel and more. Bill is the founder and host of MrExcel.com and the author of several books bout Excel.