Spreadsheet Skills for Analysis
Practical spreadsheet analysis for industrial and energy professionals: structuring and cleaning data, lookups, pivot tables, conditional logic, and the controls that keep a business-critical workbook from producing confident but wrong answers.
Los cuatro niveles
Cada nivel se basa en el anterior.
- 1Sensibilización
- 2Conocimiento
- 3Habilidad
- 4Dominio
Habilidad y Dominio se demuestran en el trabajo, no con un curso: un evaluador de su organización le da su aprobación en corp.icompetent.com.
Los cursos de esta competencia están en camino. Mientras tanto, consulte el catálogo de cursos.
Qué aprenderá
- Structure data as a clean table — one row per record, one column per field — and explain why messy sheets break analysis
- Clean imported data by trimming text, converting text to numbers and dates, splitting combined fields and handling blanks deliberately
- Apply exact-match lookups, conditional logic and error handling, and explain why approximate match is dangerous
- Aggregate data with pivot tables and build a chart from the pivot that answers a stated question
- Use named ranges and absolute, relative and mixed references so formulas survive being copied and extended
- Control spreadsheet risk through input/calculation/output separation, peer review and version control, and recognise when a database or BI tool is needed instead
¿Quiere desarrollar la competencia Spreadsheet Skills for Analysis?
Haga un curso que desarrolle esta competencia. Cuando lo termine, el nivel aparecerá en su perfil.