|  TRAINING SERVICES
 
Home   |  Site Map   |  Careers  
Working Hrs : 8am - 9pm
  Ph. +974 4443 5361 / 4437 0779
Fax. +974 4444 9130
Email: training@fccqatar.com
     
facebook | twitter | LinkedIn | You Tube  
Family Computer Centre - Training Division
  • Become the first Chaos Group Authorized Training Centre (CG ATC) in Qatar
  •  | We are PMI® Accredited global PMP® training provider
  •  | Our PMI® Registered Education Provider (R.E.P.) Id is 2739
  •  | FCC started REVIT courses for architectural design, MEP and structural engineering, and construction
  •  | Family Computer Centre becomes Autodesk authorized certification & Training Centre
  •  | Family Computer Centre joins Pearson VUE Select Network to offer accessible and highly secure certification testing
  •  | Family Computer Centre is an authorized C++ academy to offer certified C++ courses
Courses Offered head
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
      COURSES OFFERED
Download PDF Send an Enquiry
 
MS Excel VBA
Course Duration: 30 Hours

MS Excel 2010 VBA

Who should do the Course

This course is the perfect introduction to VBA (Visual Basic for Applications) and shows, how to use it to enhance Excel. It helps to learn how to work with the key objects and uncover the best ways to gain access to workbook, worksheets and many more. The person who have proficient knowledge of Microsoft Excel can learn this course to improve their computing skills using the excel


      Course Details    
 
INTRODUCTION & BASICS OF MACRO
    Introducing Visual Basic for Applications
    Displaying Developer tab
    Recording a Macro
    Saving a Macro Enabled work book
    Running a Macro
    Editing a Macro in Visual Basic Editor
    Understanding the development Environment
    Understanding Macro Security
WORKING WITH PROCEDURES &FUNCTIONS
    Understanding Module
    Creating Standard Module
    Understanding Procedure
    Creating Procedure
    Creating Sub Procedures
    Calling Procedures
    Making function procedure
    Using the code editor
OBJECTS
    Understanding objects and collections
    Using the object browser
    Working with properties
    Understanding and using methods
    Event and Event procedure
 
 

EXPRESSIONS & VARIABLES
    Data types
    Declaring variables
    Using Message box and Input Box
    Declaring and using object variables
CONTROLLING PROGRAM EXECUTION
    Decision Making
    Looping Statements
USER FORMS AND CONTROLS
    Understanding user form
    Using the toolbox
    Setting properties & adding codes to controls
    Launching a form in code.
DEBUGGING AND ERROR HANDLING
    Understanding errors & using debugging tools
    VBA's error trapping options
    The On Error statement
    Error Handling routines


 
Family Computer Centre,
Al Rayyan Complex, Al Rayyan Road,
P.O.Box 14337, Doha - Qatar,
Ph.(974) 4443 5361 / 4437 0779, Fax. (974) 4444 9130,
Email: This email address is being protected from spambots. You need JavaScript enabled to view it.
               
facebook | twitter | LinkedIn | You Tube  
Copyright © Family Computers All Rights Reserved