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 :

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:

infotraining27@gmail.com

info27@johnson.co.id

Website:

Home

http://www.johnson.co.id

DOWNLOAD BROSUR

FORM REGISTRASI