Week - 1 |
Worksheet and Programming |
Week - 2 |
Introduction to Macros |
Week - 3 |
Working with VBA Window |
Week - 4 |
Fundamentals of VBA Programming |
Week - 5 |
Basic Code Structures |
Week - 6 |
Error detection and correction |
Week - 7 |
Midterm |
Week - 8 |
Functions and procedures |
Week - 9 |
Creating User Forms |
Week - 10 |
User forms, Properties of user forms, Form controllers |
Week - 11 |
API operations |
Week - 12 |
Database operations |
Week - 13 |
File Operations in VBA |
Week - 14 |
Final Exam |