Here are all the new Excel blogs and webinars from the Excel Community in September 2025.
Webinars
Excel Lunch and Learn Series: Discovering the underappreciated gems within the Excel Ribbon | File and Home
A guided tour of the lesser known but incredibly useful features and functionality tucked away in the Excel ribbons.
You can find our archive of all previous webinars here, many of which remain exclusive to Excel Community and ICAEW members.
Check our list of upcoming webinars or refer to the latest newsletter to see what is planned for the rest of the year.
Excel Tips & Tricks
This Basic Level post explores some simple tips and tricks for printing your data.
Blogs
Excel Community round up – August 2025
Here are all the new Excel blogs and webinars from the Excel Community in August 2025.
The Excel feature that might be better than AI
Microsoft has introduced several revolutionary new features in Excel in recent years. In particular, Microsoft’s Copilot feature uses AI to help with Excel tasks. However, there might be another Excel feature that is even more impressive.
This month’s highlights
Perhaps every month you wonder how sales have gone compared to the same month last year. This post demonstrates one way of automatically highlighting the comparison using conditional formatting. Also, just because we can, we’ve used an example based on a PivotTable to demonstrate the technique.
Add column vs transform column in Power Query
In this Creator level article, Mark Proctor returns to go beyond the basic Power Query interface and discover how to perform advanced transformations on existing columns.
Listing Duplicates
This article introduces a dynamic Excel 365 formula to accurately identify duplicates in lists containing numbers, text, and entries with leading zeroes—where traditional methods like COUNTIF fall short. Using functions like LET, UNIQUE, MMULT, and FILTER, it builds a matrix-based solution that preserves formatting and reliably detects repeated values.
Join the Excel Community
Do you use Excel in your organisation? Are you using it to its maximum potential? Develop your skills and minimise spreadsheet risk with our Excel resources. Membership is open to everyone - non ICAEW members are also welcome to join.
Archive and Knowledge Base
This archive of Excel Community content from the ION platform will allow you to read the content of the articles but the functionality on the pages is limited. The ION search box, tags and navigation buttons on the archived pages will not work. Pages will load more slowly than a live website. You may be able to follow links to other articles but if this does not work, please return to the archive search. You can also search our Knowledge Base for access to all articles, new and archived, organised by topic.
