Scope of the Session
This session takes up for discussion and illustration of MS Excel Macros and VBA Programming in MS Excel.
Focus Areas - MS Excel Macros
After this part of the session, the participants will get equipped with basic concepts, creation, calling, assigning and editing of excel macros besides understanding the environment required as well as the security settings that need to be kept in mind in the course of handling Excel macros.
Focus Areas - VBA Programming in MS Excel
On completing this part, the participants will understand (a) Distinguishing functionality between Excel Macros and VBA Macros (b) Basic Environment Settings of VBA for MS Excel (c) Architecture of VBA (d) Excel Object Model (e) Building Blocks of VBA Programming and learn certain skills and acquire the ability to apply those skills in creating illustrative VBA programs and to take them forward.