About Us Contact Us

Excel VBA (Macro) Training in Chennai

ABOUT TRAINING
It is a 12 Days class room 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.
Course Excel VBA (Macro) Course Duration 36 hours
Course Pre-requisite Advanced Excel Formulas Number of Sessions 12
Mode of Training Classroom, Instructor Led Duration Per Session 3 Hours

What's Included in VBA Training

  • Pre-Course Assessment
  • Hands-On Instructor Led Training
  • Live Project Post Training (Automate your own process at Job)
  • 30+ Small Scale Assignments
  • 5 Large Scale Automations
  • 30 Days Post Training Support

Post Training, you will be able to

  • Automate any live scenarios in Excel using VBA with ease
  • Have high comfort on Programming
  • Increased maturity in handling Excel related scenarios
  • Develop effective and scalable Excel Applications with ease avoiding re-work
  • Connect to any third-party applications using Excel
Course Certificate : Excel VBA Specialist (View Certificate)

VBA Course content

  • vba / macro
COURSE DURATION : 25 hours 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
Course Timings
Session No Session Date Session Time
Session 1
10-Jul
3.00 PM - 6.00 PM
Session 2 17-Jul 3.00 PM - 6.00 PM
Session 3 24-Jul 3.00 PM - 6.00 PM
Session 4 31-Jul 3.00 PM - 6.00 PM
Session 5 07-Aug 3.00 PM - 6.00 PM
Session 6 14-Aug 3.00 PM - 6.00 PM
Session 7 21-Aug 3.00 PM - 6.00 PM
Session 8 28-Aug 3.00 PM - 6.00 PM
Session 9 04-Sep 3.00 PM - 6.00 PM
Session 10 11-Sep 3.00 PM - 6.00 PM
Session 11 18-Sep 3.00 PM - 6.00 PM
Session 12
25-Sep
3.00 PM - 6.00 PM
Live VBA Project Learning beyond classrooms !

We believe strongly in result oriented VBA automation training. Hence, the learning at Excelgoodies doesn't stop just with the sessions. Post the Training, Students will be provided with an opportunity to take up a live project from their own organization and implement all the concepts learnt real-time, saving at least 2 hours of work per day resulting in a full-fledge result oriented automation training.

Course Fee Kindly contact us at +91 9176633246 or +91 9176633248 or 044 4354 6714 for the Course Fee
Venue Excelgoodies
56, 1st Floor, North Boag Road,
Chennai, Tamilnadu
600 017
MODE OF TRAINING : Classroom Instructor Led
BATCH SIZE: 20
Terms and Conditions
  1. The fees charged is for group batch and not for an individual training. Candidates are expected to attend every session. However, if the candidate miss any of the session, the same shall not be provided free of cost. The candidate will have to pay INR. 400 / missed session and such session would be conducted only on scheduled days which will be informed from time to time.

    Kindly Note: The above provision is allowed for maximum of 1 class

  2. As per the company's information security policy, candidates are not allowed to take any files used in the classroom. However, they are allowed to take up any notes in the class.
  3. Fees once paid will not be refunded for any reason.
  4. The amount mentioned in the invoice is due and payable even if the candidate quits the session.
  5. The candidates are expected to attend the session on time. Any delay from the candidates side will not be compensated by the company in form of extra sessions.
  6. The company takes utmost care to provide candidates with best infrastructure. Any loss or damage caused to such infrastructure by the candidate shall be compensated by the candidate.
  7. Shifting of batches shall not be accepted.