Page 1
Special courses
Category overview
Category description is not available yet.
Contents
Active courses: 3
Price incl. VAT
0.00 €
Current VAT 23%
Duration
Day: 1 day · Evening: 2 days
Course overview
The webinar is intended for teachers of all schools and is organized in cooperation with Microsoft. Its role is to help educate and prepare teachers. It is free for all teachers at all levels.
Minimum input knowledge
Regular work with a computer and the internet. No specific experience with PowerPoint is assumed, but any experience with MS Office programs is an advantage. A computer with Office 365.
Output knowledge
A course graduate is familiar with the PowerPoint environment and can orient themselves in the categories on the ribbon. The graduate is prepared for creating presentations and further education in PowerPoint.
Training syllabus
Program Setup
- Layout setup Creating a template
Working with Graphics
- Graphic objects Editing graphic objects
Working with Text
- Theory of font use (fonts, cuts) Working with text blocks Editing the shape of text
Finalization
- Document check Preparing documents for printing and export
Price incl. VAT
0.00 €
Current VAT 23%
Duration
Day: 1 day · Evening: 2 days · Weekend: 1 day
Course overview
The webinar is intended for teachers of all schools and is organized in cooperation with Microsoft. Its role is to help educate and prepare teachers. It is free for all teachers at all levels.
Minimum input knowledge
Expected entry knowledge - working with Microsoft Excel at a slightly advanced level.
Output knowledge
Mastering the use of Excel as a comprehensive tool. The course will help you automate routine tasks.
Training syllabus
Relative and Absolute References
- What is hidden under this term Difference between mixed references and array formulas
Logical Functions
- COUNTIF SUMIF IF, OR, AND IFERROR
Formula Debugging
- Watch Window Trace Precedents - Trace Dependents
Information Functions
- ISTEXT, ISBLANK, ISNUMBER, ISERROR
Price incl. VAT
0.00 €
Current VAT 23%
Duration
Day: 1 day · Evening: 2 days · Weekend: 1 day
Course overview
The webinar is intended for teachers of all schools and is organized in cooperation with Microsoft. Its role is to help educate and prepare teachers. It is free for all teachers at all levels.
Minimum input knowledge
Expected entry knowledge - working with Microsoft Excel at a slightly advanced level.
Output knowledge
Mastering the use of Excel as a comprehensive tool. The course will help you automate routine tasks.
Training syllabus
Lookup Functions
- Practical use of lookup functions (VLOOKUP, MATCH, INDEX)
Text Functions
- Use of basic text functions in practice CONCAT, FIND, LEFT, RIGHT
Working with AutoFilter
- Working with PivotTables Data Validation Table tool