LINUX TRAINING IN CHENNAI

Training in Chennai offers best Macros Training in Chennai with most experienced professionals. We aware of industry needs and we are offering Macros Training in Chennai in more practical way. Our team of Macros trainers offers Macros in Classroom training, Macros Online Training and Macros Corporate Training services. We framed our syllabus to match with the real world requirements for both beginner level to advanced level. Our training will be handled in either weekday or weekend’s program depends on participant’s requirement.

We are the best Training Institute offers certification oriented Macros Training in Chennai. Our Macros Training Course Fees is very moderate compared to others.

CREATING RECORD MACROS

• Recording a Macro
• Running a Macro
• Running a Macro from the Macros Dialog Box
• Creating a Short-cut key to run a macro
• Running a Macro with a Shortcut key
• Assigning a Macro to a Menu or Toolbar
• Editing a Macro with Visual Basic

VISUAL BASIC EDITOR

• Objects
• Methods
• Properties
• Programming Tools
• The Menu Bar

THE PROJECT EXPLORER

• Using the Project Explorer

USING CONSTANTS

• Excel Constants
• Variable Constants

EXCEL OBJECTS

• Objects, Properties and Methods
• Getting & Setting Properties
• Calling Methods
• Passing Arguments
• Singular Objects & Collections of Objects

USING VISUAL BASIC FUNCTIONS

• InputBox Function
• MsgBox Function
• Using a Set Statement

BUILDING FORMULAR CONTROL STRUCTURES

• If Then Decision Structures
• Logical Operators
• Select Case Decision Structures
• Case Else
• Comparison Operators with Select Case Structure
• For Loops
• Do Loops
• While...Wend Statement

RUNNING CODE

• Run mode and Design mode
• Running Code from the development environment
• Running Code from the host application

THE PROPERTIES WINDOW

• Changing a Property

VARIABLES

• Dimensioning a variable
• Using variables in routines
• Object Variables

USERFORMS

• Designing & Creating Forms
• Working with Controls
• Creating Custom Dialog Boxes
• Userform Properties Methods & Events

ADVANCED VBA PROGRAMMING TECHNIQUES

• Developing Excel Utilities with VBA
• Error Handling
• Using In-Built Excel Features in VBA
• Working with Pivot Tables
• Working with Charts
• Understanding Excel's Events
• Interacting with Other Applications
• Creating and Using Add-Ins

DEVELOPING APPLICATIONS

• Working with the Ribbon
• Working with Shortcut Menus
• Providing Help for Your Applications
• Developing User Oriented Applications

EVENT HANDLING

• VBA Editing & Debugging
• Auto Macros
• Error Handling

CONNECTING TO DATABASE

• Connect to MS Access
• Access Database & Retrieve Data from MS Access
• Create Table & Query Data Filter DB using Query
• Update and Modify DB
• Create Single and Multiple Mapping Tables
• Filter DB using Query
• Query data grouping
• Retrieve Data using Logical Access Query

CONNECT EXCEL TO OUTLOOK

• Connect to Outlook using VBA
• Query to retrieve Mail From, to and CC address
• Retrieve Mail Subject and Time
• Retrieve Mail Attachment

Course Duration:  2  to  3 Month, 2 hpd

Contact:  +91  7092284244

Mail:  info@velgrotechnologies.com