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 0851-0249-5051 dan 0899-812-1246
  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