Praha (9 900 Kč)
Brno (9 900 Kč)
Bratislava (420 €)
Complete this course and get 90 days access to practice in e-learning version for free. You can choose the e-learning course in Czech, Slovak or English. This course is assigned for skilled Microsoft Excel users, who want to use special tools, techniques, methods and functions. You should already know Microsoft Excel on “Microsoft Excel - practical use” level.
This course is suitable for users of every version of Microsoft Office products. Excel is a well-matured application and control of its interface has not changed significantly since the 2007 version. There will be current Excel version installed in the classroom.
Microsoft Excel - practical use
Conditions in formulas
Database functions
Lookup functions, joins of datasets
Retrieving data from external databases
Datamodel
PivotTable reports
Scenarios
Special mathematical methods
Advanced operations with worksheets/workbooks
Worksheet/Worbook protection
Macros
The prices are without VAT.