Hulp nodig ? Bel ons:+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.

De volgende opleidingen zouden u ook kunnen interesseren:

Programming with VBA Excel

In deze pratijkgerichte opleiding leert u de basis van het programmeren en VBA van bij het begin. U ontwikkelt de vaardigheden die nodig zijn om repetitieve taken te automatiseren, u ontwerpt interfaces voor de gebruikers en u verhoogt het prestatievermogen om de productiviteit van de gebruikers te verbeteren.

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.