ICAEW.com works better with JavaScript enabled.

Industry accountants

Published: Yesterday at 03: 01 PM BST Updated: Yesterday at 03: 01 PM BST Update History

ICAEW has created a framework for understanding and mapping finance practitioners' ability and proficiency when using spreadsheets. We outline the level of skill needed for each competency and mapped competencies we expect are needed for industry accountants.

Industry accountants are qualified financial professionals operating within commercial businesses rather than traditional accountancy firms, often undertaking varied roles that range from preparing budgets and forecasts to analysing datasets from various internal systems. 

Relevant competencies

Because organisations depend heavily on the spreadsheets these professionals create and maintain, robust design and adherence to best practice are core competencies. Furthermore, as corporate decisions are frequently driven directly by spreadsheet outputs, mastering spreadsheet review and error-protection is essential. Finally, while maximising user efficiency is highly beneficial given the frequency of daily use, the diverse nature of these corporate roles means most other advanced functionalities are also viewed as complementary competencies that enhance overall capability.

The competency framework

The framework is colour coded to illustrate the relevance of each competency.

  • Core competencies form the essential Excel knowledge required for this job role.
  • Beneficial competencies are additional skills individuals may choose to develop to strengthen their capability.
  • Less relevant competencies remain useful Excel skills but are not as directly applicable to the role and therefore may be given lower priority.
Colour key: Core (orange), Beneficial (green), Less relevant (blue)

Below is an interactive summary of the core competencies, as well as those beneficial to develop further capabilities, for this job role. Click through each section, in the left-hand column, to explore the framework.