Excel – Macros & Fonctions («EMK»)

• 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.