Praha (4 000 Kč)
Brno (4 000 Kč)
Bratislava (170 €)
This training is suitable for experienced users of Microsoft Excel, who want to learn about how to use a mechanism called macros as a tool that allows you to automate routine activities (formats, data transformation, preparation of reports, creation of formulas etc.). Appendix "for users" has emphasized the fact that the understanding of the training is no need to know any programming language. The training will explain the philosophy of macros, introduce a tool that can macros "record" and mainly will explain which commands are appropriate for use inside a macro, if you need to solve your problem in general way. Based on our experiences, we finally decided to abandon explanation of basics of Visual Basic (macro language), because the complexity of VBA requires a much larger space that this introductory training cannot offer. Training is independent of the version of MS Office.
For users who routinely Excel control during labor and realize that many of their activities are automatable. Furthermore, for users who are considering a deeper insight into programming for MS Excel, but want to first try simple automation tasks, because they have the respect of the weekly training while distrust of training promising detailed initiation to the problems of VBA in disproportionately short period of one or two days .
Good knowledge of MS Excel
Professional explanation with practical samples and examples.
Printed PowerPoint handouts
Automatization in MS Excel
Introduction to macro-recording tool
Examples explaining the possibilities of recorder
Required minimum from VBA world
How to start execution of recorded macro
Sharing of macros
Security problems
The prices are without VAT.