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:
Website:
DOWNLOAD BROSUR
FORM REGISTRASI