PelatihanPelatihan DuaDua HariHari

Powerfull Database Analysis and Dashboard Reporting with Excel

Center for Productivity & Quality Excellence

JakartaJakarta -- 20120155

KAIZEN CONSULTINGKAIZEN CONSULTING

KAIZEN CONSULTING

…….. Adalah sub bisnis unit (SBU) dari PT Kaizen Global Solusi yang bergerak dalam bidang

pelatihan, konsultansi, penelitian dengan fokus pada peningkatan performance perusahaan.

Center for Productivity & Quality Excellence

INTEGRATED MANAGEMENT SERVICES

• Customized In-house Training

• Public Training and Workshops

• Implementation Consultancy

• Management Seminars & Conferences

• Training and Educational Materials

Center for Productivity & Quality Excellence

• Training and Educational Materials

MAIN AREAS of SPECIALIZATION

• Productivity Improvement Strategy

• Quality Improvement & Six Sigma

• Supply Chain & Logistic Management

• Productivity & Quality Management

Center for Productivity & Quality Excellence

• Lean Manufacturing Implementation

• Shopfloor Improvement & People Development

Facilitator : Erawan Supriyatna, S. Kom• Praktisi dan trainer yang mempunyai pengalaman lebih dari 17 tahun menjadi

instructor / trainer di beberapa lembaga pelatihan swasta, instansi pemerintah / swasta di Jakarta, mulai tahun 1992 - sekarang, antara lain di PT. Asiana IMI Industries, Tbk., PT. COMBIPHAR, di PT. LG Philips Display Devices Indonesia, PT. LG Electronics Indonesia, PT. LG Innotek Indonesia dan PT. Harita Prima Abadi Mineral (Mining Company).

• Pernah menjabat sebagai Manager Training dan Development di perusahaan swasta dan perusahaan jasa konsultan. Jabatan terakhir adalah sebagai Direktur Training & Development di perusahaan swasta training and consulting. Sekarang beliau menjadi Trainer dan consultant di beberapa perusahaan provider training and consulting.

• Selain tema pelatihan tersebut di atas, beliau juga memberikan pelatihan IT sebagai berikut :

Center for Productivity & Quality Excellence

sebagai berikut :Excellent Telephone Technique And Ethics, Training For Trainer, Effective Managerial Skill, Excellent Leadership Skill, Modern Office Administration for Leader and Staff, General Affair Officer Development Program, Training Needs Analysis.

• Selain itu juga beliau adalah praktisi pelatihan dengan metode quantum teaching, quantum learning, mind mapping dan NLP di bagian pengembangan sumber daya manusia (HRD Training & Development) selama lebih dari 7 tahun. Dengan perpaduan metode pelatihan seperti itulah, pelatihan seberat apapun selalu dibawakan secara ringan, jelas dan tuntas. Sehingga proses pelatihan berlangsung dengan menyenangkan dan mencapai tujuan yang diinginkan oleh peserta pelatihan.

GARIS BESAR PROGRAM1. What’s New in Excel 20072. Read of Ribbon menu3. Step by step operation for external data converting process to Excel database.4. How make and using Quick Data Filter with create of fields combination union.5. How make and using Custom Data Filter with filter by data type (number, text, date).6. How make Advance Filter (Criteria and Output Data Query).7. How make and using Conditional Formatting Process.8. How make and using Consolidate Methods.9. How make and using Single IF conditional and Multiple IF conditional function.10. How make and using Data Validation for One Level and Two Level

Center for Productivity & Quality Excellence

11. How make and using Data Validation Automation with Table Function.12. How make and using Data Table Method for one cell input and two cell input.13. How make and using data analysis method (What If Analysis – Goal Seek and Scenario

manager).14. How make and using analysis function.15. How make active and using solver analysis tool pack.16. How make and using PivotTable17. How make and using PivotChart18. How make and design dashboard reporting19. Case study implementation