Want to save time on routine tasks in Microsoft Excel? Macros are your answer. In this course, the trainer explains how macros can be used to automate tasks in Excel, and how you can create simple macros by yourself. Learn when and how to record a macro and how to use it.
Using examples of useful macros, the trainer will show everything that can be done with macros without using VBA programming, and the applicable limits.
- Content:
Understand what macros can do for you
Differences between general (Personal Macro Workbook) and
local (Workbook) macros
Show Develop tab
Macro recording
Test your macros
Assign macros
Macros and file formats
Use of absolute and relative references
Access the VBA code
Delete macros
Examples of useful macros
Good to know
- Training in French: 15.07, 19.08,16.09, 21.1015.11
- English training: 08.07, 12.08, 09.09, 14.10, 18.11
- Price: 350 EUR
- Target audience: People who wish to save time on
routine tasks in Microsoft Excel.
- Prerequisite: Good knowledge of MS Excel (equivalent
to the content of the Level 2 course).
Automatically translated from French
Organizer
Christophe Deneufchatel
Where does it take place?
Lifelong Learning
89c Rue Pafebruch
Mamer
Luxembourg
You could like it :
find out about all the networking events and trainings tailored for you!
find out about all the networking events and trainings tailored for you!