Get Ur Training!!! (1) Payroll Training: Payroll System Administration (2) POWERFUL DATABASE ANALYSIS AND DASHBOARD REPORTING WITH EXCEL 2007/2010

	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 : Payroll Training: Payroll System Administration Jakarta, 24 – 25 Mei 2018 POWERFUL DATABASE ANALYSIS AND DASHBOARD REPORTING WITH EXCEL  2007/2010  Jakarta, 30 – 31 Mei 2018 Materi Program Ruang Lingkup kompensasi Metode – metode kompensasi Sistem kompensasi Faktor-faktor yang mempengaruhi penentuan upah. Pedoman penetapan tingkat upah. Struktur dan skala upah ( Matrix Salary ) Komponen gaji, tunjangan dan iuran wajib. Menghitung jumlah gaji. Menghitung upah lembur. Menghitung pajak penghasilan (Pph Pasal 21) untuk karyawan tetap. Gambaran umum proses – proses dari Payroll Administration System. Tahapan – tahapan penggunaan aplikasi Payroll Administration System. Studi kasus. Manfaat Pelatihan Mengetahui & memahami definisi, metode dan sistem kompensasi. Mengetahui faktor-faktor yang mempengaruhi penentuan upah. Mengetahui pedoman penetapan tingkat upah. Mengetahui & memahami penggunaan struktur dan skala upah. Mengetahui & memahami komponen gaji (upah), tunjangan dan iuran wajib. Mengetahui & memahami cara menghitung jumlah gaji. Mengetahui & memahami cara menghitung upah lembur. Mengetahui & memahami cara menghitung pajak penghasilan (Pph Pasal 21) untuk karyawan tetap. Mengetahui & memahami konsep Payroll Administration System, konfigurasi dan ilustrasi prosesnya. Mengetahui & memahami penggunaan dari software Payroll Administration system Melakukan proses penyelesaian studi kasus berdasarkan departement masing-masing   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   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 PUBLIC CLASS MEI 2018

 

 

NO	TANGGAL	JUDUL TRAINING
1	3 - 4 Mei	Discovering Effective Financial Statement Analysis
2	3 - 4 Mei	Extraordinary Journalisme for Corporate Website
3	3 - 4 Mei	Effective Practical Business Communication
4	7 - 8 Mei	Risk Based Internal Audit
5	23-24Mei	KPI With Balanced Scorecard
6	30-31Mei	Powerfull Database Analysis & Dashboard Reporting with Ms. Excel 2007/2010
7	8 - 9 Mei	Business Process Modeling Implementation With BPMN Tools
8	24-25Mei	Enterprise Risk Management
9	14-15Mei	Cost Accounting - Best Practice
10	14-15Mei	Effective Office Management With Kaizen 5S & Filing System
11	14-15Mei	General Affair Management Development Program
12	14-15Mei	Public Speaking & Presentation Skills
13	15-16Mei	Metode Penyusunan Spesifikasi & HPS
14	15-16Mei	Effective Negotiation & Lobbying Skills
15	15-16Mei	Applied Finance for Non Finance
16	15-16Mei	Transformational Leadership & Managerial Skill
17	17-18Mei	Strategic Sourcing & Vendor Management
18	17-18Mei	Project Management Using Ms. Project Application
19	17-18Mei	Logical & Creative Problem Solving
20	17-18Mei	Creative Cashflow & Treasury Management
21	21-22Mei	EffectiveWarehouse & Inventory Management
22	21-22Mei	Productivity & Effective Time Management
23	21-22Mei	Electronic Filling System Implementation Based on Doc. Regulation & RMS-EFS With Excel 2007/2010/2013/2015/2016
24	21-22Mei	Integrated Procurement Management
25	21-22Mei	Negotiation Power For Purchasing
26	21-22Mei	The 7 Selling Steps Total Selling Basic
27	23-24Mei	Comprehensive Basic Accounting for Executive
28	23-24Mei	Public Relation Management
29	23-24Mei	Penyusunan Struktur Skala Upah (Compensation & Benefit)
30	23-24Mei	Personal Development & Generational Diversity In The Workplace
31	23-24Mei	Effective Technical report Writing
32	24-25Mei	New Product Development
33	24-25Mei	Career & Talent Management
34	30-31Mei	Workload Analysis Implementation With MS. Excel For HR & Non HR
35	30-31Mei	Training Need Analysis
36	30-31Mei	Human Resource Management Development Program (HRMDP)
37	30-31Mei	Advanced Service Excellence