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

Pendaftaran Sementara
  1. (required)
  2. (required)
  3. (valid email required)
  4. (required)
  5. (required)
  6. (required)
  7. Mohon tidak memesan tiket perjalanan / akomodasi penginapan sebelum ada kepastian training akan berjalan. Jika ada pertanyaan bisa menghubungi 085102495051 dan 08998121246
  8. Jika Anda mendaftarkan training ini untuk orang lain mohon cantumkan nama dan email di bawah ini
  9. Captcha
 

cforms contact form by delicious:days