T Tool or technology HF-D7.1-003 transversal 9 umiejętności
Spreadsheets and worksheets
Builds worksheets with formulas, references and pivot tables, checks outcomes and presents figures understandably in tables and charts.
W jaki sposób serwis hrmforce to mierzy
- Metoda oceny
- Work sample test · rho 0.33 (SD 0.09)
- hrmforce narzędzie
- Knowledge test (client-specific), Work sample test
- Kompetencje (50-ramowe)
- Accuracy
- Możliwość szkolenia
- high
- Prognoza popytu na lata 2026–2030
- stable
The candidate performs a representative work sample under standardised conditions.
Kotwice behawioralne
| Poziom | Zachowanie na tym poziomie |
|---|---|
| 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 i N4 celowo nie zostały przypisane do konkretnych punktów odniesienia. Oceniający umieszczają je pomiędzy punktami odniesienia, zgodnie z konwencją O*NET.
Podstawowe umiejętności
Umiejętności te dziedziczą ścieżkę oceny oraz punkty odniesienia behawioralne tej konstrukcji.
| T | Umiejętności | Definicja | Prognoza popytu na lata 2026–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 |