| Courses Basic Computer Training / Software Training / Application Programming | Locality Malleswaram |
Advance Program in VBA IN EXCEL
Excel VBA Macros (Excel 2007)
Duration: 20 hours (including Theory & practical)
Course Outline:
Introduction to VBA Macros
· Displaying the Developer Tab
· About Macro Security
· Saving Workbook that contain Macros
· Types of VBA Macros
· Creating VBA Macros
· Writing VBA Code
· variables
· Controlling Execution
· If conditions & Loops
· Over view of VBA Functions
· Using Functions in a Worksheet
· ABOUT Function Procedures
· Executing Functions Procedures
· Working with Ranges
· Selecting a Row or Columns
· Moving a Range
· Looping through a Range efficiently
· Working with Workbooks
· VBA Speed Tips
· Creating User Forms
· Testing the User Form
· Creating an Event Handler Example
· Working with Excel events
Highlights:-
1. Training with the most experienced trainer working in Top MNC's
2. Course content is designed to match with most of the MNC Companies requirements
3. Flexible batch timings (for week days /weekend).
4. Low Cost and Quality Training
For more details please call: 9739066172/080-32487434
Write us: [email protected]
Reach us at:
IGS LABS TECHNOLOGIES PVT LTD
# 19, M N Complex, 2nd Floor,
2nd Cross, Sampige Road,
Malleswaram, Bangalore - 560003
Landmark: Near to SBM Bank.
www.igslabs.com
www.makefinalyearproject.com
www.ja
vaguru.co.in