Certification Programme description: > Microsoft Office Word: Introduction: main window, ribbon, Microsoft Office Button, Quick Access toolbar, printable and nonprintable characters, ruler, paragraph, indentation, margins, navigation, keyboard shortcuts; Document creation and edition: simple editing (copy, paste, cut), text formatting (font type, style, size), text alignment, line spacing, bullets and numbering (multilevel lists), auto-formatting (styles, table of contents, footnotes); Tables: creation methods, selection in tables, automatic formatting, table properties, text in a cell, AutoFit, cell size adjustment, graphical formatting; Objects in document: images (inserting and formatting), shapes (shape selection menu, categories of shapes, shape formatting, text in shapes), footer and header, SmartArts (inserting, categories, editing and formatting) > Microsoft Office Excel: 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) > Microsoft Office Power Point: Introduction: main window, slide, notes, fields on a slide; Creating a presentation: title slide, creating and editing a slide (types of slide layouts), themes (theme editing), slide show; Objects on a slide: inserting and editing objects, usage examples (formatting, many shapes insertion, shape connectors), objects overlapping, editing objects (shapes, SmartArts, images, tables); Object animation and transitions between slides: animation definition, animation modification (custom animation, auto-preview, animation effects, animation parameters, timing, triggers), adding and editing transitions between slides (single transition, transition parameters); Spell checking in MS Office (error corrections, dictionary); Slide Sorter view (slide operations: move, duplicate, copy, paste, delete); Printing (print types); Help in Microsoft Office (search for help topics, online and offline mode)
Certification Programme version/revision: EITC/BI/MSO10v1r1)Earned ECTS credits: 2
