Komodo Tour Leisure in Komodo and flores island is a local tour operator base in Labuan Bajo Flores – Indonesia. Our main goal is to arrange the Great trip Komodo and Flores Island. we have friendly staff and the helpful Guide that would handle you during the trip with us. Our business has been running the last 10 years, and our primary focus to

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