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 1063 results
Exclusive Excel Tips and Tricks #456 - Revisiting loan modelling
  • Article
  • 03 Oct 2022
Welcome back to Excel Tips! This week, we have a creator-level post in which we will be revisiting how to model the draw down, interest and repayments on a loan, last covered in TOTW #246.
Clustered stack column chart
  • Article
  • 26 Sep 2022
Pie and donut charts are not recommended for comparatives, this article suggests how to do them with a clustered stack column chart
Exclusive Excel Tips and Tricks #455 - Data Conversion
  • Article
  • 26 Sep 2022
Hello all and welcome back to the Excel Tips and Tricks. This week, we have a General User post in which we are taking a closer look at how to convert data types in Excel.
Exclusive TEXTBEFORE(), TEXTAFTER, TEXTSPLIT()
  • Article
  • 22 Sep 2022
Three new text functions have been introduced in Excel to help extract values from text containing some sort of delimiter. We take a detailed look at some of the arguments available as part of these new functions to help you to get the most from them and also highlight some significant changes between the preview and release versions of the functions.
Exclusive How to Review a Spreadsheet Part 4: Design Principles and Formula Errors
  • Article
  • 21 Sep 2022
The last three blogs in this series will now look at validating the details within the spreadsheet. The range of these items that should be applied will need to be proportionate to the context, scale and risk of the spreadsheet being reviewed.
Exclusive Excel how to: speed up data entry
  • Article
  • 16 Sep 2022
We look at how to make entering data into an Excel workbook as quick and efficient as possible by knowing the effect of some key Excel options and features, together with some useful keyboard shortcuts.
Exclusive Excel Tips and Tricks #454 – Revisiting splitting workbooks with VBA
  • Article
  • 13 Sep 2022
A Developer level post in which we are going to work through the VBA code required to take a workbook and cut it into one file for each sheet, and save all the resulting files.
New tech features for Jun-Aug 2022
  • Article
  • 12 Sep 2022
Our digest of new features across Microsoft 365 & other business tech products in written, images & video format covering the last three months.
Exclusive Dynamic Arrays – still one leg short of a table?
  • Article
  • 12 Sep 2022
Coming soon: some additional functions for manipulating Dynamic Arrays, but will they do anything to rectify existing deficiencies?
Excel Community round up - August 2022
  • Article
  • 02 Sep 2022
Here are all the new Excel articles from the Excel Community in August 2022.
Displaying 1-10 of 1063 results