MARKSHARE Training We Provide Workshop & Training Call Us : Elizia (Ms) 0821 2256 4094 / 021- 57932035 [email protected] / [email protected] 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. Whats 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 [email protected] / [email protected] 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
