POWERFUL DATABASE ANALYSIS AND DASHBOARD REPORTING WITH EXCEL 2007 – YOGYAKARTA

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

1. What’s New in Excel 2007
2. Read of Ribbon menu
3. Step by step operation for external data converting process to Excel database.
4. Sort by One Level to Four Level with Sort On Values and Cells Color.
5. How make and using Data Filter with Ascending or Descending method
6. How make and using Quick Data Filter with create of fields combination union.
7. How make and using Custom Data Filter with filter by color.
8. How make and using Custom Data Filter with filter by data type (number, text, date).
9. How make Advance Filter (Criteria and Output Data Query).
10. How make and using Conditional Formatting Process.
11. How make and using Consolidate Methods.
12. How make and using Single IF conditional and Multiple IF conditional function.
13. How make and using Data Validation for Onel Level and Two Level
14. How make and using Data Validation Automation with Table Function.
15. How make and using Data Table Method for one cell input and two cell input.
16. How make and using data analysis method (What If Analysis – Goal Seek and Scenario manager).
17. How make and using analysis function.
18. How make active and using data analysis tool pack.
19. How make active and using solver analysis tool pack.
20. How make and using PivotTable
21. How make and using PivotChart
22. How make and design dashboard reporting
23. Case study implementation
24. 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