Microsoft Excel 2007 VBA Programming

Course details

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