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

Excel 2016/2019/365 - 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 in stages, share macros between workbooks, set up keyboard shortcuts to run macros quickly, and use Visual Basic for Applications (VBA) to code macros that can't be recorded. The course wraps up with a macro project that brings together each of the elements in a real-world scenario: converting mailing list data into a database-friendly format.

  • 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 3-day course, you will learn how to use Visual Basic to control Excel and to automate processes to speed up and simplify their work with Excel data. You will also learn how to create interactive procedures using message boxes and custom dialog boxes using Visual Basic controls...

Outlook 2016/2019/365 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/365 - 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.