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 2021 :

18-19 Januari 2021

15-16 Februari 2021

09-10 Maret 2021

06-07 April 2021

27-28 Mei 2021

28-29 Juni 2021

06-07 Juli 2021

02-03 Agustus 2021

01-02 September 2021

05-06 Oktober 2021

01-02 November 2021

21-22 Desember 2021

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 :

  • Offline Training (Di Hotel / Johnson Training Center)
  • Online Training (Special By One Get One Free)

Fee Training (Jakarta):

Rp. 12.000.000,-/ orang (Offline & Online Training)

Fee Training (Luar Kota):

Rp. 12.000.000,-/ orang (kirim 1-5 peserta)

Rp. 10.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:

Jadwal Public Training – Johnson Indonesia

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
    The Way of Thinking – Through Creative & Rational Thinking

    Confirm Running
    Agustus, 30-31 Juni , 2021

    Coaching & Counseling Skill

    Confirm Running
    Agustus, 02-03, 2021

    Financial Management For Non Finance

    Confirm Running
    Agustus, 16, 2021

    Project Risk Assesment For Manufacturing

    Confirm Running
    Agustus, 23-24, 2021

    Financial Statement Analisis

    Confirm Running
    Juli, 15, 2021

    Cost Analysis For Manufacturing

    Confirm Running
    Agustus, 18-19, 2021

    Behavioral Event Interview (BEI) – CBHRM

    Confirm Running
    Agustus, 25-26, 2021

    Online Class
    Training Need Analysis (TNA)

    Confirm Running
    Agustus, 30, 2021

    Online Class
    Basic Accounting

    Confirm Running
    Agustus, 18, 2021

    5-S In Office

    Confirm Running
    Agustus, 19-20, 2021

    Cash Management

    Confirm Running
    Agustus, 20, 2021

    Accounting Policies And Procedure Manual

    Confirm Running
    Agustus, 27, 2021

    Compensation System Development

    Confirm Running
    Agustus, 18, 2021

    Procurement Contract Management ”

    Confirm Running
    Agustus, 11, 2021

    Persiapan Pra Pensiun”

    Confirm Running
    Agustus, 12-13, 2021

    Marketing & Sales Planning Strategic Alignment For Effective Result

    Confirm Running
    Agustus, 04-05 ,2021

    Effective Leadership

    Confirm Running
    Agustus, 11-12, 2021

    Time Management

    Confirm Running
    Agustus, 18-19, 2021







    VIDEO JOHNSON