Course Excel VBA 1 - Macros and Introduction to VBA
The Excel VBA programming - macro creation training is intended for participants who have experience with Excel and want to learn to create and debug macros - to program in it.
Minimum input knowledge
Standard PC operation, experience with Microsoft Windows. Advanced level of Excel operation, especially work with formulas and functions.
Course dates Excel VBA 1 - Macros and Introduction to VBA
Daily courses (2 days): 09:00 - 15:00
Course price: 195.00 / 239.85 EUR
without VAT / incl. VAT
Training syllabus Excel VBA 1 - Macros and Introduction to VBA
Introduction, Description of the VB Development Environment
- Introduction to the topic, description of the VB development environment (project explorer, toolbox, window for viewing the graphical appearance of objects, code window, properties window), setting some IDE properties, docking windows, history, versions
Basics of Macros
- Explanation of the term macro, security, options for creating a macro, automated macro creation - advantages and disadvantages, macro editing, macro programming - getting familiar with Visual Basic for Applications (VBA), personal macro workbook
Data Types, Variables, Constants and Operators
- Variable declaration, basic data types, variable scope, data type conversion, constants, operators (+, -, / .... AND, OR...)
Flow Control and Branching
- Conditional and unconditional jumps, loops (For each, Do, While, With), program flow control - IF and SELECT commands
Arrays and Collections
- Working with arrays, static and dynamic arrays
MS Excel Environment
- Possibility of using standard Excel functions in programming, connecting VBA code to the Excel environment, access to cells, different reference options, offset, obtaining and changing a value, changing appearance
Procedures, Functions, Modules
- Creating and using, passing parameters by reference and by value (ByRef, ByVal), modules, code protection - locking it with a password
Basic Controls
- Characteristics, basic properties, discussion, conclusion
Output knowledge
Mastering the creation of simple programs and macros in Excel. Thanks to this knowledge, graduates of this course will be able to make their work more efficient.
Recommended courses after completing Excel VBA 1 - Macros and Introduction to VBA
Show all courses from category Excel courses
Contact us
If you need a custom date, group training, or help choosing the right course, contact Macrosoft directly. We will help you with the next step.
Need more details?
Open the contact page for a full enquiry flow, company billing details, and directions to the training centre.
Course Reviews Excel VBA 1 - Macros and Introduction to VBA
Average rating