What’s New in Excel (September 2024)

Excel for Windows, Mac, and web:
– Pilot in Excel

Excel for Windows:

– Copilot for Excel using Python (Insider)
– Python in Excel

– See TRIMRANGE and accompanying trims (Insiders)

– Accessibility support #FIA

Excel for Windows, Mac, and the web

Pilot in Excel
On September 16th we Copilot has unveiled its next wave. This also includes the announcement that Copilot for Excel is now generally available, ready to support data-centric professionals around the world. Copilot in Excel is built into your workbooks so you can iterate quickly and easily. This integration provides continuous prompts while you work, making it feel like you have an Excel expert right next to you. For more details, please see here >

In Excel, Copilot is asked to highlight when marketing spending is higher than revenue. Copilot provides a suggested conditional formatting formula. The suggestion is applied and the highlighting appears in the spreadsheet.

Excel for Windows

Copilot for Excel using Python (Insider)
Now, with Copilot in Excel with Python, you can perform advanced analyses that were previously impossible. You can describe the analysis you want to perform in natural language, and Copilot automatically generates, explains, and inserts the Python code into your Excel spreadsheet. With Copilot in Excel with Python, you can also render stunning visuals that were previously impossible or difficult to create. Unique visuals like heatmaps, pairplots, multiplots, and violin plots help you understand and communicate your analysis. Read more >

In Excel with Python, Copilot is asked to visualize data. Copilot generates and inserts Python code to create three chart types.

Python in Excel
Python in Excel is now generally available to Windows users of Microsoft 365 Business and Enterprise. In August last year, we partnered with Anaconda to We introduced By integrating Python, we added exciting new capabilities to Excel, allowing you to seamlessly combine Python and Excel analytics within the same workbook, with no setup required. Since then, we have brought the power of popular Python analytics libraries such as pandas, Matplotlib, and NLTK to countless Excel users.

Using Python in Excel Users can leverage advanced analytics for visualization, data cleansing, machine learning, and predictive analytics. Now even more! Read the blog and Watch the video here >

Leverage predictive analytics using Python in Excel.

TRIMRANGE and accompanying trim references (Insiders)

Introducing a new feature and support reference set.

• TRIMRANGE function – A function that removes blank rows and columns from the edges of a range.
• See trim – Provides a more concise way to call the general variant of the TRIMRANGE function.

Read more >

Use TRIMRANGE to calculate the length of text entered in column A.

Accessibility Helper

Accessibility Assistant helps you create inclusive content that is accessible to all readers. It flags and helps you address issues that could prevent everyone from understanding and using your document.

Accessibility helpers help ensure that your content is accessible to all users.

Many of these features are the result of your feedback. Thank you! Your continued support Putting Feedback into Practice (#FIA) Helps improve everyone’s Excel skills. Let us know if you like a particular feature or if there’s something you think could be improved.“Please give me a compliment” or “Please give me a suggestion”.. You can also submit new ideas or vote on other ideas by: Microsoft Feedback.

Our SubscriptionsExcel Blog and Insider Blog Get the latest updates. Stay connected with other Excel fans around the world.Excel CommunityAnd follow usX, formerly Twitter .

Special thanks to Excel MVPs: David Benaim,Bill Zelen and Alan Murray Thank you for contributing to this month’s What’s New in Excel article. David is writing weekly YouTube video And regular LinkedIn Posts Learn about the latest innovations in Excel and more. Bill is the founder and host. Mr. Excel.com And the author of several books on Excel. Alan is an Excel trainer, author, speaker, and is best known for his blog. Computergaga.com and YouTube ChannelWith the same name.