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 1298 results
Ruth Butler-Lee
Exclusive EXCEL TIP OF THE WEEK Excel Tips and Tricks #497 –BYROW and BYCOL
  • 28 Mar 2025
  • Ruth Butler-Lee
Welcome back to Excel Tips and Tricks! This time, we have a Creator level post exploring BYROW and BYCOL, functions that can help troubleshoot common issues when using Dynamic Arrays.
Headshot of Mark Proctor
Exclusive Ranges vs. Arrays – What's the difference, and why you should care?
  • 27 Mar 2025
  • Mark Proctor
In this article, we look at the differences between ranges and arrays. Compared to ranges, we will see that arrays give us total flexibility for making many Excel calculations easy to perform.
Simon Hurst
Exclusive Excel, what’s occurrin’ 6 – Towards Zero
  • 25 Mar 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. This time we conclude our exploration of dodgy numbers with a look at number formats and zeros.
Liam Bastick
Exclusive Calculated fields and calculated items
  • 24 Mar 2025
  • Liam Bastick
Liam Bastick looks at how calculated fields and calculated items can be used to solve problems in Excel, rather than resorting to more complicated functions.
David Beniam
New tech features for Dec 2024-Feb 2025: Excel, Teams, Power BI, Canva, Zoom, Google Sheets++
  • 14 Mar 2025
  • David Benaim
Our digest of new features across Microsoft 365 & other business tech products in written, images & video format covering December 2024 to February 2025.
Simon Hurst
Exclusive Excel, what’s occurrin’ 5 – getting iffy with it
  • 12 Mar 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. This time we are going to explore the use of the IF() function.
Headshot of David Fortin
YOUR QUESTIONS ANSWERED Your Questions Answered #13 - Mastering Copilot in Excel
  • 10 Mar 2025
  • David Fortin
In a recent webinar, David Fortin, Microsoft MVP and founder of Piggy Bank Accountant, explored how to get started with Microsoft’s Copilot and the basics of Copilot’s functionality in Excel. In this article, David returns to answer your most asked questions.
Headshot of Mark Proctor
Exclusive Using range functions in Excel
  • 04 Mar 2025
  • Mark Proctor
In this article, Mark Proctor, explores a group of functions which can dynamically manipulate ranges in Excel for flexible calculations.
Lego graph image
EXCEL COMMUNITY ROUND UP Excel Community round up - February 2025
  • 03 Mar 2025
  • Excel Community
Here are all the new Excel blogs and webinars from the Excel Community in February 2025.
A person holding a tablet device displaying various graphs
INSIGHTS VIEWPOINT INSIGHTS SPECIAL Why accountants must keep up with Excel functions
  • 27 Feb 2025
  • ICAEW Insights
Excel is continuing to evolve to meet accountants’ needs. Three experts explain why professionals must keep up with its new features.
A person holding a tablet device displaying various graphs
INSIGHTS VIEWPOINT INSIGHTS SPECIAL What does Excel proficiency look like in 2025?
  • 27 Feb 2025
  • ICAEW Insights
With new Excel functions coming on stream all the time, three experts tell us what it means to make the most of the tools for tackling current accounting challenges.
John Tennent
Exclusive Bringing Financial Reports Alive in Excel with Visualisation - Speedometers
  • 25 Feb 2025
  • John Tennent
In this fourth blog we will look at ways to report achievements of plans in the form of a speedometer. It’s a graphic that should be used sparingly so one or two of them have impact rather than a cluster of them where it becomes difficult to conclude the relative importance of each. They are ideal for reporting achievement of KPIs or year to date progress against targets. The more details added to the dial the easier it is to interpret. A plain dial is just a proportional assessment, a calibrated dial enables interpretation. The blog will guide you through drawing this example.
Simon Hurst
Exclusive Excel, what’s occurrin’ 4 – number or text?
  • 24 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 and references to ranges that omit vital cells, we are going on to consider numbers that are not numbers.
Headshot of Bani Lamba
Global Excel Summit 2025 – recap
  • 21 Feb 2025
  • Bani Lamba
This year, ICAEW’s Excel Community partnered with the Global Excel Summit, an award-winning conference for Excel enthusiasts. From the sessions hosted by MVPs and global experts we took away insights on a range of topics, including the latest Excel functionality, principles for best practice, and the skills required to advance in Excel. So, here's some of our highlights!
Liam Bastick
Exclusive Category sums
  • 20 Feb 2025
  • Liam Bastick
Liam Bastick discusses summarizing dynamic arrays by category in Excel. It explores using functions like SUMPRODUCT, SUMIFS, and MMULT to achieve this. He also offers a quirky solution using SUBTOTAL and OFFSET for dynamic range summation.
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.
Displaying 1-20 of 1298 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