What's New in Excel (November 2023)

  • Thread starter Thread starter Microsoft Excel
  • Start date Start date
M

Microsoft Excel

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 >

large?v=v2&px=999.pngWorkbooks 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 >

large?v=v2&px=999.gifGROUPBY Function

large?v=v2&px=999.gifPIVOTBY 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 >
large?v=v2&px=999.pngExport 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 >

large?v=v2&px=999.gifGROUPBY Function

large?v=v2&px=999.gifPIVOTBY 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 >
large?v=v2&px=999.pngExport 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.

Continue reading...
 
Back
Top