- الموقع: P.O.Box 14337, Doha - Qatar
- مدة الدورة التدريبية: 30 Hours
تفاصيل الدورة
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 excel
Course Contents
MODULE I: 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
MODULE II: WORKING WITH PROCEDURES AND FUNCTIONS
- Understanding Module
- Creating Standard Module
- Understanding Procedure
- Creating Procedure
- Creating Sub Procedures
- Calling Procedures
- Making function procedure
- Using the code editor
MODULE III: OBJECTS
- Understanding objects and collections
- Using the object browser
- Working with properties
- Understanding and using methods
- Event and Event procedure
MODULE IV: EXPRESSIONS & VARIABLES
- Data types
- Declaring variables
- Using Message box and Input Box
- Declaring and using object variables
MODULE V: CONTROLLING THE PROGRAME EXECUTION
- Decision Making Statements
- IF…….else
- Select case
- Looping Statements
- Do…..Loop
- For….To….Next
- For Each…..Next
MODULE VI: USER FORMS AND CONTROLS
- Understanding user form
- Using the toolbox
- Setting properties and adding codes to the controls
- Launching a form in code.
MODULE VII: DEBUGGING AND ERROR HANDLING
- Understanding errors and using debugging tools
- VBA’s error trapping options
- The On Error statement
- Error Handling routines
نبذة عن معهد Family Computer Center
Family Computers is one of the pioneering companies to open computer training centre in Qatar and provides training services to corporate houses and individuals alike. we provide training for a wide range of topics related to computers and have trained in excess of 40,000 students. A figure which is more than most of the training providers put together.
We are always in the forefront in launching job oriented, practical computer training courses. We emphasis on the importance of individual attention to students and limited students in a batch. This also helps us to improve the quality of our service.
- JavaScript Full stack web developer virtual internship Virtual Bootcamp + Internship at Laimoonدرهم 1,449مدة الدورة التدريبية: Upto 30 Hours
- Microsoft Office 2016 Excel Beginners John Academy222 ريال قطري
4,805 ريال قطريمدة الدورة التدريبية: Upto 4 Hours - Microsoft Office 2010 Access Advanced Alpha Academy91 ريال قطري
1,019 ريال قطريمدة الدورة التدريبية: Upto 3 Hours