aa
home
aa
faq
aa
login
aa
site map
aa
search
aa
contact us
About Us
Free Trial Courses
How It Works
Our Partners
Enquiry Form
Payment Method
Become our Bussiness Partner
MULTIMEDIA
INTERNET COURSES
DESIGNING COURSES
PROGRAMMING COURSES
OFFICE AUTOMATION
Certificate Course in
Office Automation
Diploma in Office Automation
Financial Accounting
Diploma in Microsoft Excel (Financial Accounting)
Diploma Course In Accounting + Financial Accounting
Diploma Course in Computerized Financial Accounting
view all courses
NETWORKING COURSES
Office Automation Courses
Download
Free Trial & Course Content of the Courses
Course Contents
1)
Understanding Security Levels
Why security
Security levels and its meaning
2)
Functions
What is Function and Subroutine
Writing Functions using VBA Editor
Calling function in other workbook
3)
Recording Macros
Recording and running macro
Storing macro in different books
Creating buttons and assigning macro to it
Creating My Menu
4)
The Visual Basic Editor
Editing macros using VBA Editor
Understanding the project explorer
Exploring windows properties
Modifying code in code window
Debugging code
5)
Programming Fundamentals
Variables, data types and constants
Arrays
Object Variables
Conditional structures (If …. Then, Select Case)
Logical Operators
Looping constructs (For loops, Do loops, while… Wend)
Built-in functions
Creating Subroutines
6)
Excel Object Model
Working with objects – properties, events and methods
Application objects
Workbook objects, Worksheet objects and Range objects
Charts objects
Pivot table objects
7)
User Forms
Creating forms
Form events
Creating custom menus and toolbars
Creating Add-ins
Do you want to Enquire about this Course?Please fill up the Enquiry Form given below
Enquire About This Course
Name
:
Contact Number
:
(country_code-city_code-number)
e.g. +91-022-23676218
Email
:
Course Of Interest
:
Enquiry
:
SOLVE YOUR QUERIES ONLINE
Email:
Google Talk:
Yahoo Messenger:
info@aonlinetraining.com
fkhairaz@gmail.com
fkhairaz@yahoo.co.in
Rediff Bol:
MSN Messenger:
Skype Talk:
fkhairaz@rediffmail.com
fkhairaz@hotmail.com
faiyaz_khairaz@skype.com
Contact Person:
Mr. Faiyaz Khairaz:
+91 9819006132
Office Address:
Head Office: Chinoy Mansion, First Floor, Block # 2, Opposite St. Stephens Church, Warden Road,
Mumbai(Bombay) - 400 036, Contact No.:+91-22-23676218 / 23679302 / 9819006132.