MARKSHARE Training We Provide Workshop & Training Powerfull Database Analysis & Dashboard Reporting Using Ms. Excel Jakarta, 24 – 25 Oktober 2016Call Us : Eby (Ms.) Mobile: 0856 1044 530 E-mail : e...@marksharetraining.co.id eby.marksh...@gmail.com click here to unsubscribe
Yth, Bapak / Ibu HRD Manager Training & Development Manager kami Markshare Training , ingin menginformasikan bahwa kami akan menyelenggarakan training teknik analisis & pengelolaan database serta pelaporannya dengan menggunakan Ms. Excel dengan fitur – fitu menarik, yang telah kami kemas sebagai berikut : POWERFULL DATABASE ANALYSIS & DASHBOARD REPORTING USING MS. EXCEL 2007/2010 Setelah training, peserta akan mampu : 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.Materi 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 Other Following Schedule : JADWAL TRAINING OKTOBER 2016 710 - 11 OktoberElectronic Filing Implementation With RMS & EFS Method Based on Document Regulation 813 OktoberEvolution of Documents ISO 9000 (1987 - 2015) 913 - 14 OktoberDesigning Key Performance Indocators (KPI) With Balance Scorecard 1013 - 14 OktoberAccurate Inventory Planning & Stock Control 1220 - 21 OktoberSharpening Management Skills For Warehouse Supervisor 1320 – 21 OktoberProcurement Negotiation & Contracting Strategy Bandung 1424 - 25 OktoberPowerfull Database Analysis & Dashboard Reporting Using Ms. Excel 1524 - 25 OktoberMastering Ms. Excel 2010 For Office Data Processing System 1631 Oktober – 01 NopEffective Shopfloor Leadership 1727 - 28 OktoberBasic Marketing & CRM TRAINING LUAR KOTA 120 - 21 OktoberBandung : Best Practice Procurement & Purchasing Management 220 - 21 OktoberBandung : Strategic Sourcing & Vendor Management 327 - 28 OktoberYogyakarta : Powerfull Database Analysis & Dashboard Reporting Using Ms. Excel 2007/2010 427 - 28 OktoberSurabaya : Payroll Management System Implementation With Ms. Excel, Overtime Calculation & PPH 21 527 - 28 OktoberBali : Advanced Secretary Development Program 627 - 28 OktoberBali : Modern Office JADWAL TRAINING NOVEMBER 2016 NOTANGGALJUDUL TRAININGKOTA 101 - 02 NovemberElectronic Filing Implementation With RMS & EFS Method Based on Document RegulationJakarta 203 - 04 NovemberCorporate JournalismJakarta 307 - 08 NovemberClinic of Essential Ms. Excel For Office Data Processing SystemJakarta 408 NovemberInfographic With PowerpointJakarta 510 - 11 NovemberComprehensive Basic Accounting For ExecutiveJakarta 610 - 11 NovemberProfessional Debt Collection SkillsJakarta 714 - 15 NovemberEffective Sparepart ManagementJakarta 817 - 18 NovemberTechnical Report WritingJakarta 917 - 18 NovemberPayroll Management SystemJakarta 1021 - 22 NovemberBest Practice Warehouse Operation ManagementJakarta 1123 - 24 NovemberTraining Need AnalysisJakarta 1223 - 24 NovemberTotal Selling " An Effective Basic Sales Program"Jakarta 1325 - 25 NovemberEffective Communication & Interpersonal SkillsJakarta 1424 - 25 NovemberTechnical Report WritingJakarta 1528 - 29 NovemberAdvanced Secretary Development ProgramJakarta 1628 - 29 NovemberProfessional General Affairs Management Development ProgramJakarta 1729 - 30 NovemberEffective Shopfloor LeadershipJakarta 1829 - 30 NovemberTotal Productivity Maintenance (TPM)Jakarta LUAR KOTA NOTANGGALJUDUL TRAININGKOTA 117 - 18 NovemberGood Corporate GovernanceBali 217 - 18 NovemberProcurement Negotiation & Contracting StrategyBandung 318 - 18 NovemberManaging Office & Filing SystemYogyakarta 424 - 25 NovemberAdvanced Secretary Development ProgramBali 524 - 25 NovemberEffective Negotiation & Lobbying SkillsBali 624 - 25 NovemberMetode Penyusunan Spesifikasi & Harga Perkiraan SendiriBandung 729 - 30 NovemberTechnical Report WritingYogyakarta