Confirm Running : (1) Best Practice Warehouse Management (2) Powerfull Database Analysis With Ms. Excel : Confirm Running

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

 

NO	TANGGAL	JUDUL TRAINING	LOKASI
1	01 - 02 Maret	Technical Report Writing	Jakarta
2	01 - 02 Maret	Financial Statement Analysis	Jakarta
3	01 - 02 Maret	Stress Management	Jakarta
4	05 - 06 Maret	HR Management	Jakarta
5	05 - 06 Maret	Integrated Presentation Management	Jakarta
6	05 - 06 Maret	Competency Based Performance Appraisal System	Jakarta
7	07 - 08 Maret	Comprehensive Basic Accounting for Executive	Jakarta
8	07 - 08 Maret	Advanced Secretary Development Program	Jakarta
9	08 - 09 Maret	Effective Communication & Interpersonal Skill	Jakarta
10	08 - 09 Maret	Applied Finance For Non Finance	Jakarta
11	08 - 09 Maret	General Affairs Management Development Program	Jakarta
12	08 - 09 Maret	Budata Etika dalam Organisasi	Jakarta
13	12 - 13 Maret	Supply Chain Management	Jakarta
14	12 - 13 Maret	Public Relation In Changing Era	Jakarta
15	12 - 13 Maret	HR for Non HR Management	Jakarta
16	12 - 13 Maret	Public Speaking for Executive	Jakarta
17	13 - 14 Maret	Business Plan, Cost Control & Budgeting Planning	Jakarta
18	13 - 14 Maret	Managing Office & Filing System	Jakarta
19	14 - 15 Maret	Handling Complain & Difficult Customer	Jakarta
20	14 - 15 Maret	Negotiating Power for Procurement	Jakarta
21	15 - 16 Maret	Integrated Procurement Management	Jakarta
22	15 - 16 Maret	Increasing Employee Engagement	Jakarta
23	15 - 16 Maret	The 7 Selling Steps For Sales People	Jakarta
24	15 - 16 Maret	Creative Cashflow & Treasury Management	Jakarta
25	15 - 16 Maret	Leadership for Sales Manager	Jakarta
26	19 - 20 Maret	Productivity & Effective Time Management	Jakarta
27	19 - 20 Maret	Contract Tender in Procurement	Jakarta
28	19 - 20 Maret	Effective Supervisory Skill: Menjadi Supervisor Unggul	Jakarta
29	19 - 20 Maret	Successfully Managing People "An Essential Leadership & Managerial Skills"	Jakarta
30	20 - 21 Maret	Kiat Menyusun SOP Menggunakan KPI	Jakarta
31	21 - 22 Maret	Powerful Data Analysis & Reporting with MS excel	Jakarta
32	22 - 23 Maret	Problem Solving & Continuous Improvement With PDCA & QC Tools	Jakarta
33	22 - 23 Maret	Knowledge Management	Jakarta
34	22 - 23 Maret	Lobbying & Negotiation Skill	Jakarta
35	26 - 27 Maret	Basic Marketing & CRM Management	Jakarta
36	26 - 27 Maret	Excellence Automation Data Processing With Macro & VBA Excel 2007/2010	Jakarta
37	26 - 27 Maret	Know Your Customer (KYC) & Anti Money Laundering	Jakarta
38	26 - 27 Maret	Tax Planning & Management	Jakarta
39	27 - 28 Maret	Corporate Journalism	Jakarta
40	27 - 28 Maret	New Product Development	Jakarta
41	27 - 28 Maret	Advanced Service Excellence	Jakarta
42	28 - 29 Maret	Recruitment & Selection Management	Jakarta
43	28 - 29 Maret	Good Corporate Governance Implementation (GCG)	Jakarta
44	28 - 29 Maret	Negotiation Power for Purchasing	Jakarta
45	28 - 29 Maret	Basic Enterprise Risk Management	Jakarta
46	28 - 29 Maret	Effective & Comprehensive Training Need Analysis	Jakarta
LUAR KOTA
1	01 - 02 Maret	Metode Penyusunan Spesifikasi & Harga Perkiraan Sendiri (HPS / Owner Estimate)	Bandung
2	08 - 09 Maret	Best Practice Warehouse Management	Bandung
3	15 - 16 Maret	Strategic Sourcing & Vendor Management	Bandung
4	22 - 23 Maret	Effective Communication & Interpersonal Skill	Yogyakarta
5	28 – 29 Maret	Successfully Managing People "An Essential Leadership & Managerial Skills"	Bali
6	29 Maret	Powerpoint Do More	Bali