Uncategorized
.net training in palwal, 1 year computer course in palwal, Advance Excel training, Best Computer Frachise institute in India, computer institute in Palwal, Digital marketing course in palwal, government computer course in palwal, java training in palwal, online apply of Computer Franchise, web developement training in palwal, web site design traning in palwal
Which is best institute for VBA Programming training in Palwal?
Post By
admin
30-November-2017
Excel Computer Classes is best institute for VBA Programming training in Palwal. Here you will learn all the latest and advance technique for these course.
Course Fee
|
Course Code
|
:
|
C028
|
Registration Fee
|
:
|
200
|
|
Course Name
|
:
|
Certificate in Excel VBA Programming
|
Exam Fee
|
:
|
300
|
|
Duration
|
:
|
2 Months
|
Fee
|
:
|
4000
|
|
Total
|
:
|
4500
|
Course Detail
|
SNO
|
Topic
|
Content
|
|
1.
|
Introduction to VBA
|
Introduction to Excel, Introduction to Programming VBA Overview and
the IDE Quick Review of Macros Working with Macros, How to use Visual Basic Editor (Programming Environment) |
|
2.
|
Advantage
of VBA |
An easy-to-use and versatile language, Integrated with off-the-shelf
products |
|
3.
|
Understanding the VBA Editor Modules and Macros
|
The Visual Basic Editor Parts of the
VBA Editor Modules and Macros, About VBA Forms, Sub Procedures & Modules Creating Forms, Using Controls and their Properties Running VBA Forms in Excel |
|
4.
|
VBA Syntax
and Grammar |
Objects – The Grammar, Using Properties and Methods Understanding
Parameters The Object Browser, Understanding object hierarchy Tools for better coding, Moving to Other Cells Editing Specific Cells |
|
5.
|
VBA Syntax and Grammer
|
Objects – The Grammar, Using
Properties and Methods, Understanding Parameters, The Object Browser, Understanding object hierarchy, Tools for better coding, Moving to Other Cells, Editing Specific Cells |
|
6.
|
Variables,
Array and Constants |
Using the Immediate Window, Gaining greater control through the
immediate window, Formatting Cells, Using Variables, Constants, Object Variables, Dimensioning and usage of variables, Displaying data and obtaining data from the user |
|
7.
|
Storing Data in a Variable
|
How and when to declare variables,
Selecting data types, Fixed and dynamic arrays, Constants |
|
8.
|
Control
Structure and Program Flow |
IF (ElseIf, Else), Select Case(), For Next Loop, For Each Loop(), Do
Until Loop and Do While Loop, With, End With, Nesting Code |
|
9.
|
Building Procedures
|
Creating Sub and Function
procedures, Calling procedures, Passing arguments to procedures |
|
10.
|
Building
Intuitive User Interface |
Communicating with the user through the message box, Gathering user
information with the input box, Utilizing the File Dialog object and Dialogs collections |
|
11.
|
User Form
|
Command buttons, List and Combo
boxes, Labels, Option buttons, Check boxes, Text boxes, Frames, Adding more functionality with advanced ActiveX control |
|
12.
|
Fonts and
Background |
Using Font Property in cells, Using Various Background Properties in
Excel VBA, Creating a Counter, String Handling, Using Left, Right, Instr, Mid and Len Functions in VBA, Range Selection and Manipulation |
|
13.
|
Workbook and WorkSheets
|
Workbook and Worksheet Object, Range
Object and Cell Properties, Methods and Properties, Assigning Objects, Using Name Arguments |
|
14.
|
Array
|
What is Array& why use array, Declaring an Array, Sorting Data in
Array, 2-Dimention Array, Dynamic Array, |