Excel VBA Macro Training in Chennai

Course on Excel Automation. Taught by Microsoft Certified Trainers.

  • (1976)

It is a 36 hours (12 Sundays) classroom training program in Chennai, covering from Basics of VB programming to the most Advanced VBA features, enabling attendees to create the most sophisticated Excel Automated Business Applications post training through a LIVE VBA Project.

  1. Mode of Training: Classroom, Instructor - Led
  2. Course Pre-requisite: Proficient knowledge on Excel Formulas
  3. Upcoming Batch: 11th Sep 2016     View Schedule

Our 5 Steps Learning Process

VBA Learning Redefined.

LEARN from Microsoft Certified Trainers

EXPLORE 90+ Small Scale VB Scenarios

PRACTICE with 7 VBA Case Studies

HANDS-ON experience with a Live VBA Project

ON-JOB Support to implement learnings

What's included in your training?

  1. 90+ Small scale Scenarios
  2. 7 Major VBA Case Studies
  3. Live VBA Project (Post-Training)
  4. VBA Automation Specialist Certification
  5. 30 Days Post-Training Support (On-Job)

What you will be able to do post training?

  1. Automate any live scenarios in Excel using VBA with ease
  2. Have high comfort on Programming
  3. Increased maturity in handling Excel related automations
  4. Develop scalable Excel Applications with ease, avoiding re-work
  5. Connecting to third party applications (Access, Outlook, IE etc)

Course Content - Overview

Creating Record Macros
  1. Recording a Macro
  2. Running a Macro
  3. Running a Macro from the Macros Dialog Box
  4. Creating a Short-cut key to run a macro
  5. Running a Macro with a Shortcut key
  6. Assigning a Macro to a Menu or Toolbar
  7. Editing a Macro with Visual Basic
Visual Basic Editor
  1. Objects
  2. Methods
  3. Properties
  4. Programming Tools
  5. The Menu Bar
The Project Explorer
  1. Using the Project Explorer
Using Constants
  1. Excel Constants
  2. Variable Constants
Excel Objects
  1. Objects, Properties and Methods
  2. Getting & Setting Properties
  3. Calling Methods
  4. Passing Arguments
  5. Singular Objects & Collections of Objects
Using Visual Basic Functions
  1. InputBox Function
  2. MsgBox Function
  3. Using a Set Statement
Building Formular Control Structures
  1. If Then Janision Structures
  2. Logical Operators
  3. Select Case Janision Structures
  4. Case Else
  5. Comparison Operators with Select Case Structure
  6. For Loops
  7. Do Loops
  8. While...Wend Statement
Running Code
  1. Run mode and Design mode
  2. Running Code from the development environment
  3. Running Code from the host application
The Properties Window
  1. Changing a Property
Variables
  1. Dimensioning a variable
  2. Using variables in routines
  3. Object Variables
UserForms
  1. Designing & Creating Forms
  2. Working with Controls
  3. Creating Custom Dialog Boxes
  4. Userform Properties Methods & Events
Advanced VBA Programming Techniques
  1. Developing Excel Utilities with VBA
  2. Error Handling
  3. Using In-Built Excel Features in VBA
  4. Working with Pivot Tables
  5. Working with Charts
  6. Understanding Excel's Events
  7. Interacting with Other Applications
  8. Creating and Using Add-Ins
Developing Applications
  1. Working with the Ribbon
  2. Working with Shortcut Menus
  3. Providing Help for Your Applications
  4. Developing User Oriented Applications
Event Handling
  1. VBA Editing & Debugging
  2. Auto Macros
  3. Error Handling
Connecting to Database
  1. Connect to MS Access
  2. Access Database & Retrieve Data from MS Access
  3. Create Table & Query Data Filter DB using Query
  4. Update and Modify DB
  5. Create Single and Multiple Mapping Tables
  6. Filter DB using Query
  7. Query data grouping
  8. Retrieve Data using Logical Access Query
Connect Excel to Outlook
  1. Connect to Outlook using VBA
  2. Query to retrieve Mail From, to and CC address
  3. Retrieve Mail Subject and Time
  4. Retrieve Mail Attachment

About the Trainer

Mr. Sami (MCT, MOS, MEE)

Mr. Sami, Microsoft Certified Trainer, with his qualifications in Finance and IT brings in 14 years of Industry experience. He has successfully trained 3000+ professionals by now, and the counting is still on.

He has undertaken the renowned VBA assignments with IRS, The World Bank, Tata Chemicals, Buckman Laboratories, Standard Chartered, ING Barings and much more. His nature of going that Extra Mile has got him the startling popularity amongst the Excelgoodies prominent clients.

Testimonials

Sami, I am very happy to share my feedback about your training to me. You have been an extraordinary trainer for me for the following reasons:
  1. The Sure -ity (The conviction in which you teach is Awesome)
  2. The thorough-ness in your knowledge about the steps to be followed and the examples that you pick up is spell bounding..   Read More

Training Schedule

Session Date Time
Session 1 11-Sep 3.00 PM - 6.00 PM
Session 2 18-Sep 3.00 PM - 6.00 PM
Session 3 25-Sep 3.00 PM - 6.00 PM
Session 4 02-Oct 3.00 PM - 6.00 PM
Session 5 09-Oct 3.00 PM - 6.00 PM
Session 6 16-Oct 3.00 PM - 6.00 PM
Session 7 23-Oct 3.00 PM - 6.00 PM
Session 8 30-Oct 3.00 PM - 6.00 PM
Session 9 06-Nov 3.00 PM - 6.00 PM
Session 10 13-Nov 3.00 PM - 6.00 PM
Session 11 20-Nov 3.00 PM - 6.00 PM
Session 12 27-Nov 3.00 PM - 6.00 PM

Live VBA Project

We believe firmly in result-oriented Automation training. Hence, the learning at Excelgoodies doesn't stop just with the Classroom sessions. Post the Training; you will be offered an opportunity to take up a live VBA project from your company and implement all the concepts learned in real-time.

You will also be honored with the "Report Automation Specialist" Certificate on saving at least 2 hours of work per day.

Certifications

Contact Us

ExcelGoodies Software Private Limited.

56, 1st Floor, North Boag Road,​​​​​​​

T. Nagar, Chennai - 600 017

Tel: +91 9176633248

inquiry_chennai@excelgoodies.com

Connect us on

Learner stories around the world!

Reviews

  • Trainer's Expertise
  • Course Structure
  • Course Content
  • Quality of Assignments
  • Certification Process

Karthikeyan

Senior Project Manager

Indeed, it is my immense pleasure to share my learning experience with Excelgoodies. Before joining this course, I was totally bewildered and frightened to use Excel applications.

I had attended many training sessions, but I feel Sami is the best trainer I have ever seen. After attending all the sessions....

Rajasivasubramanian

Heidelberg India Pvt Ltd

I appreciate the comfort and ease with which Sami trained us on Excel features & its applications. It was indeed a great training.

Thank you to my friend Rajasekharan who shared his training experience with me and my team which inspired us to opt for the course...

R.Rathish

Business Analyst

This is a great training workshop, and it substantially enriched my knowledge. I am implementing the same in our company.

The course really added to my knowledge.I was specially happy with the instructor...

Gayathri Pillai

Data Support Analyst

My experience with excel goodies was really good. Being a MIS executive only with the help of the advanced excel course i am completing my targets on time. Mr.Sami used to tell me to apply whatever has been taught at work and only then it will be worth...

Krishna Kumari

Senior Manager

The course was well paced dealing with the practical use of Excel. Concepts were made pretty simple to understand as well as to remember. Thanx to Sami & Team Excelgoodies...