ICAEW.com works better with JavaScript enabled.

Excel Community

The Excel Community provides a 'one-stop shop' for accountants who want to use Excel.

Excel community featured article image
Featured article

Excel Tips and Tricks #452 - Named Ranges Refreshed

  • Article
  • 22 Aug 2022
  • Tom Edmunds
For this Creator post we have a refresher on Named Ranges in Excel, last covered way back in TOTW #188, and discuss their use and practical tips for working with them.
Read more

Online training for Excel Community members

We now offer a new and improved range of Excel online training, exclusively available as part of your Excel Community membership subscription. Track your progress and improve your Excel capabilities.

Register today
Excel training

Read the latest support and guidance from the Excel Community, including our very popular Tip of the Week series.

The Excel community has produced an extensive list of helpful tips and tutorials including its 'Excel tip of the week' series.  

Introduction to Financial Modelling

This 19-part series from 2020 and 2021 works through the chapters of our Financial Modelling Code and explains how each element translates into practice.

View our archive of Excel Community webinars.

Find out here about the Excel community's forthcoming webinars.

Search the 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. You can also search our Knowledge Base for access to all articles, new and archived, organised by topic.

Search the archive Access the knowledge base
Excel community
Professional development

Excel Community's programme of webinars

Improve your Excel knowledge and minimise spreadsheet risk by attending our webinars. We have a programme of CPD webinars that you can join from the comfort of your office.

Book now
Expert knowledge

Excel Community group membership

The Excel Community is for professionals who use Excel and want to understand how to use it better. Joining the Excel Community as a group member will provide you with an Excel online training dashboard so you can monitor the training progress of your colleagues.

Find out more


The ICAEW Library & Information Service provides full text access to a selection of key business and reference eBooks from leading publishers. eBooks are available to logged-in ICAEW members, ACA students and other entitled users. If you are unable to access an eBook, please see our Help and support advice or contact library@icaew.com.