Excel VBA

VBA Visual Basic for Applications is a combination of the Microsoft’s event-driven programming language Visual Basic with Microsoft Office Applications such as Microsoft Excel. VBA enables automate various activities in Excel, generating reports, preparing charts & graphs, calculations, and much more. This course will provide enough understanding on VBA from where you can take yourself to a higher level of expertise

Course Contents

• The Excel Object Model
• The Visual Basic Editor
• Objects and Methods
• Variables and Data Types
• Writing Your Own Procedures
• The Workbooks and Workbook Objects
• The Worksheets and Worksheet Objects
• Range References
• Range Actions
• Range Object
• Conditional Logic
• If Then Statement
• Loop
• Iteration
• Alerts
• Configuring Excel Functionality
• Custom Functions
• Arrays
• Function and Sub
• Debugging
• Even Procedures
• User Forms