| Excel with VBA |
| ( Two and Half day Workshop ) |
| About the Course : |
| This Two and Half day hands-on course discusses the nitty-gritty of VBA and enables programmers to develop applications using VBA. The features and function of VBA and Excel, including the Data Access with ADO, Macro are covered thoroughly.
Numerous programming examples and exercises are provided to supplement and understand the concepts.
|
| Workshop objectives : |
• Gain a thorough understanding of the VBA and Macro features
• Acquire a working knowledge of the VBA and Macro with their effective practical usage
|
| Workshop Contents : |
Day-1
• Range Names
• Conditional Functions & Formats and Date Calculations
• Lookup & Information Functions
• Charts
• Pivot Tables
Day 2
• Introduction to Macros
• Difference between VBA & Macros
• Control Visual Basic
• Extend Excel and Visual Basic
• Macros with Events
• User Forms
• Data Access with ADO
Day 3
• Data Access with ADO
There would be exercises and case studies at appropriate junction points to elaborate and understand the concepts |