Here are all the new Excel blogs and webinars from the Excel Community in November 2025.
Webinars
Excel Lunch and Learn Series: Discovering the underappreciated gems within the Excel Ribbon | Formulas and Data
A guided tour of the lesser known but incredibly useful features and functionality tucked away in the Excel ribbons.
Covering a practical introduction to Dynamic Arrays in Excel and how dynamic arrays address the common problems faced when using traditional Excel formulas in financial modelling.
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.
Blogs
Excel Community round up – October 2025
Here are all the new Excel blogs and webinars from the Excel Community in October 2025.
Dealing with complex conditional formatting rules simply
Simon Hurst looks as simplifying the way we can apply conditional formatting based on a more complicated calculation.
Why blank cells calculate as zero and does it matter?
This article explores how Excel treats blank cells. If handled incorrectly, a blank cell can cause calculation errors and produce misleading outputs. So, while they may seen insignificant, they can cause havoc.
Conditional formatting – beyond icons
Looking at advanced options available for the other graphical conditional formats: Data Bars and Colour Scales.
Partial Unpivoting
Sometimes, when you work with pivoted data that has a structure similar to a PivotTable, it is difficult to look up a value based on multiple column and row criteria. To make is simpler, we usually unpivot the data. Most of the time, you may choose to use the ‘Unpivot columns’ function in Power Query.
Excel speed up productivity tricks
Have you ever wanted to be the guy that amazes everyone by doing all the Excel actions in 3 moves instead of 13? This article is the first in a series of speed up tricks in Excel. Here we are talking about number formats and special characters.
This year’s 10 best Excel highlights
As we approach the new year, it’s time to reflect on some of the content and highlights from the Excel Community in 2025 and look ahead as Excel continues to change and develop with new functionality.
Excel essentials for auditors: Part 1 | Practical tips from the ground up
In this series, James Berridge, Director at Saffery LLP, explores core Excel functionality and essential skills that every auditor should master to support their audit roles. This first article focuses on navigation and basic formula tips, builds onto each text manipulation, and highlights the use cases for lookups and pivot tables in substantive testing.
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.
