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 1274 results
John Tennent
Exclusive Bringing financial reports alive in Excel with visualisation – comparing data sets
  • 14 Feb 2025
  • John Tennent
This article is part of a series that supports the lunch and learn webinars on how to bring financial reports alive in Excel with visualisation. This third article will explore how to compare two data sets using a Waterfall Chart in Excel.
Simon Hurst
Exclusive Excel, what’s occurrin’ 3 – incomplete ranges
  • 07 Feb 2025
  • Simon Hurst
This series looks at some of the things that can go wrong in an Excel spreadsheet and at what we can do to avoid or resolve the issue. We start with the basics of making sure our numbers add up. Having looked at the use of the ROUND() function and the use of the potentially disastrous Precision as Displayed option, this time we investigate one of the most common causes for errors in Excel spreadsheets – references to ranges that omit vital cells.
Lego graph image
EXCEL COMMUNITY ROUND UP Excel Community round up - January 2025
  • 03 Feb 2025
  • Excel Community
Here are all the new Excel blogs and webinars from the Excel Community in January 2025.
Liam Bastick
Exclusive LIFO Modelling
  • 29 Jan 2025
  • Liam Bastick
In previous articles, I have twice previously considered modelling inventory, using both a simple averaging method to value the stock sold and then on a First In, First Out (FIFO) basis, which was a little bit trickier. Since then, I have been inundated with people asking me to complete the set: how do you model on a Last In, First Out (LIFO) basis?
Headshot of Mark Proctor
Exclusive Going Deep with REDUCE
  • 27 Jan 2025
  • Mark Proctor
In this article, Mark Proctor explores the REDUCE function in Excel and dives into its power for achieving advanced calculations.
Simon Hurst
Exclusive Excel, what’s occurrin’ 2 – Precision as displayed
  • 24 Jan 2025
  • Simon Hurst
This series looks at some of the things that can go wrong in an Excel spreadsheet and at what we can do to avoid or resolve the issue. We start with the basics of making sure our numbers add up. Having looked at the use of the ROUND() function in part 2, this time we move on to a far simpler and easier method with only one drawback, it could destroy the accuracy of your spreadsheet.
John Tennent
Exclusive Bringing financial reports alive in Excel with visualisation - visualising monthly results
  • 22 Jan 2025
  • John Tennent
This article is part of a series that supports the lunch and learn webinars on how to bring financial reports alive in Excel with visualisation. This second article will explore how to visualise monthly results with a range of charts and chart features in Excel.
Simon Hurst
Exclusive Excel, what’s occurrin’ – it doesn’t add up
  • 20 Jan 2025
  • Simon Hurst
This series looks at some of the things that can go wrong in an Excel spreadsheet and at what we can do to avoid or resolve the issue. We start with the basics of making sure our numbers add up.
David Beniam
100 new Excel features from the first half of the 2020s
  • 13 Jan 2025
  • David Benaim
We’re halfway through the decade and Excel has released so many features that its hard to keep track, so here is a whistle stop tour with over 100 features. Items marked with * are released on the current channel but not all channels, so these items may not be available to all now but should be by July 2025. Click File > Account to see which channel you are on.
Simon Hurst
Excel, asking for a friend
  • 06 Jan 2025
  • Simon Hurst
Stories of catastrophic spreadsheet errors often feature in the national media, but is this attitude to the use of spreadsheets risk obscuring a different, and much more significant problem: insidious spreadsheet inefficiency? We are asking for your help to find out.
Lego graph image
EXCEL COMMUNITY ROUND UP Excel Community round up - December 2024
  • 01 Jan 2025
  • Excel Community
Here are all the new Excel blogs and webinars from the Excel Community in December 2024.
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 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.
Displaying 1-20 of 1274 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