ICAEW.com works better with JavaScript enabled.

Excel Community resources

Key resources for Excel Community members.

Charts and graphs

Articles and webinars on Excel charts and graphs.

Data tables

View our helpful guidance and advice on using data tables.

Filtering and queries

Articles and webinars on filtering and queries.

Formulas and functions

Articles and webinars on formulas and functions.

PivotTables

Articles and webinars on PivotTables.

Reports and dashboards

Articles and webinars on reports and dashboards.

VBA and macros

Articles and webinars on VBA and macros.

Worksheet design & formatting

Articles and webinars on worksheet design and formatting.

Wider productivity tools

Articles on other business tech products and wider productivity tools such as the Microsoft Office suite.

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