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:
Website:
DOWNLOAD BROSUR
FORM REGISTRASI