Book By Johnson Alvonco

Ms. Excel VBA (Macro) Complete Beginner

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 :

21–22 Januari 2026

07–08 Juli 2026

24–25 Februari 2026

03–04 Agustus 2026

05–06 Maret 2026

09–10 September 2026

15–16 April 2026

12–13 Oktober 2026

18–19 Mei 2026

12–13 November 2026

24–25 Juni 2026

14–15 Desember 2026

Jam Pelaksanaan:

  • Online Training: 2 hari / jam 09.00-16.00 WIB
  • Offline Training: 2 hari / jam 09.00-16.00 WIB

Tempat :
Alternatif  Hotel: Ciputra Hotel, Ibis Group, Hotel Oria Jakarta, Hotel Holiday Inn Jakarta wahid hasyim, hotel lainnya yang akan kami konfirmasi Alternatif kemudian

Metode Training :

  • Online Training (Zoom Meeting)
  • Offline Training (Di Hotel / Johnson Training Center) 

Fee Training (Jakarta):

  • Online Training: Rp. 5.500.000,-/orang / 2 hari full day 
  • Online Training 5.950.000,-/orang / 2 hari full day (Minimal Kouta 3 Orang Running di Hotel)

Private Training (Jakarta):

Rp. 8.000.000,-/ orang (PASTI RUNNING)

Fee Training (Luar Kota):

Rp. 12.000.000,-/ orang (PASTI RUNNING)

Rp. 8.500.000,-/ orang (Minimal kirim 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/Nisa /Dinda/Mumun 

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

E-mail:

infotraining27@gmail.com

info27@johnson.co.id

Website:

Home

http://www.johnson.co.id

DOWNLOAD BROSUR

FORM REGISTRASI

    Kode Training

    Topik Training

    Tanggal Training

    Lokasi Training

    Tipe Permintaan

    Peserta yang didaftarkan

    Nama

    Jabatan

    Metode Pembayaran

    Pesan

    Enrroled By:

    Nama

    Email

    Nama Perusahaan

    Jabatan

    Telp Kantor

    Fax

    No. Hp

    Note

    Kirim Salinan Form ke Email saya

    captcha
    Masukkan kode diatas:

    Print Friendly, PDF & Email






    JADWAL FIXED TRAINING
    Basic HRM For The Beginner


    Januari, 12-13, 2026

    Credit Analysis for Banking


    Januari, 19-20, 2026

    Risk Management For Banking


    Januari, 21-22, 2026

    Management Risiko Investasi


    Januari, 26-27, 2026

    General Affair Professional
    Januari, 28-29, 2026

    Supervisory Management


    Januari, 20-21, 2026

    Behavioral Event Interview (BEI) – CBHRM


    Januari, 22-23, 2026

    Public Speaking And Being Confident


    Januari, 27-28, 2026

    Account Officer For Banking


    Januari, 14-15, 2026

    Masa Perisapan Pensiun


    Januari, 13-14, 2026

    Project Management


    Januari, 22-23, 2026

    Design Thinking


    Januari, 14-15, 2026

    Total Productive Maintenance (TPM)


    Januari, 29-30, 2026

    Coaching & Counseling Skill


    Januari, 19-20, 2026

    Effective Leadership


    Januari, 28-29, 2026

    Analytical Creative Thinking


    Januari, 19-20, 2026

    Quality Control Cycle (QCC)


    Januari, 08-09, 2026

    Collection, Receivable & Credit Risk Management


    Januari, 19-20, 2026







    VIDEO JOHNSON