This course consists of Modules that are required for Professionals, Managers, B School Students, Accounting and Finance Students and Faculty from an automation as well as effectiveness perspective.
After completing this course, the participants will be equipped with the knowledge and skills that will enhance and imrpovise the participant's technical and professional skill sets. This course consists of the following Modules.
|
Module No |
Module Title |
|
1 |
Introduction and Prelude to Advanced MS Excel and VBA |
|
2 |
If and its Variant Functions |
|
3 |
Cell Names and Range Names |
|
4 |
Introduction to MS Excel Macros and VBA Programming |
|
5 |
Recording and Editing MS Excel Macros |
|
6 |
Introduction to VBA Macros and Excel Programing |
|
7 |
Generic VBA Procedures – Principal Objects |
|
8 |
Generic VBA Procedures – Memory Variables |
|
9 |
Use Cases of Application of Advanced MS Excel and VBA - General |
|
10 |
Advanced Excel and VBA Application in Securities Analysis |
|
11 |
VBA Code Snippets for Reverse Practice |