Almost Running : POWERFUL DATABASE ANALYSIS AND DASHBOARD REPORTING WITH EXCEL 2007/2010 ; General Affairs Development Program

	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 :   POWERFUL DATABASE ANALYSIS AND DASHBOARD REPORTING WITH EXCEL  2007/2010  Jakarta, 25 – 26 April 2018                 General Affairs Development Program Jakarta, 16 – 17 April 2018 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 SYLLABUS   1.      Understanding of GA Officer Concept.   2.      Job Information for GA Officer.   3.      Key Performance Indicator for GA Officer.   4.      Generic Competencies Based Training Program For GA ( Supervisory, Staff and Driver).   5.      Organizational Structure of GA Department.   6.      Personality Characters Fundamentals.   7.      Interpersonal skill Implementation.   8.      Coaching skill Implementation.   9.      Time Management Implementation.   10. Effective Communication Fundamentals.   11. Coordination skill Fundamentals   12. Lobby Skill Fundamentals   13. Negotiation skill Fundamentals   14. Continuous Improvement Fundamentals with 5S/R method   15. Filling System Fundamentals.   16. Design and Layout Office Room.   17. Design lighting system in the office room and out office room.   18. GA data processing with Excel 2007.   19. General Affair Problem Solving.         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

  

NO	TANGGAL	JUDUL TRAINING	LOKASI
1	3 - 4 April	Effective Interpersonal Communication Skill	Jakarta
2	3-Apr	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	Public Relation Management	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	25 -26 April	Powerfull Database Analysis & Dashboard Reporting with ms. Excel 2007 / 2010	Jakarta
12	11 - 12 April	Financial Statement Analysis ( FSA )	Jakarta
13	11 - 12 April	Best Practice Warehouse management	jakarta
14	11 - 12 April	Effective Technical Report Writing	Jakarta
15	12 - 13 April	Procurement negotiation & Contracting Strategy	bandung
16	12 - 13 April	Excellent Automation Data Processing With Macro & Visual Basic Application Excel 2007/2010/2013/2015	Bandung
17	12 - 13 April	Tax Planning & Management	Jakarta
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	General Affairs Management Development Program	Jakarta
22	16 –17 April	Basic HR Management	Jakarta
23	17 - 18 April	Persiapan Masa Pensiun	Jakarta
24	19 - 20 April	New Product Development	Bandung
25	19- 20 April	Advanced Secretary Development Program	Jakarta
25	19 –20 April	Integrated Procurement Management	Jakarta
26	19 - 20 April	Public Speaking & Presentation Skills	Jakarta
27	19 - 20 April	Risk Management	Jakarta
28	19 - 20 April	Successfully Managing People " An Essential Leadership & Managerial Skills"	Jakarta
29	23 - 24 April	Good Corporate Governance ( GCG ) Implementation	Jakarta
30	23 - 24 April	Metode Penyusunan Spesifikasi & HPS	Jakarta
31	23 - 24 April	Leadership For Sales ; Lead Well Sell Better	jakarta
32	23 –24 April	Strategic Vendor Management	Jakarta
33	9 - 10 April	Electronic Filing System Implementation Based On Document Regulation And Rms – Efs Method With Excel 2007/2010/2013/2015/2016	jakarta
34	24 - 25 April	Corporate Journalism ; How to Treat Corporate Website, Magazine & Media Handling	Jakarta
35	24 - 25 April	Career & Talent Management	Jakarta
36	25 –26 April	Training For Trainers	Jakarta
37	26 - 27 April	Logical Thinking & Problem Solving	Jakarta
38	26 - 27 April	Contract & Tender in Procurement	Jakarta
39	26 –27 April	Effective Supervisory Skill	Jakarta
40	26 -27April	Creative Cashflow & Treasury Management	Jakarta
41	26 -27April	Project Management Using Ms. Project Application	Jakarta
42	26 -27April	Comprehensive Industrial Relation	Jakarta
43	26 -27April	Workload Analysis Implementation with EXCEL 2007 FOR HR & NON HR	Jakarta