ADVANCE EXCEL WITH VBA
This Advance Excel Course with VBA includes 5 months of live interactive sessions led by industry experts, 30+ modules, 10+ tools, e-books, practise exercises, PDFs, and more. It also offers a full review of advanced Excel capabilities with real-world applications.
Syllabus
| Syllabus |
|---|
| 1.INTRODUCTION TO VBA |
| 2.UNDERSTANDING VBA EDITOR, MODULE & PROCEDURES |
| 3.VBA SYNTAX |
| 4.VARIABLES,CONSTANTS,ARRAYS IN VBA |
| 5.CREATING CUSTOMIZE DIALOG IN FORM OBJECT |
| 6.STROING DATA IN VARIABLES |
| 7.CONTROL STRUCTURE & PROGRAM |
| 8.BUILDING PROCEDURES |
| 9.MESSAGE BOX AND INPUT BOX FUNCTION |
| 10.IF ANDE SELECT STATEMENT |
| 11.LOOPING IN VBA |
| 12.WORKSHEET & WORKBOOK |
| 13.VBA FROM APPLICATION |