Course details
This 1 day instructor led course will empower participants the knowledge and skills on how to automate and customize the different processes in Excel through VBA coding. It will introduce to the participants the various Excel Objects Models to manipulate and control the applications, worksheets and ranges. Furthermore, the participants will be exposed to the different programming constructs and techniques in handling data from the worksheet. The participants 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. Custom Forms Dialogs and Events
- Module 9. Debugging and Error Handling
TARGET AUDIENCE
- HR professionals, HR Executives, HR Managers and Directors.
PRE-REQUISITE
- Complete the Microsoft Excel Advanced Course.
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 Human Resources starting now.
- JavaScript Full stack web developer virtual internship Virtual Bootcamp + Internship at LaimoonAED 1,449Duration: Upto 30 Hours
- Advanced Excel for Real World Course LineSGD 33Duration: Upto 4 Hours
- Complete Excel Tutorial: Beginner To Expert Course GateSGD 17
SGD 353Duration: Upto 12 Hours
