Microsoft Excel macros
|Target group:||Excel users|
|Target:||Easy automation of recurring tasks in Excel.|
|Prior knowledge:||Good basic knowledge of Excel|
|Content:||Dealing with macros|
Adjustments in the VBA code
Make macros available as AddIn
With macros you can automate your work with Excel. With the help of the so-called macro recorder, you can record work processes and command sequences and then have them repeated automatically. You can use macros, for example, to evaluate data at regular intervals according to a uniform scheme with identical formulas and uniform formatting properties.
Complex solutions cannot be realized with macros; for this purpose the recorded command code would have to be edited and supplemented. This is done with the programming language Visual Basic for Applications (VBA). We are happy to offer you this training additionally.