T Tool or technology HF-D7.1-003 transversal 9 kompetencer
Spreadsheets and worksheets
Builds worksheets with formulas, references and pivot tables, checks outcomes and presents figures understandably in tables and charts.
Sådan måler hrmforce dette
- Evalueringsmetode
- Work sample test · rho 0.33 (SD 0.09)
- hrmforce instrument
- Knowledge test (client-specific), Work sample test
- Kompetence (50-rammeværk)
- Accuracy
- Træningsmuligheder
- high
- Udsigter for efterspørgslen 2026 til 2030
- stable
The candidate performs a representative work sample under standardised conditions.
Adfærdsmæssige ankre
| Niveau | Adfærd på dette niveau |
|---|---|
| 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 og N4 er bevidst ikke forankret. Bedømmerne placerer dem mellem forankringerne i overensstemmelse med konventionen i O*NET.
Underliggende kompetencer
Disse kompetencer arver vurderingsforløbet og adfærdsankrene fra dette konstrukt.
| T | Kompetence | Definition | Udsigter for efterspørgslen 2026 til 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 |