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 1289 results
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.
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.
Simon Hurst
Exclusive Unsend your emails
  • 09 Oct 2024
  • Simon Hurst
Inspired by a recent catastrophic email event that made the national news, we once again abandon Excel to look at another Office application, this time Microsoft Outlook. In particular, we see how Outlook can help to protect us from ourselves.
Headshot of Mark Proctor
Exclusive Using slicers with PIVOTBY, GROUPBY and FILTER
  • 01 Oct 2024
  • Mark Proctor
The newest functions, GROUPBY and PIVOTBY will be rolling out to users over the next few months. In this article, we uncover the techniques we can implement for using slicers with these new functions.
Headshot of Ian Pay
Exclusive EXCEL TIP OF THE WEEK Excel Tips and Tricks #495 - Excel “Tick”ery!
  • 27 Sep 2024
  • Ian Pay
Welcome back to Excel Tips and Tricks! For our latest tip, we have a General User post exploring one of the latest pieces of Excel functionality – Checkboxes.
Liam Bastick
Exclusive Top 12 Excel Combinations: 4. SORT UNIQUE
  • 24 Sep 2024
  • Liam Bastick
In the latest instalment of his series counting down the "Top 12" of Excel function combinations, Liam Bastick considers SORT UNIQUE.
Simon Hurst
Exclusive SIMPLE BUT EFFECTIVE TABLES Simple but effective Tables. Part 10
  • 23 Sep 2024
  • Simon Hurst
In this series we are going to examine some of the capabilities of Excel Tables. We will be concentrating on the practical use of Tables to improve spreadsheet productivity. We are going to conclude our series of articles on the practical use of Excel Tables by looking at how Tables work with Power Query.
Simon Hurst
Exclusive The one click solution to all your Word problems
  • 23 Sep 2024
  • Simon Hurst
We venture outside the world of Excel to examine how you can resolve all your Word issues with a single mouse click or keyboard shortcut.
Ruth Butler-Lee
Exclusive EXCEL TIP OF THE WEEK Excel Tips & Tricks #494 - How to add a custom ribbon to your workbook part 3
  • 16 Sep 2024
  • Ruth Butler-Lee
This week, we have a developer level post which explores how to set up your custom ribbon with a combo box.
David Beniam
NEW TECH FEATURES Excel, Teams, Power BI, Canva, Zoom, Google Sheets++: New tech features for Jun-Aug 2024
  • 09 Sep 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.
Simon Hurst
Exclusive SIMPLE BUT EFFECTIVE TABLES Simple but effective tables, part 9
  • 09 Sep 2024
  • Simon Hurst
In this series we are going to examine some of the capabilities of Excel Tables. We will be concentrating on the practical use of Tables to improve spreadsheet productivity. The previous two-part article looked at the use of structured references to refer to all or part of an Excel Table, from cells outside of the Table as well as cells within the Table. We are going to conclude our exploration of Tables by looking at Filtering and Sorting, and using Sparklines and check boxes in Table columns. Then, in the next part of the series, we will look at how Tables work with Power Query.
Lego graph image
EXCEL COMMUNITY ROUND UP Excel Community round up - August 2024
  • 02 Sep 2024
  • Excel Community
Here are all the new Excel blogs from the Excel Community in August 2024.
Liam Bastick
Exclusive Top 12 Excel Combinations: 5. SCAN LAMBDA
  • 29 Aug 2024
  • Liam Bastick
In the latest instalment of his series counting down the "Top 12" of Excel function combinations, Liam Bastick considers SCAN LAMBDA.
Simon Hurst
Exclusive Can spreadsheets show us how to deal with online misinformation?
  • 28 Aug 2024
  • Simon Hurst
We seem to have learned to live with spreadsheets, despite them giving us the wrong answer 90% of the time. Are there any lessons to be learnt from our ability to adapt to fallible spreadsheets that can help us deal with online misinformation?
Ruth Butler-Lee
Exclusive EXCEL TIP OF THE WEEK Excel Tips & Tricks #493 - How to add a custom ribbon to your workbook part 2
  • 14 Aug 2024
  • Ruth Butler-Lee
This week, we have a developer level post which explores how to set up your custom ribbon with tailored buttons.
Displaying 1-20 of 1289 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