aa home
aa faq
online distance learning, training, home study computer courses
 

online training free trial courses
Become our Bussiness Partner  
 
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:
Rediff Bol:
MSN Messenger:
Skype Talk:
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.


"Compufield -computer Institute specialized in fast track courses-multimedia,web designing,software engineering,certification courses,fashion,jewellery,interior designing courses. India,Bombay(Mumbai)." "COMPUFIELD-Leader in Global IT Corporate training having more than 20yrs exp.Programs offered MS-Office, Advance Excel, Java, Oracle, Linux and many more.""Compufield : free e-greeting cards, animated, musical greetings, ecards, postcards for Christmas, xmas, new year, eid, diwali, valentine's day, birthday, friendship, anniversary, love, congratulations, Halloween."