- Duration: 3 Days
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
Course Location
About ITBM
Instructional & Courseware Design
- Customized CD Learning, e-Learning and Courseware for companies. Find out more now.
Office Workflow Automation
- When running your day-to-day business, you realise that things can be made easier for you if the system is computerised. But how do you get started? More information here.
- JavaScript Full stack web developer virtual internship Virtual Bootcamp + Internship at LaimoonAED 1,449Duration: Upto 30 Hours
- Microsoft Excel 2016 Intermediate Adams AcademySGD 42
SGD 446Duration: Upto 13 Hours - Microsoft Excel 2016 Beginners Level (Updated) Alpha AcademySGD 34
SGD 378Duration: Upto 18 Hours