Course description
In this course we will show you what a macro is, where you could use it and what are the basic principles of macros in excel.
You will learn the basic syntax of properties and methods and understand how to substitute values and the ubiquitous use of the With and End With statements.
You will learn how to make part of the statements repeated, create various conditions in the code that cannot be loaded, and learn about popular syntaxes.
Target audience
For everyone who wants to broaden their horizons and make their work easier thanks to excel and macros.
Course content
Where to find macros
- Developer tab
- Excel in developer mode
How to upload a macro
- rules for names and keyboard shortcuts
- Personal.xlsb
How to run a macro
- buttons on the Quick Access panel
- custom buttons in a worksheet
- macro options
Visual Basic for Application (VBA)
- introduction to the environment
- projects, properties, modules
Object model
Macro debugging
- break mode
- stepping macro
Program branching and cycles
- If… then… else
- For i… next i
- Do until / while… loop
Error handling
Materials
The course includes trainings materials and excersices.
