ICAEW.com works better with JavaScript enabled.

Excel Community articles

Read the latest support and guidance from the Excel Community, including our very popular Tip of the Week series.
Displaying 1-20 of 1353 results
James Berridge
Exclusive Excel Essentials for Auditors: Part 1 Practical Tips from the Ground Up
  • 26 Nov 2025
  • James Berridge
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 easy text manipulation, and highlights the use cases for lookups and pivot tables in substantive testing.
Headshot of Bani Lamba
This year’s 10 best Excel highlights
  • 24 Nov 2025
  • Bani Lamba
As we approach a 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. Whether you’re new or an existing member, in this article we invite you to explore the insights and learnings the community has delivered for you over this last year.
David Beniam
Excel speed up productivity tricks
  • 21 Nov 2025
  • David Benaim
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.
Liam Bastick
Exclusive Partial Unpivoting
  • 20 Nov 2025
  • Liam Bastick
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 it simpler, we usually unpivot the data. Most of the time, you may choose to use the ‘Unpivot columns’ function in Power Query.
Simon Hurst
Exclusive Condition formatting - beyond icons
  • 17 Nov 2025
  • Simon Hurst
Having covered some of the advanced options available for working with conditional formatting Icon Sets in previous posts, this time we will look at the advanced options available for the other graphical conditional formats: Data Bars and Colour Scales.
Headshot of Mark Proctor
Exclusive Why blank cells calculate as zero and does it matter?
  • 14 Nov 2025
  • Mark Proctor
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 seem insignificant, they can cause havoc.
Simon Hurst
Exclusive Dealing with complex conditional formatting rules simply
  • 10 Nov 2025
  • Simon Hurst
Last time, we continued our exploration of some of the advanced options available for working with Conditional Formatting Icon Sets.
Lego graph image
EXCEL COMMUNITY ROUND UP Excel Community round up - October 2025
  • 04 Nov 2025
  • Excel Community
Here are all the new Excel blogs and webinars from the Excel Community in October 2025.
Simon Hurst
Exclusive Making conditional formatting more interactive and more automatic
  • 27 Oct 2025
  • Simon Hurst
Last time, we delved into the advanced options available for working with Conditional Formatting Icon Sets. This time we will make use of the extra flexibility that putting the value in a cell allows us, and use an Excel Spin Button to set the value more easily. We will then explore the use of a formula to calculate the threshold value automatically.
Liam Bastick
Exclusive Running totals in filtered tables
  • 27 Oct 2025
  • Liam Bastick
In this article, Liam Bastick considers the problem of ensuring running totals still work, whether an Excel table is filtered or not.
Simon Hurst
Exclusive Controlling your icons with conditional formatting
  • 14 Oct 2025
  • Simon Hurst
Last time, we looked at one way of automatically highlighting certain cells in a PivotTable using conditional formatting. There are several different ways of using conditional formatting to apply highlights, with Colour Scales and Icon Sets being perhaps the most obvious. These two graphical conditional formats are included in the Conditional Formatting dropdown and can easily be applied with a mouse click or two. However, sometimes using too many colours and too many different icons can have the opposite effect to that intended, obscuring the information rather than drawing attention to the k...
David Beniam
Excel, Teams, Google Sheets, Chat GPT, M365, Power BI, Canva, Zoom ++: New tech features for June-Sept 2025
  • 10 Oct 2025
  • David Benaim
Our digest of new features across Microsoft 365 & other business tech products in written, images & video format.
Lego graph image
EXCEL COMMUNITY ROUND UP Excel Community round up - September 2025
  • 01 Oct 2025
  • Excel Community
Here are all the new Excel blogs and webinars from the Excel Community in September 2025.
Liam Bastick
Exclusive Listing Duplicates
  • 29 Sep 2025
  • Liam Bastick
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.
Headshot of Mark Proctor
Exclusive Add column vs. transform column in Power Query
  • 29 Sep 2025
  • Mark Proctor
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.
Lego graph image
Exclusive EXCEL TIP OF THE WEEK Excel Tips and Tricks #503 – Printing under pressure, super quick presentation tips
  • 23 Sep 2025
  • Thomas Edmunds
Welcome back to Excel Tips and Tricks! This time, we have a Basic level post exploring some simple tips and tricks for printing your data.
Simon Hurst
Exclusive This month’s highlights
  • 18 Sep 2025
  • Simon Hurst
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.
Simon Hurst
Exclusive The Excel feature that might be better than AI
  • 11 Sep 2025
  • Simon Hurst
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.
Lego graph image
EXCEL COMMUNITY ROUND UP Excel Community round up - August 2025
  • 01 Sep 2025
  • Excel Community
Here are all the new Excel blogs and webinars from the Excel Community in August 2025.
Liam Bastick
Introducing Excel’s New COPILOT Function
  • 22 Aug 2025
  • Liam Bastick
Excel has launched it’s “latest and greatest” function, COPILOT. Currently it is in Beta and only available to users on the Beta Channel, through the Microsoft Insider Program.
Displaying 1-20 of 1353 results

Excel Community archive

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.

Search the archive View the index
Excel polaroid