Need some help ? Call us:+32 2 503 40 40
Back

Excel 2016/2019 - Macro

Want to save time on routine tasks in Microsoft Excel? Macros are the answer. In this course, the instructor will explain how macros can be used to automate tasks in Excel, and how you can create simple macros of your own. Learn when and how to record a macro, and how to use it. Through useful macro examples, the instructor will show how much you can do with macro recording without using any VBA programming, and the limits of macro recording.

  • Understanding what macros can do for you
  • Differences between general (personal macro workbook) and local (workbook) macros
  • Displaying the Developer tab
  • Recording macros
  • Testing macros
  • Assigning macros
  • Macros and file formats
  • Using relative references in macros
  • Accessing VBA code
  • Deleting macros
  • Examples of useful macros

People who want to save time on routine tasks in Microsoft Excel.

You might also be interested in:

Programming with VBA Excel

In this hands-on course, you learn the fundamentals of programming and VBA from the ground up. You gain the skills you need to automate repetitive tasks, build user interfaces and increase performance in order to improve user productivity.

Outlook 2016/2019 Productivity

The course teaches participants how to stop "living in their inbox" and start prioritizing tasks, messages, and appointments to achieve what's most important to the organization and themselves.

Word 2016/2019 - Level 1

Microsoft Word is a very powerful word processing application designed to save you time and make creating letters, CVs, reports and other documents easy. This is an introductory Microsoft Word training course that will provide you with a working understanding of the basic features of MS Word. Like being able to create and format documents.