POWERFUL DATABASE ANALYSIS AND DASHBOARD REPORTING WITH EXCEL 2007 – YOGYAKARTA
[S307]
- Selasa – Kamis, 19 – 21 Juli 2016
- Selasa – Kamis, 9 – 11 Agustus 2016
- Selasa – Kamis, 13 – 15 September 2016
- Selasa – Kamis, 11 – 13 Oktober 2016
- Selasa – Kamis, 8 – 10 November 2016
- Selasa – Kamis, 29 November – 1 Desember 2016
- Selasa – Kamis, 13 – 15 Desember 2016
TEMPAT
Yogyakarta, Surabaya, Semarang, Solo, Jakarta, Bandung, Bali, Batam, Makassar, Balikpapan, Banjarmasin, Pontianak.
INVESTASI
- Investasi pelatihan selama 3 (tiga) hari ini adalah senilai Rp 7.500.000,- (Tujuh Juta Lima Ratus Ribu Rupiah) untuk setiap peserta (khusus untuk wilayah Yogyakarta, dengan minimal peserta 2 orang).
- Apabila perusahaan mengutus lebih dari 3 peserta, maka setiap peserta cukup membayar 7.000.000,- (Tujuh Juta rupiah).
- Untuk pelaksanaan di kota lain, harga menyesuaikan dengan jumlah peserta.
- Including : Trainer yang berkualitas, Module / Handout, Sertifikat, Training Kit (tas, block note, alat tulis, flask disk), Souvenir, 1 X Dinner, Pick up dari bandara jika mengirimkan minimal 2 peserta.
FASILITATOR
Agung B Wibowo ST, M.Kom/Budi Sutejho, S.Kom, MM dan Team
(Pakar dalam bidang IT & Telecom and Application Development, akademisi dan sekaligus praktisi, yang telah berpengalaman dalam memberikan training & consulting pada organisasi/perusahaan milik pemerintah maupun swasta)
DESKRIPSI
- What’s New in Excel 2007
- Read of Ribbon menu
- Step by step operation for external data converting process to Excel database.
- Sort by One Level to Four Level with Sort On Values and Cells Color.
- How make and using Data Filter with Ascending or Descending method
- How make and using Quick Data Filter with create of fields combination union.
- How make and using Custom Data Filter with filter by color.
- How make and using Custom Data Filter with filter by data type (number, text, date).
- How make Advance Filter (Criteria and Output Data Query).
- How make and using Conditional Formatting Process.
- How make and using Consolidate Methods.
- How make and using Single IF conditional and Multiple IF conditional function.
- How make and using Data Validation for Onel Level and Two Level
- How make and using Data Validation Automation with Table Function.
- How make and using Data Table Method for one cell input and two cell input.
- How make and using data analysis method (What If Analysis – Goal Seek and Scenario manager).
- How make and using analysis function.
- How make active and using data analysis tool pack.
- How make active and using solver analysis tool pack.
- How make and using PivotTable
- How make and using PivotChart
- How make and design dashboard reporting
- Case study implementation
- Training evaluation
REGISTRATION :
ISIKAN FORM BERIKUT :
atau
Ketik SMS dengan format :
DAFTAR<spasi>
JUDULTRAINING#TGLTRAINING#NAMA#PERUSAHAAN#JMLHPESERTA#EMAIL#TELP.KANTOR
-kirim ke 085286451074
Contoh :
DAFTAR TRAINING FINON#2Mei2011#ARIEF#Company#3#nama@email.com#02174709591
INFORMASI TRAINING 2016 |
INFORMASI SEMINAR 2016 |
JADWAL TRAINING TAHUN 2016 |
INHOUSE TRAINING 2016 |
TRAINING INDONESIA 2016 |
TRAINING CENTER 2016
Print This Post
Email This Post