Public Course : Best Practice Warehouse Management ; Powerfull Database Analysis & Dashboard Reporting Using Ms. Excel

MARKSHARE Training We Provide Workshop & Training

Yth, Bapak / Ibu HRD Manager Training & Development Manager kami Markshare Training , ingin menginformasikan bahwa kami akan menyelenggarakan training sebagai berikut : Best Practice Warehouse Management Jadwal : 12 – 13 Februari 2018 At Ibis Hotel - Jakarta Powerfull Database Analysis & Dashboard Reporting Using Ms. Excel Jadwal : 14 – 15 Februari 2018 At Ibis Hotel - Jakarta Operasional di Warehouse memiliki pola aktifitas yang berbeda berdasarkan; kompleksitas inventory, produk, & kategori industry. Selain itu dinamika tekhnologi & konsep terkini supply chain management sangat berpengaruh terhadap cara kita mengelola warehouse secara efektif, efisien, terukur, & akuntabel.      OUTLINE PELATIHAN HARI PERTAMA 1.        Warehouse Manual, Procedures, & WMS 2.        Inventory Management 3.        Industrial Packaging & Material Handling 4.        Warehouse Lay-Out & Stock Locations 5.        Case study & discussion sharing HARI KEDUA  6.        Receiving, Inspection, & Order Handling 7.        QHSSE in the Warehouse  8.        Warehouse KPI & Audit 9.        Lean Warehousing 10.    Case study & closing review     OBJECTIVES 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. SYLLABUS 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 !   Untuk Informasi lebih lanjut, pendaftaran, dan lain lain :   Eby A. Marischa Phone  : 021 – 5793 2035 Mobile : 0856 1044 530 (call, sms, Whatsapp) eby@marksharetraining.co.id / eby.markshare@gmail.com Marketing Executive & Program Consulltant

 

Jadwal Training Lainnya :

 

No	Tanggal	Judul Training	Lokasi
1	6 - 7 Feb	Basic HR Management	Jakarta
2	8 - 9 Feb	Managing Office & Filling System	Jakarta
3	8 - 9 Feb	General Affairs Management Development Program	Jakarta
4	8 - 9 Feb	Applied Finance For Non Finance	Jakarta
5	12 - 13 Feb	Best Practice Warehouse Management	Jakarta
6	12 - 13 Feb	Technical Report Writing	Jakarta
7	12-13 Feb	Stress Management	Jakarta
8	12 - 13 Feb	The 7 Step Selling for Sales People	Jakarta
9	12 - 13 Feb	Effective Public Relation	Jakarta
10	14 - 15 Feb	Handling Complain & Difficult Customer	Jakarta
11	14 - 15 Feb	Business Plan, Cost Control & Budgeting Planning	Jakarta
12	14 - 15 Feb	Customer Service for Hospital	Jakarta
13	14 - 15 Feb	Powerfull Database Analysis & Dashboard Reporting Using Ms. Excel	Jakarta
14	15 - 16 Feb	Corporate Journalism	Jakarta
15	19 - 20 Feb	Negotiation Power For Procurement	Jakarta
16	19 - 20 Feb	Problem Solving & Continuous Improvement With PDCA & 7QC Tools	Jakarta
17	19 - 20 Feb	Effective Communication & Interpersonal Skill	Jakarta
18	19 - 20 Feb	Planning & Inventory Control	Jakarta
19	19 - 20 Feb	Supply Chain Management	Jakarta
20	20 - 21 Feb	Motivating & Empowering : Business Culture dan Etos Kerja	Jakarta
21	20 - 21 Feb	Coaching & Counseling	Jakarta
22	21 - 22 Feb	Amazing Presentation With Powerpoint 2007/2010, SWISHMAX And ULEAD	jakarta
23	21 - 22 Feb	Business Etiquette & Protokoler	Jakarta
24	22 - 23 Feb	Workload Analysis Implementation With Ms. Excel 2007/2010/2013 For HR & Non HR	Jakarta
25	22 - 23 Feb	Establishing Advanced Service Excellent	Jakarta
26	22 - 23 Feb	Effective Time & Activity Management	Jakarta
27	26 - 27 Feb	Comprehensive Basic Accounting for Executive	Jakarta
28	26 - 27 Feb	Basic Managing Performance for Manager	Jakarta
29	26 - 27 Feb	Career & Talent Management	Jakarta
30	26 - 27 Feb	Excellence Automation Data Processing With Macro And Visual Basic Application Excel 2007/2010	Jakarta
31	27 - 28 Feb	Kepemimpinan Situasional untuk Sales Leader	Jakarta
32	27 - 28 Feb	Effective Negotiation & Lobbying Skill	Jakarta
33	27 - 28 Feb	Project management Using Ms. Project Application	Jakarta
34	27 - 28 Feb	New Product Development (NPD)	Jakarta
Jadwal Luar Kota
1	7 - 8 Feb	Effective Negotiation & Lobbying Skills	Bali
2	7 - 8 Feb	Managing People "Leadership & Managerial Skills For Supervisor & Manager"	Bali
3	7 - 8 Feb	Advanced Secretary Development Program	Bali
4	15 - 16 Feb	Metode Penyusunan Spesifikasi & Harga Perkiraan Sendiri	Bandung
5	22 - 23 Feb	Financial Statement Analysis	Bandung
6	22 - 23 Feb	Progress to Successfull Supervisors "A Supervisory Leadership Workshop"	Yogyakarta