What's New?

Mastering Excel 2007 Beyond For Data Processing Automation

Mastering Excel 2007 Beyond For Data Processing Automation – [S300]

DATE : Jkt, 14-15 Agt / Yogya, 21-22 Okt / Jkt, 23-24 Des 2014
VENUE : Hotel di Jakarta/ Bandung/ Bali/ Yogya/ Batam

INVESTASI :
Jakarta/Bandung : Rp 4.000.000,-/peserta
Yogyakarta : Rp 4.750.000,-/peserta
Bali/Batam/Surabaya : Rp 6.000.000,-/peserta
Facilities : Modul Hand-out, Flashdisk, 2x Coffee Break, Lunch, Sertificate, Non Residential

FASILITATOR
Erawan Supriyatna, S.Kom

SYLLABUS
– How using database import
– How using of Cell Address Automation.
– How using of Data Sort
– How using of Conditional Formatting
– How using of Consolidate method.
– How using of String Function
– How using of Numeric Function.
– How using of Remove Duplicates Tools
– How using of Single and Multiple IF() Function.
– How using of Logic Operator AND and OR.
– How using of Table Function and Operational Table.
– How to make union field key
– How using Auto Filter with union field key
– How make Advance Filter (Criteria and Output Data Query).
– How using of PivotTable method.
– How using of PivotChart method.
– How using of Format Cells for Locked and Hidden Cells
– How using of Using Allow Users to Edit Range ( Permission User Access Setting)
– How using of Protect Sheet ( Select Locked Cells and Select Unlocked Cells )
– How using of Implementation Macro and Record Macro
– Case study implementation
– Training evaluation

FORM PENDAFTARAN klik
http://semuaseminar.com/mastering-excel-2007-beyond-for-data-processing-automation-2/

atau Hubungi :
Riri : 0838 90 444 722
PIN BB : 3140FFDF
Email : info@semuaseminar.com
Website : http://www.semuaseminar.com/

:: Informasi Iklan ::

Penerbit: Riri

Kategori: Serba-Serbi

Lokasi: N/A

Kontak:

Label: Data