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 :

Tahun 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

Tahun 2023

Januari 2023

Februari 2023

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

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

E-mail:

[email protected]

[email protected]

Website:

Home

https://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
    Customer Loyalty Management

    Confirm Running
    September, 19-20, 2022

    Agile Leader in Vuca Situation

    Confirm Running
    September, 20-21, 2022

    Vendor Management

    Confirm Running
    September, 26-27, 2022

    Purchasing & Procurement Management

    Confirm Running
    September, 14-15, 2022

    Leading and Managing Cost Reduction Strategy
    September, 19-20, 2022

    General Affairs Professional

    Confirm Running
    September, 12-13, 2022

    Balance Scorecard & KPI Design

    Confirm Running
    September, 28-29, 2022

    Cash Flow & Treasury Management

    Confirm Running
    September, 22-23, 2022

    Lean Six Sigma White Belt

    Confirm Running
    September, 28-29, 2022

    Cash Management

    Confirm Running
    September, 19-20, 2022

    Basic Multifinance Business

    Confirm Running
    September, 14-15, 2022

    Strategic Thinking

    Confirm Running
    September, 29-30, 2022

    Neuro Lingustic Programing (NLP) At Work & Change Mindset

    Confirm Running
    September, 27-28, 2022

    Digital Marketing

    Confirm Running
    September, 22-23, 2022

    Effective Leadership

    Confirm Running
    September, 29-30, 2022

    Effective Communication

    Confirm Running
    September, 22-23, 2022

    Whistle Blowing System (WBS)

    Confirm Running
    September, 20-21, 2022

    Innovation Strategy

    Confirm Running
    September, 21-22, 2022







    VIDEO JOHNSON