Ms Excel VBA

MS Excel VBA Course brings the participants to write simple Visual Basic code.

Download Brochure

DURATION:
-

Address

Universiti Kuala Lumpur Malaysian Institute of Information Technology, Kuala Lumpur, Malaysia   View map

Categories

ACE , Short Courses
Course Overview MS Excel VBA Course brings the participants to write simple Visual Basic code. This course covers understanding Object Model, Visual Basic routines, reuse and adapt existing code. Application of Visual Basic for Applications (VBA) programming language to simplify many of the tasks using tools and functions in MS Excel.
Course Objective After completing this course, participants will be able to:

•             Create, edit, and debug a macro.

•             Format worksheets using macros.

•             Create an interactive worksheet.

•             Work with multiple worksheets.

•             Perform calculations.

Course Outline  

COURSE CONTENT/OUTLINE
Topic 1:
              INTRODUCTION TO VBA
Topic 2:
VBA AND EXCEL
Topic 3:
PROGRAMMING CONCEPT
Topic 4:
USER INTERACTION
Topic 5: EXCEL ADD-INS : PUTTING IT ALL TOGETHER
Duration