|
Table of Content |
|
Module-I |
|
Extend Your Insight Office Excel |
|
Benefits of office open XML |
|
Finding Formulas |
|
The Choose Function |
|
Column Chart |
|
Pivot Tables |
|
VLookup Function |
|
Excel Scenario Manager |
|
Formulas |
|
Conditional Functions |
|
The Functions IF & OR |
|
Percentage Formulas |
|
Assignments |
|
Module-II |
|
Building macrosin Excel |
|
Visual Basic Editor (VBE) in Excel |
|
Creating Macro |
|
Practice a Simple VBA Program |
|
Programming Structure in Excel VBA |
|
The Concept of Variables |
|
Numeric data types |
|
Message Boxes (MsgBox) in VBA for Excel |
|
Creating & Managing Array Declaring |
|
Manage Dynamic Array |
|
Create Multi-Dimensional Array |
|
Loop Structures |
|
Font & Background Color |
|
Excel VBA Procedures – Functions |
|
Examples |
|
Objects & Collections |
|
Project Assignment |
|
Excel VBA Controls’ Properties and VBA Code |
|
Advance Excel |
|
Creating and Using Form |
|
Tab order |
|
Managing Controls |
|
List Boxes |
|
Combo Boxes |
|
Option Button, Check Boxes and Frames |
|
Image Control |
|
Event Handling |
|
Debugging and Dealing with Errors |
|
VBA Macros Security and Protection in Excel |
|
Formatting Controls |
|
Project Assignments |
|
Table of Content |
|
Module-I |
|
Extend Your Insight Office Excel |
|
Benefits of office open XML |
|
Finding Formulas |
|
The Choose Function |
|
Column Chart |
|
Pivot Tables |
|
VLookup Function |
|
Excel Scenario Manager |
|
Formulas |
|
Conditional Functions |
|
The Functions IF & OR |
|
Percentage Formulas |
|
Assignments |
|
Module-II |
|
Building macrosin Excel |
|
Visual Basic Editor (VBE) in Excel |
|
Creating Macro |
|
Practice a Simple VBA Program |
|
Programming Structure in Excel VBA |
|
The Concept of Variables |
|
Numeric data types |
|
Message Boxes (MsgBox) in VBA for Excel |
|
Creating & Managing Array Declaring |
|
Manage Dynamic Array |
|
Create Multi-Dimensional Array |
|
Loop Structures |
|
Font & Background Color |
|
Excel VBA Procedures – Functions |
|
Examples |
|
Objects & Collections |
|
Project Assignment |
|
Excel VBA Controls’ Properties and VBA Code |
|
Advance Excel |
|
Creating and Using Form |
|
Tab order |
|
Managing Controls |
|
List Boxes |
|
Combo Boxes |
|
Option Button, Check Boxes and Frames |
|
Image Control |
|
Event Handling |
|
Debugging and Dealing with Errors |
|
VBA Macros Security and Protection in Excel |
|
Formatting Controls |
|
Project Assignments |
