EXCEL VBA (Excel Programming)
Tanggal
6-9 November 2017
Jam Pelaksanaan
09:00 AM – 05:00 PM
Tempat
Harris Suites Fx Sudirman
Jakarta
Pembicara / Fasilitator
Mr. Mugilen
I have a progressive experience approximately 15 years as IT trainer. Most of my experiences are in lecturing in colleges & Institutes of Higher Learning, conducting corporate trainings and develop training materials. Apart from training , I do involve in web & portal development for commercial.
Harga
Rp 1.200.000/day
Materi
Understanding programming in excel
• Started with macros
• Visual basic editor
• Working in the VBA
VBA Object-Oriented
• Variables, data types, and constants
• Objects and collections
• Working with ranges
• Making decisions with vba
WRITING YOUR OWN CODE
• Repeating actions with loops
• Programming formulas
• Working with arrays
• Automating procedures with worksheet events
• Automating procedures with workbook events
• Handling duplicate items and records
• Using embedded controls
• Programming charts
• User-defined functions
• Debugging your code
ADVANCED PROGRAMMING TECHNIQUES
• Creating userforms
• Userform controls and their functions
• Advanced userforms
• Class modules
• Data access with activex data objects
• Add-ins