ICAEW.com works better with JavaScript enabled.

Spreadsheet Competency Framework

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.

Spreadsheet Competency Framework

Download the full report here.

Download now

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.

The Excel Community’s training partner Filtered has created a free training course based around the competencies necessary for the first level, Basic User.  You can access that free course here.