MARKSHARE Training We Provide Workshop & Training POWERFULL DATABASE ANALYSIS & DASHBOARD REPORTING USING MS. EXCEL Hotel Oria - Jakarta, 07 - 08 Desember 2016 Confirm RunningCall Us : Eby (Ms.) Mobile: 0856 1044 530 E-mail : e...@marksharetraining.co.id eby.marksh...@gmail.com click here to unsubscribe
Sasaran Pelatihan : Setelah mengikuti pelatihan ini peserta diharapkan mampu untuk : 1. Membaca dan memasukkan berbagai macam data : text file dan database yang lain yang jumlah record lebih dari 100.000 record ke dalam Excel 2007/2010 2. Melakukan proses validasi data hasil konvert, baik untuk data text, date dan number. 3. Melakukan proses logical data dengan single IF dan multiple IF conditional function. 4. Melakukan quick filter dengan kombinasi gabungan key fields. 5. Melakukan custom filter dan Advance Filter (Query with Criteria). 6. Membuat tampilan dan formulasi dashboard reporting yang menarik dan dapat dijalankan secara interaktif oleh user. 7. Memanfaatkan fungsi-fungsi Excel untuk berbagai macam kebutuhan analisa database. 8. Mengaktifkan solver analysis tool pack dalam tab menu. 9. Menggunakan tool analisa database yang ada pada data analysis tool pack untuk kebutuhan analisa database yang cukup kompleks. 10. Menggunakan tool database analysis solver yang ada pada solver analysis tool pack. Limited Seat Available Call us & Register Now 08561044530 / 5793 2035 e...@marksharetraining.co.id eby.markshare@gmail.comMateri Training : 1. What’s New in Excel 2007/2010 2. Read of Ribbon menu 3. 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. 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 PivotTable 17. How make and using PivotChart 18. How make and design dashboard reporting 19. Case study implementation Untuk topic lainnya dan In house Training, silahkan sampaikan kebutuhan dan request anda dengan cara : >> [[ Klik Disini Untuk Request Inhouse ]] << improve the quality of human resources by Inhouse training, scale UP your Business ! Click here to Unsubscribe Contact Person : Eby (ms.) Mobile: 08561044530 E-mail : e...@marksharetraining.co.id / eby.marksh...@gmail.com NOTANGGALJUDUL TRAINING 101 - 02 Desember 2016Good Corporate Governance (GCG) Implementation 205 - 06 Desember 2016Financial Statement Analysis (FSA) 305 - 06 Desember 2016Effective Negotiation & Lobyying Skills 407 - 08 Desember 2016Integrated Presentation Management 507 – 08 Desember 2016Powerfull Database Analysis & Dashboard Reporting Using Ms. Excel 2007/2010 607 - 08 Desember 2016Effective Shopfloor Leadership 707 - 08 Desember 2016Negotiation Power For Purchasing 814 - 15 Desember 2016Ms. Excel Implementation With VBA Application 914 - 15 Desember 2016Effective Office Management With Kaizen 5S & Filing System 1014 - 15 Desember 2016Problem Solving & Decision Making 1122 - 23 Desember 2016Advanced Secretary Development Program 1222 – 23 Desember 2016Memahami Letter of Credit (L/C) Export Import 1322 - 23 Desember 2016Metode Penyusunan Spesifikasi & Harga Perkiraan Sendiri 1427 - 28 Desember 2016Effective Sparepart Management 1527 - 28 Desember 2016Electronic Filing Implementation With RMS & EFS Method Based on Document Regulation 1627 - 28 Desember 2016Creative Thinking Training 1727 - 28 Desember 2016Accurate Inventory Planning & Stock Control Eby A. Marischa Phone : 021 – 5793 2035 Mobile : 0856 1044 530 e...@marksharetraining.co.id / eby.marksh...@gmail.com Marketing Executive & Program Consulltant Markshare Training – People Development Gedung STC Senayan, Lantai 4 No. 1055 - 1056 Jl. Asia Afrika Pintu IX Senayan – Gelora, Tanah Abang Jakarta Pusat 10270