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
    Mei, 27, 2021

    Coaching & Counseling Skill

    Confirm Running
    Mei, 29, 2021

    Financial Management For Non Finance

    Confirm Running
    Mei, 03-04, 2021

    Project Risk Assesment For Manufacturing

    Confirm Running
    Mei, 06-07, 2021

    Financial Statement Analisis

    Confirm Running
    Mei, 10-11, 2021

    Cost Analysis For Manufacturing

    Confirm Running
    Mei, 20, 2021

    Behavioral Event Interview (BEI) – CBHRM

    Confirm Running
    Mei, 22, 2021

    Online Class
    Training Need Analysis (TNA)

    Confirm Running
    Mei, 27, 2021

    Online Class
    Basic Accounting

    Confirm Running
    Mei, 10, 2021

    5-S In Office

    Confirm Running
    Mei, 21, 2021

    Cash Management

    Confirm Running
    Mei, 25, 2021

    Accounting Policies And Procedure Manual

    Confirm Running
    Mei, 25, 2021

    Compensation System Development

    Confirm Running
    Mei, 28, 2021

    Procurement Contract Management ”

    Confirm Running
    Mei, 27, 2021

    Persiapan Pra Pensiun”

    Confirm Running
    Juni, 22-23, 2021

    Marketing & Sales Planning Strategic Alignment For Effective Result

    Confirm Running
    Juni, 23-24 ,2021

    Effective Leadership

    Confirm Running
    Juni, 15-16, 2021

    Time Management

    Confirm Running
    Juni, 02-03 , 2021







    VIDEO JOHNSON