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 2024 :
04-05 Januari 2024 06 -07 Februari 2024 13-14 Maret 2024 16-17 April 2024 20-21 Mei 2024 19-20 Juni 2024 |
22-23 Juli 2024
25-26 Agustus 2024 18-19 September 2024 21-22 Oktober 2024 21-22 November 2024 27-28 Desember 2024 |
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:
Website:
DOWNLOAD BROSUR
FORM REGISTRASI