ICAEW.com works better with JavaScript enabled.

Excel

The Excel Community provides a 'one-stop shop' for accountants who want to use Excel better and understand and minimise spreadsheet risk.

If you are already a member of the IT Faculty, access to the Excel Community is already part of your faculty membership.

Join the Excel Community

Not already an Excel Community member? Find out more about the benefits of membership.

More info

Join Excel Community

Accountants love Excel. It is quick and easy to use and provides professional-looking analysis and reports. Recent developments in the product mean that huge amounts of data can now be stored and analysed.

Excel online training

Formally assess your level of spreadsheet expertise with an Excel IQ test.

More info

Excel online training

Are you a competent spreadsheet user? Have you ever had any formal training in Excel, or have you picked it up by trial and error, reading online help and talking with colleagues?

Webinar archive

Previous recordings of Excel webinars - helping you to make the most of your spreadsheets.

More info

Data handling

Improve data handling - data validation, sorting, text, lookup, filtering and much more.

More info

Data handling

Do you have trouble keeping up-to-date with the latest changes in Excel or not had time to attend formal training courses?

Data analysis

Functions, summarising data analysis in Excel, formulae auditing and much more.

More info

Data analysis

Do you have trouble keeping up-to-date with the latest changes in Excel or not had time to attend formal training courses?

Presentation

Cell and number formatting, conditional formatting, graphs, charts and much more.

More info

Presentation

This section of the website provides advice and guidance to help you improve your presentation using Excel, covering topics such as cell formatting, number formatting, conditional formatting, graphs and charts, reviewing and page and print set-up.

Minimising excel errors

Do you have a formal methodology for creating spreadsheets?

More info

Minimising Excel errors

Do you have a formal methodology for creating spreadsheets? Do you know how many there are in your organisation? Do you control who can access them or who can change them? Might they contain errors?

Other productivity tools

Understand and make use of the various tools available.

More info

Other productivity tools

Alongside Excel accountants have a number of other personal productivity tools in their portfolio, including word processing and database analysis.

Excel Twenty Principles

Find out more about the twenty principles for good spreadsheet practice.

More info

Competency Framework

Find out about the spreadsheet competency framework and the four key skill groups.

More info

ACA and CFAB students

Excel Community membership is available as part of your student membership.

Expand

Excel Community CFAB membership

ICAEW CFAB students, including Higher Apprentices and USS registrants, can now join ICAEW’s Excel Community, free of charge, and enjoy all the benefits it has to offer until the end of 2017.

Group membership

Discounted rates are available if 10 or more from the same organisation wish to join.

More info

Excel Community corporate membership

The Excel Community is a ‘one-stop-shop’ for professionals who use Excel and want to understand how to use it better. Joining the community will help you minimise spreadsheet errors by understanding the risks involved and how to overcome them. Organisations are able to join the Excel Community with group membership.