Microsoft Excel 2016 Macro & VBA

Course Objectives:

This course covers automation and customising of Excel using macros and screen items (such as buttons and menus). Delegates learn how to write macros using VB code and assign macros to screen items.

Who Should Attend?

Excel users who, at intermediate or advanced level, want to learn how to speed up and automate their work (or other users’ work) in the application using macros

Pre-requisite

Delegates should have a good grounding in Excel (any version) and be familiar with absolute Vs relative cell referencing, functions and formula syntax and sheet linking. Familiarity with the macro recorder would be an advantage. However, those wishing to learn or practice VBA itself should seek another course.

  • Introduction
  • Demonstration
  • Recording A Macro
  • Recording A Macro With Absolute References
  • The Personal Macro Workbook
  • Assigning Shortcut Keys
  • Deleting Macros
  • Recording A Macro With Relative References

Individual Registration

No sponsorship

Course Detail

Calendar 2025

9-10 Jan

13-14 Feb

10-11 Mar

3-4 Apr

13-14 May

12-13 Jun

10-11 Jul

13-14 Aug

17-18 Sep

13-14 Oct

17-18 Nov

15-16 Dec

Have Any Question?

If you need further information about this course, please contact:

Registration Course under HRDC

PERKESO EIS Programme Registration

Registration Course