ICAEW.com works better with JavaScript enabled.

Thought Leadership

Spreadsheet Competency Framework

Author: Excel Community

Published: 05 Jul 2016

The framework is a structure for assessing ability and proficiency when using spreadsheets. The framework consists of four key skill groups, described as levels. Each group has its own core competencies and other indicative skills. There is no formal assessment attached to the framework.

Basic user

A Basic user will mostly be carrying out data entry tasks. They will have a grounding in the essential skills needed to avoid major wasted effort or bad practice, but few technical skills beyond that. Anyone that uses spreadsheets should be at this level at a bare minimum.

General user

General users make up the majority of spreadsheet users, essentially modifying and updating spreadsheets on a regular basis. They may have some formula and other more technical knowledge, but are rarely called upon to undertake highly complex tasks, or to make spreadsheets entirely from scratch.

Creator

Creators use spreadsheets as a core element of their roles, and significantly use its functions and features. They often create spreadsheets from scratch and may create templates and workbooks for users at the first two levels.

Developer

Developers are the true masters of spreadsheets, with a grasp on the majority of the features of the package and ability to handle many complex tasks. They may be specialists such as modellers, VBA programmers, or statisticians.

Join the Excel Community

Do you use Excel in your organisation? Are you using it to its maximum potential? Develop your skills and minimise spreadsheet risk with our Excel resources. Membership is open to everyone - non ICAEW members are also welcome to join.

Excel polaroid
Spreadsheet Competency Framework

PDF (4,692kb)

Download the full report

Download