Excel VBA Class

Instructor-led Excel VBA training

Kent Lau will coach you to automate your tasks with Microsoft Excel Macro / VBA in a step-by-step approach.

Class size: 4 pax

Excel VBA Training

You’ll learn:

  • Developing with Procedures and Functions
  • Introducing Objects
  • Using Excel VBA Functions
  • Variables and Expressions
  • Managing Program Execution
  • Using the PivotTable Object
  • Debugging The Code
  • Handling Errors

Upon completion of this course, participants will have a good understanding of Object Orientated Programming (OOP) , get a new ability to automate task, able to interact with other office applications such as Outlook or PowerPoint.

In addition, the course also covers importing data from database applications such as Access, and manipulating and presenting the data in Excel.

Please contact us by whtatsapp to 016-3048 909. Thank you.

See sample of work:

Excel VBA Tip -Insert Columns and Retype Excel Formula Automatically

Excel Great Idea – Export Excel Chart to PowerPoint Fast

Excel VBA Demo – Convert Excel Data Into Text File Fast

[VBA Level 2] Save data to new workbook

Corporate training on Microsoft Excel VBA

Microsoft Excel Macro/VBA Class @ Kuala Lumpur

 

2 DAYS EXCEL ADVANCED LEVEL CLASS

Excel VBA Basic To Intermediate Course Outline - 0317
Excel VBA Basic To Intermediate Course Outline - 0317
Excel-VBA-Basic-to-Intermediate-Course-Outline-0317.pdf
651.8 KiB
47 Downloads
Details...
Advance Excel
Advance Excel
Advance-Excel.pdf
825.3 KiB
7 Downloads
Details...