Courses

Microsoft Excel 2010 VBA Programming

Location: 
10 Anson Road, #06-14/19/20 International Plaza, Singapore 079903
Contact Us Email: 
Training Provider: 
COMAT Training Services Pte Ltd

OVERVIEW

This course introduces the student in automating and customizing the different processes in Excel through VBA coding. It uses the various Excel Objects Models to manipulate and control the applications, worksheets and ranges. Furthermore, the students will be exposed to the different programming constructs and techniques in handling data from the worksheet.

The trainee will also learn how to use Events in Excel, VBA Arrays, and creating useful data forms.

 

COURSE OUTLINE

·         Module 1. Introduction To Macros

·         Module 2. VBA Environment

·         Module 3. Working With Objects

·         Module 4. Variables And Data Types

·         Module 5. Operators and Decision Making

·         Module 6. Loops

·         Module 7. Subroutines and Functions

·         Module 8. Arrays

·         Module 9. Custom Forms Dialogs and Events

·         Module 10. Debugging and Error Handling

 

PRE-REQUISITE

Complete the Microsoft Excel Advanced Course.