|
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 |