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

08-09 Januari 2025

04-05 Februari 2025

04-05 Maret 2025

07-08 April 2025

06-07 Mei 2025

05-06 Juni 2025

03-04 Juli 2025

05-06 Agustus 2025

03-04 September 2025

02-03 Oktober 2025

05-06 November 2025

03-04 Desember 2025

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/ Mumun / Nisa

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

E-mail:

infotraining27@gmail.com

info27@johnson.co.id

Website:

Home

http://www.johnson.co.id

DOWNLOAD BROSUR

FORM REGISTRASI