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-10 of 1048 results
Exclusive Filter tips 2 – more fun with FILTER()
  • Article
  • 09 Aug 2022
Last time we saw how the SUM() function can be combined with the new FILTER() function to calculate conditional aggregate values. This time we look at how to construct an aggregate formula to include all the items that are matched against an entire list of criteria values.
Exclusive Excel Tips and Tricks #451 – Sparklines Refreshed
  • Article
  • 05 Aug 2022
Hello all and welcome back to the Excel Tip of the Week. This week, we have a Creator post in which we are looking at another under-utilised piece of functionality within Excel – the Sparkline, last covered in TOTW #290.
Excel Community round up July 2022
  • Article
  • 02 Aug 2022
Here are all the new Excel articles and webinars from the Excel Community in July 2022.
Exclusive Excel Tips and Tricks #450 – Revisiting Custom Data Validation
  • Article
  • 26 Jul 2022
In this Creator post we revisit the topic of how to make custom data validation rules with functions.
Exclusive Is this the end for Excel’s SUMIFS() function?
  • Article
  • 22 Jul 2022
The conditional aggregate functions such as SUMIFS() have long been some of the most useful functions for working with financial data, but they have their shortcomings and there might now be a more flexible and capable alternative.
Exclusive Slicing One Element on a Chart Only
  • Article
  • 22 Jul 2022
Consider a scenario where create a chart, say, a line chart, but you only want one element (one of the lines) to be modified using a slicer. To illustrate, let’s have some data:
Exclusive Excel Tips and Tricks #449 - Let LET simplify formulas
  • Article
  • 19 Jul 2022
Hello all and welcome back to Excel Tips and Tricks! For this tip we have a Creator post where we introduce the LET formula in Excel and how this can be used to simplify otherwise long and complicated Excel formulas.
Exclusive Excel how to: speed up formatting using Excel Styles
  • Article
  • 15 Jul 2022
Having considered ways to speed up entering formulae in Excel in the first six posts in this series, this time we will move on to formatting and start by considering the use of Excel Styles and show how they can also help in applying several of the ICAEW Twenty principles for good spreadsheet practice.
Exclusive How to review a spreadsheet part 3: Analytical review
  • Article
  • 14 Jul 2022
In any spreadsheet review you are looking for signals of validity or potential error. A key part of this is a sense check that the numbers ‘look right’. This is supported by using charts (including sparklines), ratios and recalculation.
Exclusive Excel Tips and Tricks #448 – A Distinct Count Conundrum
  • Article
  • 13 Jul 2022
Hello all and welcome back to Excel Tips and Tricks! For this tip, we have a Creator post looking at the challenges around generating distinct counts by category and correctly calculating these as a percentage of the total population. This tip is based on a genuine scenario encountered when trying to produce some MI in relation to audit clients.
Displaying 1-10 of 1048 results