Public Course : Best Practice Warehouse Management ; Mastering Ms. Excel 2007/2010/2013 For Office data Processing System

MARKSHARE Training We Provide Workshop & Training   Call Us : Eby (Ms.) 08561044530 / 021 – 5793 2035 eby@marksharetraining.co.id / eby.markshare@gmail.com / ask@marksharetraining.co.id www.marksharetraining.co.id for unsubscribe, click here
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 : Jakarta, 11 – 12 April 2018 Mastering Ms. Excel 2007/2010/2013 For Office data Processing System Jadwal : Jakarta, 5 – 6 April 2018  Outline Training : 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  1.      Receiving, Inspection, & Order Handling 2.      QHSSE in the Warehouse  3.      Warehouse KPI & Audit 4.      Lean Warehousing 5.      Case study & closing review     TUJUAN & MANFAAT PELATIHAN Setelah mengikuti pelatihan ini, peserta akan memiliki kemampuan untuk: 1.        Memahami konsep terbaru & terkini warehouse management  2.        Memahami prinsip & konsep  improvement dalam pengelolaan warehouse 3.        Memahami metode improvement process dalam pengelolaan warehouse 4.        Update konsep, best practice, & teknologi terkini  5.        Membuat & merevisi metode evaluasi kinerja yang efektif, efisien, terukur, & akuntabel     SYLLABUS 1.      Numeric data processing with using cell absolute address. 2.      Text  data processing with string function 3.      Combination of Date function with String function. 4.      Implementation numeric function for calculation process to Day and Tomorrow 5.      How using of Remove Duplicates tools. 6.      How using of Conditional Formatting tools. 7.      How using of Consolidate tools. 8.      How using of Auto Filter Optimization 9.      How using of Advance Filter Optimization 10.  Validation and date data processing from text format to historical date transaction. 11.  Understanding and implementation of sheet data master and sheet data transactions. 12.  How using of Data Sort tools. 13.  How using of VLOOKUP() function for table data retrieval processing. 14.  How using of HLOOKUP()function for table data retrieval processing. 15.  How using of VLOOKUP() advance for multiple table data retrieval processing. 16.  How using of IF() Logic function. 17.  How using of Multiple IF() Logic function. 18.  How using of AND Logic Operator. 19.  How using of PivotTable tools. 20.  Created and design Cells Graphic with using Spark Lines 21.  How make and using PivotChart Optimation with Slicers Panel 22.  How using of Data Validation method. 23.  How using of file Excel Add in Macro (*.XLAM). 24.  Understanding of Visual Basic Application Fundamentals (Macro). 25.  How using of Format Cells for Locked and Hidden Cells 26.  How using of Using Allow Users to Edit Range ( Permission User Access Setting ) 27.   How using of Protect Sheet ( Select Locked Cells and Select Unlocked Cells ) 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 !

Jadwal Maret 2018

 

NO	TANGGAL	JUDUL TRAINING	LOKASI
1	13 – 14 Maret	Managing Office With 5S & Filing System	Jakarta
2	15 - 16 Maret	Leadership for Sales Manager	Jakarta
3	15 – 16 Maret	Integrated Procurement Management	Jakarta
4	15 – 16 Maret	Applied Finance For Non Finance Executive	Jakarta
5	15 – 16 Maret	General Affairs Management Development Program	Jakarta
6	15 – 16 Maret	Effective Technical Report Writing Skills	Jakarta
7	19 - 20 Maret	HR for Non HR Management	Jakarta
8	19 - 20 Maret	Basic HR Management	Jakarta
9	19 - 20 Maret	Comprehensive Supervisory Skill	Jakarta
10	19 - 20 Maret	Successfully Managing People "An Essential Leadership & Managerial Skills"	Jakarta
11	20 - 21 Maret	Kiat Menyusun SOP Menggunakan KPI	Jakarta
12	22 - 23 Maret	Productivity & Effective Time Management	Jakarta
13	22 - 23 Maret	Lobbying & Negotiation Skill	Jakarta
14	22 - 23 Maret	Effective & Comprehensive Training Need Analysis	Jakarta
15	22 - 23 Maret	Stress Management	Jakarta
16	26 - 27 Maret	Electronic Filing System Implementation Based On Document Regulation And Rms – Efs Method With Excel 2007/2010/2013/2015/2016	Jakarta
17	27 - 28 Maret	Corporate Journalism	Jakarta
18	28 - 29 Maret	Effective Communication & Interpersonal Skill	Jakarta

 

April 2018

 

NO	TANGGAL	JUDUL TRAINING	LOKASI
1	12 - 13 April	Tax Management	Jakarta
2	3 April	Powerpoint Do More	Jakarta
3	4 - 5 April	Constructing Business Plan & Feassibility Study	Jakarta
4	5 - 6 April	Successfully Managing People " An Essential Leadership & Managerial Skills"	Bali
5	5 - 6 April	Mastering Ms. Excel 2007/2010/2013 For Office data Processing System	Jakarta
6	5 – 6 April	Workload Analysis Implementation with EXCEL 2007 FOR HR & NON HR	Jakarta
7	9 - 10 April	Business Etiket & Protokoler	Jakarta
8	9 – 10 April	The 7 Steps Selling Steps for Sales People	Jakarta
9	9 - 10 April	Advanced Service Excellence	Jakarta
10	9 - 10 April	Tax Planning & Management	Jakarta
11	11 - 12 April	Powerfull Database Analysis & Dashboard Reporting with ms. Excel 2007 / 2010	Jakarta
12	11 – 12 April	Budget Modelling Using MS. EXCELL	Jakarta
13	11 – 12 April	Discipline, Motivating & Developing People	Jakarta
14	11 - 12 April	Finansial Statement Analysis ( FSA )	Jakarta
15	11 - 12 April	Best Practice Warehouse management	Jakarta
16	12 - 13 April	Procurement negotiation & Contracting Strategy	bandung
17	12 - 13 April	Ecellent Automation Data Processing With Macro & Visual Basic Application Excel 2007/2010/2013/2015	Bandung
18	16 - 17 April	Increasing Employee Engagement	Jakarta
19	16 - 17 April	Payroll Management System With Ms. Excel	Surabaya
20	16 – 17 April	Effective Time & Activity Management	Jakarta
21	16 – 17 April	Basic Relationship Management for Leaders	Jakarta
22	16 – 17 April	Negotiation Skill for Purchasing	Jakarta
23	16 - 17 April	General Affairs Management Development Program	Jakarta
24	17 - 18 April	Persiapan Masa Pensiun	Jakarta
25	18 – 19 April	Insight Selling	Jakarta
26	19 - 20 April	New Product Development	Bandung
27	19 - 20 April	Public Speaking & Presentation Skills	Jakarta
28	19 - 20 April	Risk Management	Jakarta
29	19 - 20 April	Successfully Managing People " An Essential Leadership & Managerial Skills"	Jakarta
30	23 - 24 April	Good Corporate Governance ( GCG ) Implementation	Jakarta
31	23 - 24 April	Metode Penyusunan Spesifikasi & HPS	Jakarta
32	23 - 24 April	Leadership For Sales ; Lead Well Sell Better	Jakarta
33	23 – 24 April	Warehouse Best Practice	Jakarta
34	23 – 24 April	Strategic Vendor Management	Jakarta
35	24 - 25 April	Electronic Filing System Implementation Based On Document Regulation And Rms – Efs Method With Excel 2007/2010/2013/2015/2016	Jakarta
36	24 - 25 April	Corporate Journalism ; How to Treat Corporate Website, Magazine & Media Handling	Jakarta
37	24 - 25 April	Carreer & Talent Management	Jakarta
38	24 - 25 April	Technical Report Writing	Jakarta
39	25 – 26 April	Train to The Trainer	Jakarta
40	25 – 26 April	Ice Breaking for PR & Presenter	Jakarta
41	26 - 27 April	Logical Thinking & Problem Solving	Jakarta
42	26 - 27 April	Contract & Tender in Procurement	Jakarta
43	26 – 27 April	Advanced Selling Skill for Maximum Profit	Jakarta
44	26 – 27 April	Effective Supervisory Skill	Jakarta
45	26 - 27 April	Creative Cashflow & Treasury Management	Jakarta
46	26 - 27 April	Project Management Using Ms. Project Application	Jakarta
47	26 - 27 April	Comprehensive Industrial Relation	Jakarta