INTRODUCTION Visual Basic for Applications (VBA) is an object oriented programming language developed by Microsoft. VBA language has been integrated with Excel in order to have programming features which enables the developers to handle the data manipulation along with Excel function very easily. VBA is good for developing reporting systems in a capital markets environment and developing core business performance reporting etc. Using a step-by-step approach, this course shows how the Visual Basic for Applications (VBA) programming language can extend the functionality of Excel. Students will learn to write macros to accept user input, read to and write from cells, and manipulate data. They will also learn to write custom functions and create user forms. Useful examples of problems and their solutions will be provided. DURATION 5 days. WHO SHOULD ATTEND This advanced training course is ideal for: COURSE OBJECTIVES Upon completion of this training course, participants should be able to: COURSE CONTENT Understanding VBA The VBA Editor Using ArraysFunctions In VBA Programming Techniques METHODOLOGY The instructor led trainings are delivered using a blended learning approach and comprises of presentations, guided sessions of practical exercise, web based tutorials and group work. Our facilitators are seasoned industry experts with years of experience, working as professional and trainers in these fields. All facilitation and course materials will be offered in English. The participants should be reasonably proficient in English.
Start Date: 04/09/2018
End Date: 04/13/2018
Ksh 70000, $ 800
Registration for this course has been closed. Please click ALL COURSES to view more future courses
Course Description
Course Duration: 5 days
Training Center: Datastat Research Center
Start Date: 04/09/2018
End Date: 04/13/2018
Fee: Ksh 70000, $ 800
Registration for this course has been closed. Please click ALL COURSES to view more future courses1. | 1 | 80,000.00 | 900.00 | 160,000.00 | 1800.00 |
2. | 2 - 6 | 65,000.00 | 830.00 | 130,000.00 | 1,660.00 |
3. | 7 - 11 | 63,000.00 | 800.00 | 126,000.00 | 1,600.00 |
4. | 12 - 16 | 59,000.00 | 750.00 | 118,000.00 | 1,500.00 |
5. | 17 - 21 | 57,000.00 | 700.00 | 114,000.00 | 1,400.00 |
6. | 22 - 26 | 53,000.00 | 670.00 | 106,000.00 | 1,340.00 |
7. | 27 - 31 | 51,000.00 | 650.00 | 102,000.00 | 1,300.00 |
8. | 32 - 36 | 47,000.00 | 580.00 | 94,000.00 | 1,160.00 |
9. | 37 - 41 | 45,500.00 | 670.00 | 91,000.00 | 1,100.00 |
10. | 42 - 46 | 41,000.00 | 500.00 | 82,000.00 | 1,000.00 |
11. | 47 - 51 | 35,000.00 | 480.00 | 70,000.00 | 960.00 |
12. | 52 > Above | 30,000.00 | 450.00 | 60,000.00 | 900.00 |
Training Course On Android Application Development & Prog...
This course is entails Android Programming, with full practical approach of cre...
Start Date: 03/18/2019 End Date: 03/29/2019
Price
KES160000, $ 1800
Training Course On Android Application Development & Prog...
This course is entails Android Programming, with full practical approach of cre...
Start Date: 04/15/2019 End Date: 04/26/2019
Price
KES160000, $ 1800
Training Course On Web-Based GIS And Mapping...
This course entails processing and distributing geographic information through the internet by use ofGIS (Geographic information systems).GIS are computer systems that are desinged to capture, store, check, and display data that is related to positions on the Earth’s surface.
Start Date: 03/04/2019 End Date: 03/08/2019
Price
KES80000, $ 900
Mobile No: +254724527104/ +254734969612
Email Add: info@datastatreseach.org
Postal Add: 5402-00100
Head Office: Comet House 1st floor room 12A, Along Monrovia Street, Nairobi, Kenya