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/23/2018
End Date: 04/27/2018
Ksh 70000, $ 800
Course Description
Course Duration: 5 days
Training Center: Datastat Research Center
Start Date: 04/23/2018
End Date: 04/27/2018
Fee: Ksh 70000, $ 800
Training Course on Mobile Based Data Collection Tools For...
Data collection and monitoring and evaluation (M&E) have always been an integral parts of development work. ICT tools such as mobile devices and software that allows users to create surveys, collect, manage and upload data to storage facilities in real-time, have reduced the conventional chal...
Start Date: 04/30/2018 End Date: 05/04/2018
Price
KES70000, $ 800
Training Course on Mobile Based Data Collection Tools For...
Data collection and monitoring and evaluation (M&E) have always been an integral parts of development work. ICT tools such as mobile devices and software that allows users to create surveys, collect, manage and upload data to storage facilities in real-time, have reduced the conventional chal...
Start Date: 05/14/2018 End Date: 05/18/2018
Price
KES70000, $ 800
Training Course on Mobile Based Data Collection Tools For...
Data collection and monitoring and evaluation (M&E) have always been an integral parts of development work. ICT tools such as mobile devices and software that allows users to create surveys, collect, manage and upload data to storage facilities in real-time, have reduced the conventional chal...
Start Date: 05/28/2018 End Date: 06/01/2018
Price
KES70000, $ 800
Mobile No: +254724527104
Email Add: info@datastatreseach.org
Postal Add: 5402-00100
Head Office: Comet House 1st floor room 12A, Along Monrovia Street