Training Agustus : Operational & Strategic Procurement ;Powerfull Database Analysis & Dashboard Reporting Program Using Ms. Excel

	MARKSHARE Training We Provide Workshop & Training Call Us : Elizia (Ms) 0821 2256 4094 / 021- 57932035 elizia@marksharetraining.co.id / laurenciaelizia@gmail.com www.marksharetraining.co.id
	Yth, Bapak / Ibu HRD Manager Training & Development Manager kami Markshare Training , ingin menginformasikan bahwa kami akan menyelenggarakan training sebagai berikut : Operational & Strategic Procurement Jakarta, 13 – 14 Agustus Confirm Running Powerfull Database Analysis & Dashboard Reporting Program Using Ms. Excel Jakarta, 23 – 24 Agustus 2018 Sasaran ·         Mampu memahami beberapa definisi, ruang lingkup dan isu seputar procurement ·         Dapat memahami best practice, tool dan teknik praktis dalam procurement dan menggunakannya baik dalam planning, eksekusi, dan analisa. ·         Mampu memahami secara umum tentang siklus procurement ·         Dapat memahami lebih mendalam tentang beberapa elemen dalam siklus procurement seperti sourcing, evaluation, negotiation, dan review. MATERI PROGRAM DAY 1 1.      Sekilas Definisi dan Lingkup: ·         Procurement vs purchasing vs sourcing ·         Organisasi Procurement ·         Peran procurement dalam Supply Chain ·         Menterjemahkan strategi perusahaan ·         Strategic vs operational procurement 2.      Issue, konsep, dan tool praktis, step-step pendekatan strategic procurement: §  Kraljic Matrix: ·         Definisi ·         Contoh ·         Procurement ·         strategi di setiap kuadran ·         latihan & studi kasus §  Buyer-Supplier relationship: ·         TCO (Total cost of ownership) ·         Single vs Sole vs Multiple Supplier ·         Make vs Buy Analysis §  Supplier Performance Criteria: ·         Balance score card, ·         SCOR model 3.      Siklus Procurement: tahap Pre-order: §  Need §  Specify §  Sourcing : ·         Supplier & Market Condition ·         Supplier Availability ·         PESTLE Analysis (Political, Economic, Socio-cultural, Technological, Legal, Environment) ·         Make or buy? ·         Existing or new source? ·         Local or global? ·         Single or multiple sources? §  Enquiry §  Evaluate: Aspek penilaian Weighting factors   DAY 2 4.      Siklus Procurement: tahap Pre-order (lanjutan): §  negotiate: ·         supplier relationship dalam negosiasi (matrix krajic dll) ·         TCO sebagai fondasi negotiation purchasing ·         Strategi konsesi sebagai jantung negosiasi purchasing §  Strategi negosiasi: §  Taktik negosiasi: ·         higher authority, good amd bad guy, walk out, russion front, dll, ·         review video and role play 5.      Siklus Procurement: tahap Order: §  Order §  Kontrak §  Progress §  Delivery 6.      Siklus Procurement: tahap Post-order: §  Pay §  Review: Mereview harga, Mereview procurement cost, Budget control, KPI: definsi, benchmark, aplikasi dan efek     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 Ag 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. 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 ! Call Us : Elizia (Ms) 0821 2256 4094 / 021- 57932035 elizia@marksharetraining.co.id / laurenciaelizia@gmail.com www.marksharetraining.co.id
	click here for unsubscribed
		JADWAL TRAINING AGUSTUS 2018

 

NO	TANGGAL	JUDUL TRAINING	LOKASI
1	6 - 7 Agt 2018	Strategic Vendor & Sourcing Management (Running)	Jakarta
2	7 - 8 Agt 2018	Best Practice Warehouse Operation Management (Running)	Jakarta
3	7 - 8 Agt 2018	Payroll System Administration (Running)	Jakarta
4	8 Agt 2018	Infographic Powerpoint	Jakarta
5	8 - 9 Agt 2018	Advanced Secretary Development Program (Running)	Jakarta
6	8 - 9 Agt 2018	Financial Statement Analysis	Jakarta
7	8 - 9 Agt 2018	Negotiation Skill For HR Executive (Running)	Jakarta
8	8 - 9 Agt 2018	Productivity & Effective Time Management	Jakarta
9	9 - 10 Agt 2018	Creative Cashflow & Treasury Management (Running)	Jakarta
10	9 - 10 Agt 2018	Effective Technical Report Writing	Jakarta
11	9 - 10 Agt 2018	Workload Analysis: Implementation with Ms. Excel For HR & Non HR	Jakarta
12	9 – 10 Agt 2018	Compensation & Benefits (Running)	Bandung
13	9 - 10 Agt 2018	Training Needs Analysis	Jakarta
14	13 - 14 Agt 2018	Operational & Strategic Procurement (Running)	Jakarta
15	13 - 14 Agt 2018	Effective Communication & Interpersonal Skills (Running)	Jakarta
16	13 - 14 Agt 2018	Integrated Procurement Management	Jakarta
17	13 - 14 Agt 2018	Managing Office & Filing System	Jakarta
18	13 - 14 Agt 2018	Creative managing Inhouse magazine skills	Jakarta
19	13 - 14 Agt 2018	Basic Marketing & Customer Relationship Management	Jakarta
20	14 - 15 Agt 2018	The 7 Selling Step : Total Selling Basic (Running)	Jakarta
21	14-15 Agt 2018	Pelatihan Jurnalistik untuk Website Perusahaan	Jakarta
22	15 - 16 Agt 2018	Succesfully Managing People (Running)	Bali
23	20 - 21 Agt 2018	Electronic Filing Management Development Program (Running)	Jakarta
24	20 - 21 Agt 2018	Procurement Negotiation & Contracting Strategy	Jakarta
25	20 - 21 Agt 2018	Metode Penyusunan Spesifikasi & Harga Perkiraan Sendiri	Jakarta
26	23 - 24 Agt 2018	Powerfull Database Analysis & Dashboard Reporting Using Ms. Excel (Running)	Jakarta
27	23 - 24 Agt 2018	Budgeting Profit Planning & Cost Control (Running)	Jakarta
28	23 - 24 Agt 2018	Project Management Using Ms. Project Application (Running)	Jakarta
29	23 - 24 Agt 2018	Managing Difficult Customer & Handling Complaint Professionaly	Bandung
30	27 - 28 Agt 2018	Compensation & Benefits (Running)	Jakarta
31	27 - 28 Agt 2018	Effective General Affair Management (Running)	Jakarta
32	27-28 Agt 2018	Key Performance Indicator with Balance Scorecard	Jakarta
33	27 - 28 Agt 2018	Account Receivable & Collection Management	Jakarta
34	28 - 29  Agt 2018	Public Relation Management (Running)	Jakarta
35	29 - 30 Agt 2018	Effective Business Communication & Business Ettiquette	Jakarta
36	30-31 Agt 2018	Training for Trainer (Running)	Jakarta
37	30-31 Agt 2018	Conflict & Stress Management	Jakarta
38	30 - 31 Agt 2018	Problem Solving & Decision Making	Jakarta
39	30 - 31 Agt 2018	Good Corporate Governance Implementation	Jakarta
40	30 - 31 Agt 2018	Business Development & Marketing Strategy	Jakarta