Certification Programme description: Introduction: basic definitions and concepts (cell, cell edition, formulas), sample formulas, cell references (relative, absolute), cell formatting (number formats, graphical formatting); Usage of spreadsheets in business: sample formulas and functions (basic, statistical, financial, etc.), pivot tables (creation, filters, row and column labels, values, functionality), data grouping, data sorting, data validation (validation criteria, messages); Charts: chart creation, chart data, chart types, chart as an object (design, layout and format tabs), chart graphical and 3D formatting, sample charts; OO Calc options, add-ons installation and usage (Solver tool example); OpenOffice.org BASIC language: basic concepts (variables and arrays, procedures and functions, conditional statements, loops, cell and sheet access), macros (defining events, creation, running and examples of macros)
Certification Programme version/revision: EITC/BI/OOCv1r1)Earned ECTS credits: 2
