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 1303 results
Liam Bastick
Exclusive Top 12 Excel Combinations: 1. INDEX MATCH
  • 13 Dec 2024
  • Liam Bastick
For 2024, I thought I would count down a very subjective “Top 12” of Excel function combinations. And this month’s offering makes it very clear that this is a highly subjective list. If you don’t like this month’s suggestion, that’s fine; life would be boring if we were all in agreement.
Simon Hurst
Exclusive From numbers to pictures – using INDEX() with MAKEARRAY()
  • 13 Dec 2024
  • Simon Hurst
Having in the previous post used several of the new LAMBDA() helper functions, most notably MAKEARRAY(), to calculate the total number of gifts given across the 12 days of Christmas, this time we are going to replace our numbers with pictures that represent each of the gifts.
Headshot of Bani Lamba
Exclusive Your 2025 Excel Community Guide
  • 11 Dec 2024
  • Bani Lamba
As we step into a new year, we’re delighted to welcome all our members to the growing Excel Community. With over 1,000 articles, over 490 tips, 4 thought leadership guides and an extensive archive of webinar recordings, we realise that it can sometimes be tricky to find what you’re looking for. So, here is a guide that you can use as a starting point to make the best use of your community.
Headshot of Mark Proctor
Exclusive YOUR QUESTIONS ANSWERED Your Questions Answered #12 – Getting started with Office Scripts
  • 11 Dec 2024
  • Mark Proctor
Following on from ‘A beginner's guide to automating in Excel using Office Scripts’ webinar, Mark Proctor, Microsoft MVP and Director at Excel Off The Grid, returns to address more of the questions that came out of the webinar on how to get started with Office scripts to automate tasks and processes in Excel.
Simon Hurst
Exclusive Spoiler alert: the answer is 364
  • 09 Dec 2024
  • Simon Hurst
It’s festive-themed quiz season. We use a common Christmas quiz question as the pretext for examining a range of LAMBDA() based Excel functions.
David Beniam
NEW TECH FEATURES Excel, Teams, Power BI, Canva, Zoom, Google Sheets++: New tech features for Sep-Dec 2024
  • 09 Dec 2024
  • David Benaim
Our digest of new features across Microsoft 365 & other business tech products in written, images & video format covering the last three months.
Lego graph image
EXCEL COMMUNITY ROUND UP Excel Community round up - November 2024
  • 02 Dec 2024
  • Excel Community
Here are all the new Excel blogs and webinars from the Excel Community in November 2024.
Headshot of Bani Lamba
Exclusive EXCEL TIP OF THE WEEK Your Excel Community – Highlights from 2024
  • 29 Nov 2024
  • Bani Lamba
As we approach a new year, it’s time to reflect on the best content from the Excel Community in 2024 and look ahead as the community grows and develops. Whether you’re new or an existing member, we invite you to explore the insights and learnings the community has delivered for you over this last year.
David Beniam
Excel’s GROUPBY & PIVOTBY functions vs PivotTables
  • 29 Nov 2024
  • David Benaim
One of Excel’s most significant updates this decade is without a doubt the new GROUPBY and PIVOTBY functions, these can replicate PivotTables functionality through formulas, so here I will compare and contrast both methods whilst providing possibly the most complete guide on the internet currently of GROUPBY.
Simon Hurst
Exclusive Separating your clients
  • 27 Nov 2024
  • Simon Hurst
This post was prompted by a support query about automating the extraction of client names from cells that could contain other information after the name. Based on the use of one or more delimiter characters to separate the client name from the additional information, we are going to look at using the TEXTBEFORE() function with different delimiter alternatives.
John Tennent
Exclusive Bringing financial reports alive in Excel with visualisation
  • 26 Nov 2024
  • John Tennent
This is the first article of a series that supports the lunch and learn webinars that will show you how to bring the financial reports alive in Excel with visualization. This article will explore the journey from raw data to actionable insights.
Liam Bastick
Exclusive Top 12 Excel Combinations: 2. SUMPRODUCT OFFSET
  • 25 Nov 2024
  • Liam Bastick
In the latest instalment of his series counting down the "Top 12" of Excel function combinations, Liam Bastick considers SUMPRODUCT OFFSET.
Simon Hurst
Exclusive Taking the new GROUPBY() and PIVOTBY() functions further
  • 20 Nov 2024
  • Simon Hurst
The main capabilities of the recently introduced GROUPBY() and PIVOTBY() functions have already been covered in recent articles. Here we are going to look at one aspect of their use in a bit more detail: the ability to use functions and formulas within the individual arguments of each function.
Simon Hurst
Exclusive Ticks, crosses and noughts
  • 05 Nov 2024
  • Simon Hurst
Experimenting with an Excel tip in a recent LinkedIn post leads to an exploration of the use of conditional formatting for adding ticks and crosses to Excel cells, and the discovery of a surprising comparison capability.
Lego graph image
EXCEL COMMUNITY ROUND UP Excel Community round up - October 2024
  • 01 Nov 2024
  • Excel Community
Here are all the new Excel blogs and webinars from the Excel Community in October 2024.
Liam Bastick
Exclusive Top 12 Excel Combinations: 3. IFERROR FORMULATEXT
  • 31 Oct 2024
  • Liam Bastick
In the latest instalment of his series counting down the "Top 12" of Excel function combinations, Liam Bastick considers IFERROR FORMULATEXT.
Headshot of Mark Proctor
Exclusive Solving the array of arrays issue
  • 25 Oct 2024
  • Mark Proctor
In this post, we explore the "array of arrays" issue in Excel’s calculation engine. We demonstrate how this leads to unexpected results and how we can work around the issue.
Simon Hurst
Exclusive Excel’s real-life superpowers
  • 24 Oct 2024
  • Simon Hurst
Useful as some features are when used in a spreadsheet, they could be even more empowering if available in real-life. In this article we consider some examples and explore the use of AI in illustrating the possibilities.
Headshot of Bani Lamba
Exclusive EXCEL TIP OF THE WEEK Excel Tips and Tricks #496 – ‘Check Performance’ in Excel
  • 23 Oct 2024
  • Bani Lamba
Welcome back to Excel Tips and Tricks! This week, we have a General User level post exploring the ‘Check Performance’ functionality to improve workbook performance in Excel.
Simon Hurst
Exclusive Multiple conditional formats
  • 18 Oct 2024
  • Simon Hurst
It is possible to apply multiple conditional formats to the same cell or range of cells. Where rule formats don’t clash with other rules, then all the rules that satisfy the condition will be applied. However, where rules are mutually exclusive, for example where they both change the font colour, rules are evaluated in a specific order of priority. In this article we look at making sure that your rules are in the right order.
Displaying 1-20 of 1303 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