Excel VBA

VBA Coding for Excel application

Topics Covered

-THE ADVANTAGES OF VBA
-GETTING TO KNOW THE VBA DEVELOPMENT ENVIRONMENT
-WRITING VBA CODE
-STORING DATA IN VARIABLES
-CONDITIONAL BRANCHING
-LOOPING THROUGH CODE
-UNDERSTANDING OBJECT MODEL STRUCTURES
-USING INTRINSIC DIALOGS
HANDLING RUNTIME ERRORS
-IMPLEMENTING SECURITY

Who should attend

Person who is having basic knowledge of Programming and Good knowledge of Excel operation

Pre-requisites

-Programming basic knowledge
-hands on experience in Excel
-Not fresher

What you need to bring

A Copy and Pen for writing notes.
Computer will be provided from institute

Key Takeaways

Hands on excel macro (VBA), Good understanding of MIS and Business intelligence and Data management.