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 1346 results
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.
Simon Hurst
Exclusive Seeing stars – managing relationships with Power BI
  • 13 Aug 2025
  • Simon Hurst
In our short series on Power BI and conditional formatting we have so far added a star to highlight our 500th Tips and Tricks article and then created a table to identify key articles for our on-demand course modules so that we can add a star to each of those articles too. This has given us the opportunity to look at data structures and joins between tables as well as conditional formatting itself. This time we will investigate the table joins in a bit more detail.
Lego graph image
Exclusive EXCEL TIP OF THE WEEK Excel Tips and Tricks #502
  • 11 Aug 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 formatting your data to maximise its impact.
Liam Bastick
Exclusive Summarising Vertical Lists Horizontally
  • 08 Aug 2025
  • Liam Bastick
For the second month running, I have an article inspired by recent consulting problems. Obviously, I will change the data! Imagine we have a table called Data (sorry, that’s as far as my imagination goes!) that contains details of some new items and their suppliers in a standard tabular format (i.e. a vertical list), as below. Let’s suppose we need to import this data into an inventory management system.
David Beniam
40 years of Excel's weird & wonderful quirks
  • 05 Aug 2025
  • David Benaim
The world’s favourite spreadsheet turns 40 next month, so before a full-on Excel-stential crisis (with a title like that you didn’t expect some bad puns?), let’s explore some oddities.
Simon Hurst
Exclusive Not dead yet – refreshing update for PivotTables
  • 04 Aug 2025
  • Simon Hurst
Rarely do meetings of the Excel Community Advisory Group descend into actual fisticuffs but, on the rare occasions when an unseemly brawl has erupted, an argument over the benefits or otherwise of PivotTables has invariably been the cause. For some, the recent introduction of dynamic array functions, and GROUPBY() and PIVOTBY() in particular, seemed to have turned the tables firmly in favour of the PivotTable sceptics. However, just as they were basking in the warm glow of vindication, a new option has appeared for Excel Beta Channel users in the PivotTable Analyze ribbon tab, Data group – Aut...
Lego graph image
EXCEL COMMUNITY ROUND UP Excel Community round up - July 2025
  • 01 Aug 2025
  • Excel Community
Here are all the new Excel blogs and webinars from the Excel Community in July 2025.
Headshot of Mark Proctor
Exclusive What is scalar lifting, and why should you care?
  • 31 Jul 2025
  • Mark Proctor
What happens when we provide multiple values to a function argument which expects a single value? We encounter the magic of Excel’s dynamic array calculation engine.
Displaying 1-20 of 1346 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