Confirm Running (1) PPIC Training (2) Powerfull Database Analysis With MS. Excel Dashboard Report

	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 : Production Planning & Inventory Control (PPIC) Training Jakarta, 26 - 27 November 2018 POWERFUL DATABASE ANALYSIS AND DASHBOARD REPORTING WITH EXCEL  Jakarta, 29 - 30 November 2018 Tujuan PELATIHAN Memahami konsep MPC secara keseluruhan Memahami konsep dan peran setiap elemen MPC seperti Business Planning, Sales & Operation Planning (S&OP), Master Production Schedule (MPS), Material Requirement Planning (MRP), eksekusi planning berupa Production Activity Control (PAC) dan Purchasing, dan Capacity Planning. Memahami step by step elemen MPC dan keterkaitan antar masing2 elemen. Menerapkan system MPC dalam lingkungan perusahaan / industri yg berbeda-beda OUTLINE 1. Business plan / Perencanaan bisnis strategis: ·         Strategic ·         Marketing ·         Finance ·         Operation 2. S&OP (Sales & Operation Planning): ·         Fungsi ·         Step-step ·         Format, dll 3. MPS (Master Production Schedule) / Jadwal Produksi Utama: ·         Fungsi dan tujuan ·         Input, output, proses. ·         Format, dll 4. MRP (Material Requirement Planning) / Perencanaan Kebutuhan Material ·         Objektif. ·         Proses, input, dan output. ·         Bill of Material 5. Ekseskusi: PAC (Production Activity Control) dan Purchasing Capacity Planning / Perencanaan Kapasitas ·         Resource Planning (RP) ·         Rough-Cut Capacity Planning (RCCP) ·         Capacity Requirements Planning (CRP)     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 1.       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 ! 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 NOVEMBER - DESEMBER 2018

 

 

 

 

NO	TGL	JUDUL TRAINING	LOKASI
NOVEMBER
1	1-Nov	Powerfull of Sales Data Analysis & Dashboard Report With Advanced Excel 2010	Jakarta
2	5 - 6 Nov	Financial Statement Analysis	Jakarta
3	05 - 06 Nov	Teknik Penyusunan SOP Menggunakan KPI	Jakarta
4	6 - 7 Nov	Mastering Excel 2007/2010 Beyond For Office Data processing System	Jakarta
5	6 - 7 Nov	Human Resources Development Program (HRMDP)	Jakarta
6	07 - 08 Nov	Problem Solving & Decision Making	Jakarta
7	8-Nov	Infographic Powerpoint	Jakarta
8	8 - 9 Nov	Corporate Journalism	Jakarta
9	8 - 9 Nov	Professional General Affair Management	Jakarta
10	8 - 9 Nov	Effective Interpersonal Communication	Jakarta
11	08 - 09 Nov	Struktur Penyusunan Skala Upah (Compensation & Benefits)	Jakarta
12	12 - 13 Nov	Effective Time Management & Delegation	Jakarta
13	12 - 13 Nov	Smart Plan Project Management using Ms. Project Application	Jakarta
14	13 - 14 Nov	Comprehensive Supervisory Skills	Jakarta
15	13 - 14 Nov	Budgeting profit Planning & Cost Control	Jakarta
16	14 - 15 Nov	Business Development & Marketing Strategy	Jakarta
17	15 - 16 Nov	Payroll Management System	jakarta
18	15 - 16 Nov	The 7 Selling Step : Total Selling Basic	Jakarta
19	15 - 16 Nov	Public Speaking & Presentation Skill	Jakarta
20	15 - 16 Nov	Advanced Secretary Development Program	Jakarta
21	15 - 16 Nov	Increasing Employee Engagement	Jakarta
22	15 - 16 Nov	Negotiation Skill For HR Staff	Jakarta
23	15 - 16 Nov	Applied Finance For Non Finance	Jakarta
24	21 - 22 Nov	Workload Analysis Implementation With Ms. Excel For HR & Non HR	Jakarta
25	21 - 22 Nov	Tax Planning Management	Jakarta
26	21 - 22 Nov	Effective Office Management With Kaizen 5S & Filing System	Jakarta
27	21 - 22 Nov	Customer Relation Management	Jakarta
28	21 - 22  Nov	Operational & Strategic Procurement	Jakarta
29	22 - 23 Nov	Metode Penyusunan Harga Perkiraan Sendiri ( HPS )	Bandung
30	22 - 23 Nov	Negotiation Power For Purchasing	Jakarta
31	22 - 23 Nov	Advanced Secretary Development Program	Bandung
32	22 - 23 Nov	Effective Interpersonal Communication	Bandung
33	22 - 23 Nov	Total Selling : Powerful Strategy Selling	Jakarta
34	22 - 23 Nov	Logistics & Supply Chain Management	Jakarta
35	26 - 27 Nov	Purchasing & Procurement Management	Jakarta
36	26 - 27 Nov	Financial Modeling	Jakarta
37	26 - 27 Nov	Managing Account Payable and Receivable	Jakarta
38	26 - 27 Nov	Accurate inventory planning and stock control	Jakarta
39	28 - 29 Nov	Training PDCA ( Plan - DO - Check - Action)	Jakarta
40	28 - 29 Nov	Struktur Penyusunan Skala Upah (Compensation & Benefits)	Bali
41	29 - 30 Nov	Powerfull Database Analysis & Dashboard Reporting with ms. Excel 2007 / 2010	Jakarta
42	29 - 30 Nov	Effective Negotiation & Lobbying Skill	Bali
43	29 - 30 Nov	Advanced Secretary Development Program	Bali
44	29 - 30 Nov	Public Relation Management	Bali
45	29 - 30 Nov	Leadership & Managerial Skills	Bali
Desember
1	3 - 4 Des	Business Plan	Jakarta
2	3 - 4 Des	Best Practice Warehouse Management	Jakarta
3	03 - 04 Des	Effective Public Relation Management	Jakarta
4	03 - 04 Des	Struktur Penyusunan Skala Upah (Compensation & Benefits)	Jakarta
5	04 - 05 Des	Negotiation & Lobbying skill	Jakarta
6	04 - 05 Des	Creative & Analytical Thinking	Jakarta
7	6 - 7 Des	Finance For Non Finance	Jakarta
8	06 - 07 Des	Negotiation Skill For HR Staff	Jakarta
9	06 - 07 Des	Basic marketing & CRM Management	Jakarta
10	10 - 11 Des	Customer Service Excellence	Jakarta
11	10 - 11 Des	Comprehensive Ms. Excel Training With Visual Basic Application (VBA)	Jakarta
12	12 Des	Powerfull of Sales Data Analysis & Dashboard Report With Advanced Excel 2010	Jakarta
13	12 - 13 Des	Public Speaking & Presentation Skill	Jakarta
14	12 -13 Des	Technical Report Writing	Jakarta
15	12 - 13 Des	Coaching & Counseling	Jakarta
16	13 - 14 Des	Logistics & Supply Chain Management	Jakarta
17	13 - 14 Des	Total Quality Management	Jakarta
18	13 - 14 Des	Good Corporate Governance (GCG)	Jakarta
19	17 - 18 Des	Leadership & Managerial Skills	Jakarta
20	17 - 18 Des	Advanced Secretary Development Program	Jakarta
21	17 - 18 Des	Financial Statement Analysis	Jakarta
22	19 - 20 Des	Effective Office Management With Kaizen 5S & Filing System	Jakarta
23	19 - 20 Des	Teknik Penyusunan SOP Menggunakan KPI	Jakarta
24	19 - 20 Des	Metode Penyusunan Spesifikasi & HPS	Jakarta
25	27 - 28 Des	Comprehensive Basic Accounting for Executive	Jakarta
26	27 - 28 Des	Problem Solving & Decision Making	Jakarta
27	27 - 28 Des	Strategic Sourcing & Vendor Management	Jakarta
28	27 - 28 Des	Struktur Penyusunan Skala Upah (Compensation & Benefits)	Jakarta

 

 

Elizia Challa

Sales Marketing

MARKSHARE TRAINING
Telp. 021.5793 2035

HP . 0821 2256 4094

elizia@marksharetraining.co.id 

www.marksharetraining.co.id