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; Excel options, module installation and usage (Solver tool example); Visual Basic language in Excel: basic concepts in VB (variables and arrays, procedures and functions, conditional statements, loops, cell and sheet access), macros (VB editor, defining events, creation, running and examples of macros)
Certification Programme version/revision: EITC/BI/MSOEXv1r1)Earned ECTS credits: 2
