Ms. Excel VBA (Macro) Complete Beginner

MANFAAT TRAINING :

• Macro/VBA Excel Introduction 1
• Macro/VBA Excel Introduction 2
• Looping, Brancing and Error Handling Application
• Case Study

MATERI TRAINING  :

• Macro Definition and Usage
• Macro Recording
• Macro Script Editing
• Running a Macro
• Form Control
• Relative reference & non relative reference
• Variabel declaration
• Array declaration
• Looping
• For/Next, Do/While, etc
• If Then, Goto, etc
• On error resume next
• Simple Macro Application
• Macro Recording
• Script Edit and Customization
• Running and Error Tracking

TARGET PESERTA :

Pihak-Pihak Terkait

Team Trainer Johnson Indonesia :

• Rizky Luxianto, MBA

Tanggal Pelaksanaan :

Tahun 2021 : 18-19 Januari 2021 15-16 Februari 2021 09-10 Maret 2021 06-07 April 2021 27-28 Mei 2021 28-29 Juni 2021

06-07 Juli 2021 02-03 Agustus 2021 01-02 September 2021 05-06 Oktober 2021 01-02 November 2021 21-22 Desember 2021

Jam Pelaksanaan :

09.00 – 16.00 WIB

Tempat :
Alternatif Hotel: Ibis Group, Oria, Amos Cozy, The Park Lane, Harris Group, hotel lainnya yang akan kami konfirmasi kemudian

Metode Training :

• Offline Training (Di Hotel / Johnson Training Center)
• Online Training (Special By One Get One Free)

Fee Training (Jakarta):

Rp. 12.000.000,-/ orang (Offline & Online Training)

Fee Training (Luar Kota):

Rp. 12.000.000,-/ orang (kirim 1-5 peserta)

Rp. 10.000.000,-/ orang (kirim diatas 5 peserta)

Inc : Seminar Kit, Certificate, Lunch, Snack, Souvenir

 

INFORMASI

Registrasi, hubungi :

Johnson Indonesia – Training Center

Nur/ Komariah/ Ria/ Nisa

Telp. (021) 541 9152/ 541 7516, Hp: 0815 972 5020

E-mail:

[email protected]

[email protected]

Website:

Jadwal Public Training – Johnson Indonesia

http://www.johnson.co.id

DOWNLOAD BROSUR

FORM REGISTRASI