Excel VBA
Excel VBA stands for Visual Basic for Applications. It is a programming language which is used to develop programs within Excel. It can turn complex or time-consuming tasks into automated processes, saving time and improving the quality of reporting.
Introduction to VBA
- Working with VBE (Visual Basic Editor)
- Introduction to Excel Object Model
- Understanding of Sub and Function Procedures
- Key Component of Programming Language
- Understanding of If, Select Case, With End With Statements
- Looping with VBA
- User Defined Function
- Some Commonly Used Macro Examples
- Error Handling
- Object and Memory Management in VBA
- User Form Controls
- ActiveX Controls
- Communicating with Database MS Access through ADO - Exporting/Importing Data
Institution Certification certified by DOIS Education & Technologies Private Limited
Duration of Course: 8Hrs
Course Price : 13,200 INR + GST OR 229 USD