Jadwal Training 2024

EXCEL VBA (Excel Programming)

 

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

Bagikan:

KONTAK CEPAT

Tags

Avatar photo

 

Jika ada kebutuhan Inhouse training atau kelas khusus silahkan hubungi 0851-0197-2488 / 0899-8121-246 Petrus Soeganda. Untuk mengundang Petrus Soeganda sebagai Pembicara Internet Marketing

Tinggalkan komentar

Chat dengan kami
CV INFO SEMINAR
0899-8121-246