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.
Are you from ITBM ? Claim your course!
Courses you can instantly connect with... Do an online course on Microsoft Excel starting now.
- JavaScript Full stack web developer virtual internship Virtual Bootcamp + Internship at LaimoonAED 1,449Duration: Upto 30 Hours
- Microsoft Excel Keyboard Shortcuts for Beginner Course LineSGD 32
SGD 655Duration: Upto 1 Hour - Microsoft Excel 2010: Advanced Study 365SGD 34
SGD 246Duration: Upto 6 Hours
