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 2022 :

17-18 Maret 2022

19-20 April 2022

17-18 Mei 2022

07-08 Juni 2022

06-07 Juli 2022

11-12 Agustus 2022

21-22 September 202

13-14 Oktober 2022

22-23 November 2022

13-14 Desember 2022

Tahun 2023

Januari 2023

Februari 2023

Jam Pelaksanaan :

Online Training: 1 hari / jam 09.00-16.00 WIB
Online Training: 2 hari / jam 09.00-16.00 WIB
Offline Training: 2 hari / jam 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 :

Online Training (Zoom Meeting)
Offline Training (Di Hotel / Johnson Training Center) (Trainer wajib negatif Rapid Test Covid berlaku selama 14 hari dan menggunakan Face Shield saat mengajar)

Fee Training (Jakarta):

Online Training: Rp. 3.500.000,-/orang 1 hari
Online Training: Rp. 5.500.000,-/orang 2 hari
Offline Training: Rp. 5.950.000,-/orang 2 hari

Private Training:

Rp. 8.000.000,-/ orang (PASTI RUNNING)

Fee Training (Luar Kota):

Rp. 12.000.000,-/ orang (PASTI RUNNING)

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

Rp. 8.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]

Website:

Home

http://www.johnson.co.id

DOWNLOAD BROSUR

FORM REGISTRASI