|
|
| VB Macros |
| PROGRAMS |
PRE REQUISITS |
MODULES |
DURATION |
| VB-MACROS |
Basics of Computers and MS Office |
|
30 HRS |
| |
UNIT 1
- Visual Basic Editor in Excel (VBE)
- Project Window in the Visual Basic Editor
- Properties Window in the Visual Basic Editor
- Code Window in the Visual Basic Editor
UNIT 2
- Building Macros in Excel
- Testing Macros in Excel
- Debugging the Macros
UNIT3
- Macro Recorder in Excel
- Modifying Macros in Excel
- Security and Protection in VBA for Excel
- Events in VBA for Excel
UNIT4
UNIT5
- Working with the Application Object
UNIT6
- Working with Workbooks Object
UNIT7
- Working with Worksheets Object
UNIT8
UNIT9
- Message Boxes and Input Boxes in VBA for Excel
- Working with Variables
UNIT10
- Working with Database and Filters
UNIT11
- Working with Errors
- Working with Functions, Procedures, Modules and classes
UNIT12
- Working with SQL and External Data
UNIT13
UNIT14
UNIT15
- Working with Pivot tables and Charts
UNIT16
|
|
|
|
|
