Description
Want to learn how to use macros to save time? Don't have the courage to edit macros in Visual Basic for Application code? Would you need any part of the commands to be repeated? Then this course is for you.
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.
Goals
- Naučit se vytvářet makra.
- Znát pravidla pro názvy a klávesové zkratky, Personal.xlsb
- Spuštění a možnosti maker.
- Edit macros in VBA code
- Be able to set some commands to repeat
Target
For everyone who wants to broaden their horizons and make their work easier thanks to excel and macros.Contents
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
Program branching and cycles
- If… then… else
- For i… next i
- Do until / while… loop
Error handling
Prerequisites
Excel user knowledge.Study Materials
The course includes trainings materials and excersices.