Dhitos Consultants is a training and development organisation where we conduct various Job Oriented Practical Training Programs for MIS / Business Analysis / Data Analyst / Business Analytics / Data Scientist / Data Visualisation / Data Validation and more by Industry Experts.
VBA Programming, Developing Macros & Automations. Vba language is a programming language based on the visual basic focused on the accomplishment of programs of the tools Excel, Access, Words by means of macros vba we can create new functions to our Excel sheets, you can personalised styles and formats, to create programs to resolve complex calculations, automate tasks.
Macros are a group of programmed instructions under environment vba ( visual basic applications ) whose main task is the automate tasks and the resolution of complex calculations.
VBA (Macros): Topics Covered [Download PDF]
- Introduction to VBA & Macros
- Cells & Sheets Navigation Methods
- Dialog Boxes in VBA
- Data Types, Variables, Constants & Arrays
- References & Utilities
- Formatting & Dynamic Editing
- Loops in VBA
- Logical Functions & Operators
- Workbook, Worksheet & Events
- UDFs & Inbuilt Functions
- Type of Errors in VBA & Its Handling
- User Form & Controls
- Automated Mail & Web Access Methods
- Database Connection & Automation
- Logical Thinking, Flowcharts & Algorithms
- VBA Dashboard & Business Wizards
- Live Projects & Interview Questions
VBA (Macros): Fee Structure & Course Duration
|Days||Course Duration||Class Duration||Fee (INR)*||Course Details|
|Monday to Friday||30 to 35 (Hrs.) / 3 Weeks||2 Hours / Day||8,000/-||Download[pdf]|
|Saturday and Sunday||30 to 35 (Hrs.) / 1.5 Months||3 Hours / Day||8,000/-||Download[pdf]|
|Sunday Only||30 to 35 (Hrs.) / 2 Months||4 Hours / Day||8,000/-||Download[pdf]|
Go for combo and get 10% discount on total. (* Service Tax applicable )
This course will make you able to create Automated Reporting Trackers for your day to day business needs. This way your day to day repeated and uphill jobs can be submitted efficiently and accurately. Anyone with good Excel skills can go for it and is always in demand. VBA is also used to create Data Models, Financial Modelling etc. in Analytics.