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

Excel 2016 - 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 in 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.

Programming in VBA Access

This intensive 3-day course is designed to introduce new Access programmers to the Visual Basic for Applications programming language and help them create robust and powerful database applications by taking a structured look at Access VBA. It will help new database developers to plan and automate their applications.

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