Office Automation Courses


Connect with us on WHatsAPP
 
   
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 :
     
   
     
 

   

* The cost for the course in Indian Rupees (INR) would change depending on the "Current Rate"of US Dollar

 
           
 
SOLVE YOUR QUERIES ONLINE
Email:
Google Talk:
Yahoo Messenger:
WhatsAPP / Viber
MSN Messenger:
Skype Talk:
Connect with us on WhatsAPP  / Connect with us on Viber +91 9819006132
Contact Person:
Mr. Faiyaz Khairaz: Mobile - Connect with us+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 / +91-22-23679302 /
Mobile: +91-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."