Certified Excel VBA (Visual Basic for Applications) Analyst

Certified Excel VBA program for professionals is a popular and powerful program for professionals, business managers, business analysts, business analytics professionals. Excel VBA is an unique Business Analytics tool patform. It combines the power of programming with power of Excel. It is a must learn skill for business managers.  Our training follows hands on practical approach. This program is very popular with IT and BFSI - Banking, Finance, Securities and Insurance vertical professionals.

---

Email  me  detailed syllabus and information

Methodology

Certified Excel VBA Analyst Program is a 1 month, 16 Hour Program. It is  dlivered through a live online class on Sundays between 2 PM to 6 PM, IST (GMT+5:30). The practical classes are followed by assignments, case study and project work by the participants during te week .

Fee

Fee for the Excel VBA Program is Rs 12000 only. Fee is inclusive of the training and certification. You will also receive project and study material.

Program Coverage

Program syllabus has been crafted in such a manner that it takes you to an advanced level of VBA skills. You will be able to prepare and publish your own Excel VBA - Excel Visual Basic for Applications programs and software post completion of this training.

Join Now

You can join the program now. Click Here

---

Trainers Profile - Anurag Jain

​

Anurag Jain - BE IIT Rooree 1994,  Sr Consultant and Trainer will be faculty for the Excel - VBA program.He brings along a rich and versatile experience in the area of Product Development, Analytics, and Business Consulting. He is a domain expert in areas from Automotive design to end to end IOT products and solutions. He has worked with Daewoo Motors India Ltd and Diac Spaa Technologies Pvt Ltd, and is a Product development / management evangelist.  

VBA - Excel Program Syllabus

Module 1 : Overview

1. The Current Eco System
2. About VBA Excel Course Delivery Methodology
3. Why's and What's
4. Use Cases

​
Module 2 :  Excel

1. Running Around Excel
2. Excel Object Model
3. Charting
4. Other Tricks
5. Macros
6. Cryptography

Module 3 : Visual Basic for applications, Understanding the code body

1. Starting to Code
2. Excel Object Model
3. ​Excel Extended Objects
4. Create your own application

Module 4 : Advanced Excel

1. Excel to Jason and Back
2. Scripting
3. Google, HTML, VBA and Excel
4. Cryptography
5. Second Program

Module 5 : VBA

1. Word : VBA and macro an introduction
2. Programming Basics
3. Functions. SUB, Public Private
4. Excel Calculation Algorithm
5. Constants, Variables, Declaration
6. Hands on Program

Module 6 : Dashboards, Decision Models and Infographics

1. Hands on dashboard preparation
2. Decision Model Preparation
3. Trending
4. Cost Reduction Boards

Module 7 : Data

1. Why's and What's of data
2. Types of data sources
3. Getting data
4. Fast Analytics
5. IOT Data
6. Hands on Exercise

Module 8 :  Create Excel Add'ins for your own to commercialize

Module 9 : Case Studies & Real life Scenarios

1. Investment Banking
2. Health Care
3. Retail
4. Operations and SCM

Build beautiful dashboards like these shown below
by leveraging the power and features of Excel VBA

Join Now