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 1374 results
Headshot of Mark Proctor
Exclusive The secret setting that stops charts breaking
  • 29 May 2026
  • Mark Proctor
Editing a chart in Excel can cause the existing custom format to disappear. In this article, Mark Proctor returns to explore a hidden setting that prevents this.
David Beniam
How to avoid ‘death by PowerPoint’
  • 28 May 2026
  • David Benaim
Tired of mind-numbing presentations packed with endless bullet points and text-heavy slides? We explore why traditional PowerPoint practices fail, uncover common pitfalls and share practical tips for crafting engaging, story-driven presentations. Transform your next slide deck from a snooze-fest into a memorable experience.
James Berridge
Exclusive EXCEL TIP OF THE WEEK Excel Tips and Tricks #506: Creating a single master list after merging data
  • 27 May 2026
  • James Berridge
A Creator level post exploring how to use Power Query to merge two data sources together to create a master list.
James Berridge
Exclusive EXCEL TIP OF THE WEEK Excel Tips and Tricks #505 – 3 ways of converting US Dates into UK formats
  • 27 May 2026
  • James Berridge
A Creator level post exploring three different ways of dealing with dates in the US format when you want UK format.
Giles Male and Fay Bordbar
Global Excel Summit 2026: The sum of what you missed, sorted by where to begin
  • 26 May 2026
  • Giles Male and Fay Bordbar
Welcome to another article from Giles Male and Fay Bordbar, Excel experts, and founders of ‘Excel on the Road’. In this article, Fay and Giles share their experience of co-hosting one of the biggest Excel events in the world – The Global Excel Summit! They also recap the biggest lessons learned from their UK tour so far and their visit to Accountex.
Liam Bastick
Exclusive Ungrouping Groups
  • 18 May 2026
  • Liam Bastick
Inconsistent datasets often appear in the real world ranging from sales figures, shorthand summaries and bespoke tables to inventory logs or data extracted from various sources. Without a clear structure, deriving insights or performing any analysis becomes nearly impossible.
Simon Hurst
Exclusive Tackling productivity hands on
  • 18 May 2026
  • Simon Hurst
There is an ongoing discussion about the UK’s stagnant or declining productivity. It might not be fair to attribute this solely to the inefficient use of spreadsheets but I’m sure it plays a significant part in the problem. Last time we investigated a few simple keyboard shortcuts that will help address the productivity crisis and this time we are moving on to some specific hardware considerations and skills.
Headshot of Mark Proctor
Exclusive Handling missing columns in Power Query
  • 30 Apr 2026
  • Mark Proctor
Missing columns in the source data can cause errors in Power Query that break the refresh process. In this article, Mark Proctor looks at five solutions to handle this scenario so your refresh always runs as expected.
Andrew Paw
Exclusive EXCEL TIP OF THE WEEK Excel Tips and Tricks #504 - Accessing accessibility checkers for good spreadsheet practice
  • 28 Apr 2026
  • Andrew Paw
Welcome back to Excel Tips and Tricks! This time, we have a Basic level post exploring Accessibility features, available in Excel and Google Sheets, that enable consistency and inclusivity by making spreadsheets easy to read and use for everyone. In this post, we also revisit the basics and explore how the features are important to consider for good spreadsheet practice.
Giles Male and Fay Bordbar
Exclusive Excel on the Road is… back on the road!
  • 24 Apr 2026
  • Giles Male and Fay Bordbar
Welcome to our second article from Giles Male and Fay Bordbar, Excel experts and founders of ‘Excel on the Road’. In this article, Fay and Giles take us along on their trip around the UK and introduce us to some tips learnt from the world of Excel Esports.
Liam Bastick
Exclusive Allocating Term Fees
  • 20 Apr 2026
  • Liam Bastick
This month, we consider allocating fees across monthly periods, where some dates are outside the forecast period and others straddle the (monthly) reporting periods.
Simon Hurst
Exclusive Simple shortcuts
  • 14 Apr 2026
  • Simon Hurst
Although it’s important to understand all of the wonderful advanced features that Excel has to offer and to keep up to date with the latest developments, sometimes discovering a really simple keyboard shortcut can be just as exciting. We are going to look at some deeply trivial shortcuts that might only save a second or two each time you use them but which, over the years, could save you enough time for an extra fortnight on a sunny beach somewhere.
Liam Bastick
Exclusive Allocating Term Dates
  • 24 Mar 2026
  • Liam Bastick
This month, we consider allocating days across monthly periods, where some dates are outside the forecast period and others straddle the (monthly) reporting periods.
Giles Male and Fay Bordbar
Introducing Excel on the Road: Who Are We and What on Earth Are We Doing?
  • 24 Mar 2026
  • Giles Male and Fay Bordbar
Welcome to the first of a regular series of articles from Giles Male and Fay Bordbar, Excel experts and founders of ‘Excel on the Road’. Whether you're an Excel enthusiast, a financial modelling professional, an early adopter of AI or someone looking to follow along on the journey in the name of learning, there's something here for you.
Headshot of Mark Proctor
Exclusive The Universal SUMIFS Solution
  • 16 Mar 2026
  • Mark Proctor
In this creator level post, Mark Proctor returns to look at the issues with SUMIFS in Excel and how to overcome them using a combination of filter and aggregation.
Simon Hurst
Exclusive AI slop will eat itself
  • 11 Mar 2026
  • Simon Hurst
Some of the Excel Community’s most popular recent articles and events have looked at how AI is changing the way in which we use spreadsheets. However, AI is affecting all areas of our life and is also being used for deeply malicious purposes. It’s possible that any general backlash against AI in general might have negative consequences for our readiness to accept its use in more specific applications. This article considers ways in which we could deal with that threat.
David Beniam
NEW TECH FEATURES New tech features for Dec-Feb 2026: Excel, Teams, Google Sheets, Chat GPT, M365, Power BI, Canva, Zoom ++
  • 04 Mar 2026
  • David Benaim
Our digest of new features across Microsoft 365 & other business tech products in written, images & video format covering the last three months.
Liam Bastick
Exclusive Unpivoting columns
  • 13 Feb 2026
  • Liam Bastick
Sometimes, when you work with pivoted data that has a structure similar to what would be generated if you had created a PivotTable, it is difficult to look up a value based upon multiple column and row criteria. To make it simpler, we usually unpivot the data. Most of the time, you might choose to use ‘Unpivot columns’ function in Power Query – but sometimes, it’s better to go with a dynamic formula.
Simon Hurst
Exclusive Train early, train often – part 2
  • 10 Feb 2026
  • Simon Hurst
Last time we looked at the potential benefits of structured training in a world swimming in free spreadsheet resources. This time we see how training can avoid a lifetime of regret and keep your spreadsheets firing on all cylinders (as they used to say in the days before electric vehicles).
David Beniam
Excel speed up tricks – part two: analytics productivity
  • 09 Feb 2026
  • David Benaim
Have you ever wanted to be the guy that amazes everyone by doing all the Excel actions in three moves instead of 14? This article is the second in a series of speed up tricks in Excel to enhance productivity. In this issue, we are covering analytics.
Displaying 1-20 of 1374 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
A colourful wooden abacus placed on a wooden surface, featuring multiple rows of beads in vibrant colours used for counting or basic arithmetic.