Confirm Running : Powerfull Database Analysis & Dashboard Reporting with MS.Excel &Negotiation Power For Purchasing

	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 : Powerfull Database Analysis & Dashboard Reporting with MS.Excel Jakarta, 24 – 25  Oktober 2018 CONFIRM RUNNING Negotiation Power For Purchasing Jakarta, 29 – 30 Oktober 2018 CONFIRM RUNNING 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   OUTLINE   Hari ke 1:    1. Sekilas ttg Supplier Relationship – Apakah anda perlu bernegosiasi dengan semua supplier anda?  ·         Total Cost of Ownership (TCO) ·         Range of supplier relationship ·         Purchasing product portfolio   2. Mendefinisikan negosiasi ·         Pandangan permusuhan ·         Pandangan saling menguntungkan   3. TCO : total cost of ownership ·         4 elemen TCO ·         Price Analysis ·         Cost Analysis ·         Dollars-and-numbers ·         Mendapatkan TCO terendah   4. Persiapan utk negosiasi 1 ·         Apa yg dapat dinegosiasikan? ·         Rencana negosiasi ·         Konsesi / kompromi ·         3 levels dlm concession strategy ·         Negosiasi dgn concession strategy   5. Persiapan utk negosiasi 2 ·         Sertifikasi/ kualifikasi supplier ·         Checklist Sertifikasi supplier pendahuluan ·         The Do-ability assessment   6. Strategy negosiasi ·         Strategi: Win-Lose ·         Strategi: Lose-Win ·         Strategi: Lose-Lose ·         Strategi: Win-Win   Hari ke 2:   7. Communication skill ·         Elemene Lateral: Speaking, listening, reading ·         Elemen figurative: open mind, body language   8. Faktor interpersonal ·         Analytical ·         Practical ·         Amiable ·         Extravert   9. Taktik & kontra taktik ·         Maneuver ·         Flyers ·         Dll   10. Latihan/praktek/ role play: ·         3 levels dlm concession strategy ·         Strategi negosiasi. ·         Template negosiasi ·         Taktik negosiasi   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 OKTOBER 2018

 

 

 

No.	Tanggal	Jadwal Training	Lokasi
1	29- 30 Oktober 2018	Applied Finance for Non Finance Executive	Jakarta
2	29 -30 Oktober 2018	Negotiation Power For Purchasing	Jakarta
3	30 - 31 Oktober 2018	Creative Cashflow & Treasury Management	Jakarta
4	18 - 19 Oktober 2018	Payroll Management System	Bandung
5	18 -19 Oktober 2018	Technical Report Writing	Jakarta
6	18 - 19 Oktober 2018	Effective Interpersonal Communication	Bandung
7	18 - 19 Oktober 2018	Financial Statement Analysis	Bandung
8	18 - 19 Oktober 2018	Comprehensive Supervisory Skills	Jakarta
9	18 - 19 Oktober 2018	Budgeting profit Planning & Cost Control	Jakarta
10	18 - 19 Oktober 2018	Training PDCA ( Plan - DO - Check - Action)	Jakarta
11	18 - 19 Oktober 2018	Human Resources Development Program (HRMDP)	Jakarta
12	22 - 23 Oktober 2018	Electronic Filing Management System	Jakarta
13	22 - 23 Oktober 2018	Business Plan Management	Jakarta
14	22 - 23 Oktober 2018	New Product Development	Jakarta
15	24 - 25 Oktober 2018	Best Practice Warehouse Management	Jakarta
16	24 - 25 Oktober 2018	Powerfull Database Analysis & Dashboard Reporting with ms. Excel 2007 / 2010	Jakarta
17	25 - 26 Oktober 2018	Effective Negotiation & Lobbying Skill	Bali
18	25 - 26 Oktober 2018	Corporate Journalism	Jakarta
19	25 - 26 Oktober 2018	Building Service Excellence	Jakarta
20	25 - 26 Oktober 2018	Teknik Penyusunan SOP menggunakan KPI	Jakarta
21	25 - 26 Oktober 2018	Effective Office Management With Kaizen 5S & Filing System	Jakarta
22	29 - 30 Oktober 2018	Purchasing & Procurement Management	Jakarta
23	29 - 30 Oktober 2018	Public Relation Management	Bali
24	29 - 30 Oktober 2018	Leadership & Managerial Skills	Bali
25	29 - 30 Oktober 2018	Mastering Excel 2007/2010 Beyond For Office Data processing System	Jakarta
26	30 - 31 Oktober 2018	Smart Plan Project Management using Ms. Project Application	Jakarta
27	30 - 31 Oktober 2018	Problem Solving & Decision Making	Jakarta
28	30 - 31 Oktober 2018	Modern Office Administration For Executive Secretary and Administration	Jakarta
29	30 - 31 Oktober 2018	Workload Analysis Implementation With Ms. Excel For HR & Non HR	Jakarta
30	30 - 31 Oktober 2018	Financial Projection & Valuation	Jakarta

 

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