Microsoft Excel VBA For Advanced Training Melaka Puchong Selangor Malaysia

 

Why and for whom?

This is for advanced users who:

  • have attended our Ms Excel VBA For Beginners or have strong basic knowledge about Excel VBA
  • wish to automate repetitive and routine tasks by writing your own functions and procedures
  • want to write more complex codes to reduce amount of effort in completing tasks at work

After completing this course, you will be able to:
  • write reusable code for repetitive tasks
  • use VBA editor to create custom forms and controls, to gather and validate information from users
  • use VBA to communicate with other Office applications, such as PowerPoint, Word, Outlook
  • use VBA to manipulate charts, PivotTable and PivotChart, and export data ranges into a PDF format file
  • use VBA debugging tools to debug VBA codes
  • understand the concepts of conditional statements and loops, and learn to integrate them into your codes
  • explore the advanced options of subroutines and function procedures to create more flexible programs

 

Microsoft Excel VBA Training Melaka Puchong Selangor

DATE

To be Advised

Microsoft Excel VBA Training Melaka Puchong Selangor

TIME

9am-5pm

Microsoft Excel VBA Training Melaka Puchong Selangor

DURATION

2 Days /14 Hours

Ms Project Versions

VERSIONS

2016

Microsoft Excel VBA Training Melaka Puchong Selangor

VENUE

Venue 1:

SetiaWalk Puchong, Selangor, Malaysia

Venue 2:

Plaza Mahkota, Melaka, Malaysia

Venue 3:

Anywhere (Virtual Training)