Course
Excel – Macros & Fonctions («EMK»)
This course teaches you how to register macros and the basics of Visual Basic for Applications (VBA) language, and to start them with buttons for example. Creating templates will allow the sharing of macros with other users.
Duration
1 day
Price
650.–
Course facts
- Saving command sequences as macros
- Understanding VBA code
- Completing and optimizing existing VBA code
- Creating custom functions in function's assistants
- Start the macro recorder
- Set the macro's name and key combination
- Macro recording areas
- Start, execute and exit the recording
- Types of macros and appropriate startup possibilities
- Start macros with buttons
- Start macros with symbols
- Insert macros
- Start recorded macros
- Delete old macros
- Basic elements of the VBA code
- Essential elements and structures of the program
- Customizing lines of code
- Replace hard-coded values with dynamic references
- Delete superfluous lines
- Add new program lines
- Simple dialogs with MsgBox() and Inputbox()
- Simple conditions in the course of the program (If ... End lf)
- Loops (Do ... Loop)
- Custom templates
- Models for a working group
- Automatic macros
- Principles of custom functions
- Create custom functions
- Registration area for custom functions
- Custom functions in function's assistants
This course is aimed at users who want to record macros, understand what VBA is and create custom functions in Excel in a professional way.
Extensive practical experience on Excel is essential. To have knowledge according to the courses:
This course also covers custom functions of Excel to allow you to integrate them in the function's assistants at the end of the course.