Advance Microsoft Office Excel

Advance Microsoft Office Excel

MANFAAT TRAINING :

  • Memahamifungsi-fungsi advance Microsoft  Office – Excel
  • Mampumenggunakanfungsi-fungsikalkulasi Excel
  • Memahami Program VBA Macro Excel

MATERI TRAINING  :

  • Working With Formulas/Functions Excel
  • Lookup and Reference Function
  • Logical Function
  • Database Function
  • Date & Time Function
  • Information Function
  • Mathand Trigonometry Function
  • Statistical  Function
  • Text Function
  • Conditional Formatting
  • Using Conditional Formatting
  • Using Conditional Formatting With Multiple Cell Rules
  • Using Color Cell and Formatting
  • Data Sorting & Filtering
  • Sorting Data By Value, Colors, etc
  • Using Filter To Short Data
  • Advance Filtering Option
  • Pivot Tables& Chart
  • Creating Pivot Table & Chart
  • Using Pivot Table & Chart Option
  • Formatting Pivot Table & Chart and Making Dynamic Pivot Table  & Chart
  • VBA Macro Excel
  • Introduction To VBA Macro
  • Recording Macro & Understanding Code Behind
  • Editing/ Writing VBA Code Saving As Macro or  Add-in

TARGET PESERTA :

Pihak-Pihak Terkait

Team Trainer Johnson Indonesia :

  • Ir. Rachmat Boerhan, CHRP, CHT, CPM, CSCP
  • Erawan Supriyatna

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:

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