MARKSHARE Training
We Provide Workshop & Training
Call Us :
Elizia (Ms)
0821 2256 4094 / 021- 57932035
eli...@marksharetraining.co.id / laurenciaeli...@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 2018POWERFUL 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
eli...@marksharetraining.co.id / laurenciaeli...@gmail.com 
www.marksharetraining.co.id 









                                                                                
                    click here for unsubscribed


JADWAL PUBLIC CLASS MEI 2018




NOTANGGALJUDUL TRAINING
1 3 - 4 MeiDiscovering Effective Financial Statement Analysis
 23 - 4 MeiExtraordinary Journalisme for Corporate Website
 33 - 4 Mei Effective Practical Business Communication
 47 - 8 MeiRisk Based Internal Audit
523-24MeiKPI With Balanced Scorecard
630-31Mei Powerfull Database Analysis & Dashboard Reporting with Ms. Excel 
2007/2010
78 - 9 Mei Business Process Modeling Implementation With BPMN Tools
824-25Mei Enterprise Risk Management
914-15MeiCost Accounting - Best Practice
1014-15MeiEffective Office Management With Kaizen 5S & Filing System
1114-15MeiGeneral Affair Management Development Program
1214-15MeiPublic Speaking & Presentation Skills
1315-16MeiMetode Penyusunan Spesifikasi & HPS
1415-16MeiEffective Negotiation & Lobbying Skills
1515-16MeiApplied Finance for Non Finance
1615-16MeiTransformational Leadership & Managerial Skill
1717-18Mei Strategic Sourcing & Vendor Management
1817-18Mei Project Management Using Ms. Project Application
1917-18MeiLogical & Creative Problem Solving
2017-18Mei Creative Cashflow & Treasury Management
2121-22Mei EffectiveWarehouse & Inventory Management
2221-22Mei Productivity & Effective Time Management
2321-22Mei Electronic Filling System Implementation Based on Doc. Regulation & 
RMS-EFS With Excel 2007/2010/2013/2015/2016
2421-22MeiIntegrated Procurement Management
2521-22Mei Negotiation Power For Purchasing
2621-22Mei The 7 Selling Steps Total Selling Basic
2723-24MeiComprehensive Basic Accounting for Executive
2823-24MeiPublic Relation Management
2923-24MeiPenyusunan Struktur Skala Upah (Compensation & Benefit)
3023-24MeiPersonal Development & Generational Diversity In The Workplace
3123-24MeiEffective Technical report Writing
3224-25MeiNew Product Development
3324-25MeiCareer & Talent Management
3430-31Mei Workload Analysis Implementation With MS. Excel For HR & Non HR
3530-31Mei Training Need Analysis
3630-31Mei Human Resource Management Development Program (HRMDP)
3730-31Mei Advanced Service Excellence

Reply via email to