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 :
25-26 Januari 2022 09-10 Februari 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 |
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 :
- 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:
Website:
DOWNLOAD BROSUR
FORM REGISTRASI
