T Tool or technology HF-D7.1-003 transversal 9 skills

Spreadsheets and worksheets

Builds worksheets with formulas, references and pivot tables, checks outcomes and presents figures understandably in tables and charts.

How hrmforce measures this

The candidate performs a representative work sample under standardised conditions.

Level	Behaviour at this level
N1 Guided	Enters data in an existing worksheet and uses simple formulas such as sum and average as instructed. works under supervision and follows instruction · routine, one variable at a time · own task
N3 Proficient	Builds a worksheet with linked formulas and pivot tables, checks for errors and explains the calculation logic to colleagues. sets own approach and seeks input proactively · several variables, some ambiguity · own team or process
N5 Leading	Sets the standards for calculation models in the organisation and judges whether models are reliable enough for decision making. sets the standard and the policy · strategic, under high uncertainty · organisation, value chain or profession

N2 and N4 are deliberately not anchored. Raters place them between the anchors, following the O*NET convention.

These skills inherit the assessment route and the behavioural anchors of this construct.

T	Skill	Definition	Demand outlook 2026 to 2030
T	Microsoft Excel Excel	Builds and maintains Excel worksheets with formulas, tables, charts and data validation for recurring calculations.	stable
V	Building formulas and cell references Spreadsheet formulas	Writes formulas with absolute and relative references, nests functions and keeps the calculation traceable for others.	stable
V	Using VLOOKUP and XLOOKUP VLOOKUP · XLOOKUP	Retrieves data from another table with lookup functions and handles values that are not found cleanly.	stable
V	Using conditional formatting Conditional formatting	Makes cells change colour or icon automatically based on rules so deviations stand out immediately.	stable
V	Filtering and sorting data Data filtering	Filters and sorts large lists, uses slicers and records which selection underlies a given outcome.	declining
V	Setting up data validation Data validation	Restricts allowed input in cells with drop down lists and rules so users cannot enter unusable values.	stable
V	Creating charts in a spreadsheet Charting	Chooses a suitable chart type, labels axes and series and keeps the chart readable without a misleading scale.	declining
T	Google Sheets Google Sheets	Collaborates in Google Sheets using formulas, shared views and functions that pull data live from other sheets.	stable
V	Auditing worksheets for errors Spreadsheet auditing	Detects formula errors, broken references and manual overrides and restores the reliability of the worksheet.	rising