Mastering Ms. Excel For Office Data Processing System Hotel Oria Jakarta, 12 - 13 April 2017Payroll Management System Implementation With Ms. Excel, Overtime Calculation & PPH 21 Hotel Oria, Jakarta 12 - 13 April 2017 Call Us : Eby (Ms.) 08561044530 / 021 – 57932035 [email protected] / [email protected] www.marksharetraining.co.id if you no longer want to receive this emails, click here to unsubscribe Materi Pelatihan :
1. Numeric data processing with using cell absolute address. 2. Text data processing with string function 3. Combination of Date function with String function. 4. Implementation numeric function for calculation process to Day and Tomorrow 5. How using of Remove Duplicates tools. 6. How using of Conditional Formatting tools. 7. How using of Consolidate tools. 8. How using of Auto Filter Optimization 9. How using of Advance Filter Optimization 10. Validation and date data processing from text format to historical date transaction. 11. Understanding and implementation of sheet data master and sheet data transactions. 12. How using of Data Sort tools. 13. How using of VLOOKUP() function for table data retrieval processing. 14. How using of HLOOKUP()function for table data retrieval processing. 15. How using of VLOOKUP() advance for multiple table data retrieval processing. 16. How using of IF() Logic function. 17. How using of Multiple IF() Logic function. 18. How using of AND Logic Operator. 19. How using of PivotTable tools. 20. Created and design Cells Graphic with using Spark Lines 21. How make and using PivotChart Optimation with Slicers Panel 22. How using of Data Validation method. 23. How using of file Excel Add in Macro (*.XLAM). 24. Understanding of Visual Basic Application Fundamentals (Macro). 25. How using of Format Cells for Locked and Hidden Cells 26. How using of Using Allow Users to Edit Range ( Permission User Access Setting ) 27. How using of Protect Sheet ( Select Locked Cells and Select Unlocked Cells )Materi Pelatihan : 1. Definisi kompensasi 2. Metode – metode kompensasi 3. Sistem kompensasi 4. Faktor-faktor yang mempengaruhi penentuan upah. 5. Pedoman penetapan tingkat upah. 6. Struktur dan skala upah ( Matrix Salary ) 7. Komponen gaji, tunjangan dan iuran wajib. 8. Menghitung jumlah gaji. 9. Menghitung upah lembur. 10. Gambaran umum proses – proses dari Payroll Administration System. 11. Tahapan – tahapan penggunaan aplikasi Payroll Administration System, mulai dari membuat database, membuat system absensi otomatis, penentuan penanggalan pembayaran, potongan, simpanan dan angsuran karyawan, membuat master gaji, berbagai tunjangan, lembur sampai dengan pembuatan slip gaji, surat bank, voucher dan hal-hal terkait lainnya. OBJECTIVES Setelah mengikuti pelatihan ini peserta diharapkan mampu untuk : 1. Mengetahui & memahami definisi , metode dan system kompensasi. 2. Mengetahui faktor-faktor yang mempengaruhi penentuan upah. 3. Mengetahui pedoman penetapan tingkat upah. 4. Mengetahui & memahami penggunaan struktur dan skala upah. 5. Mengetahui & memahami komponen gaji (upah), tunjangan dan iuran wajib. 6. Mengetahui & memahami cara menghitung jumlah gaji. 7. Mengetahui & memahami cara menghitung upah lembur. 8. Mengetahui & memahami konsep Payroll Administration System, konfigurasi dan ilustrasi prosesnya. 9. Mengetahui & memahami penggunaan dari software Payroll Administration system Melakukan proses penggajian beserta membuat laporan-laporan yang diperlukan Call Us : Eby (Ms.) 08561044530 / 021 – 57932035 [email protected] / [email protected] www.marksharetraining.co.id if you no longer want to receive this emails, click here to unsubscribe Other Following Schedule : NOTANGGALJUDUL TRAININGLOKASI APRIL 2017 112 - 13 April Mastering Ms. excel for office data processing systemJakarta 212 - 13 april Payroll Management implementation with ms. Excel, overtime calculation & PPH 21Jakarta 317 -18 April Supervisory Skills 'Be a Great Supervisor'Jakarta 417 -18 April production Planning & Inventory ControlJakarta 519 - 20 April Training need analysisJakarta 619 - 20 April Comprehensive Basic Accounting For ExecutiveJakarta 720 - 21 April Ms. Excel VBAJakarta 820 - 21 April Effective shopfloor leadershipJakarta 924 - 25 april The art of getting Paid : Collection & Control ManagementJakarta 1024 - 25 April Project Management With Ms. Project ApplicationJakarta 1125 - 26 April Human Resource ManagementJakarta 1225 - 26 april New Product DevelopmentJakarta 1327 - 28 AprilEffective office management with kaizen 5S & Filling systemJakarta 1427 - 28 april Integrated presentation managementJakarta 1527 - 28 april Effective Sparepart ManagementJakarta MEI 2017 102 MeiPowerpointDo MoreJakarta 202 - 03 MeiElectronic Filing Implementation With RMS & EFS Method Based on Document RegulationJakarta 302 - 13 MeiFinancial Statement AnalysisJakarta 402 - 03 MeiNegotiation Power For PurchasingJakarta 503 - 04 MeiMetode Penyusunan Spesifikasi & Harga Perkiraan SendiriBandung 603 - 04 MeiEffective Negotiation & Lobbying SkillsBandung 708 - 09 MeiPayroll Management implementation with ms. Excel, overtime calculation & PPH 21Jakarta 808 - 09 MeiStrategic Sourcing & Vendor ManagementJakarta 910 - 11 MeiTechnical Report WritingJakarta 1010 - 11 MeiBest Practice Warehouse ManagementJakarta 1112 - 13 MeiAdvanced Selling SkillsJakarta 1212 - 13 MeiProfessional General Affairs (GA) Management Development ProgramJakarta 1312 - 13 MeiGood Corporate Governance (GCG) ImplementationJakarta 1412 - 13 MeiHR for Non HRJakarta 1515 - 16 Mei Succesfull Managing People & Managerial SkillsJakarta 1615 - 16 Mei Comprehensive Basic Accounting For ExecutiveJakarta 1717 MeiAdvance SOP WritingJakarta 1818 - 19 MeiWorkload Analysis Implementation With Ms Excel For HR & Non HRJakarta 1918 - 19 MeiPowerfull Database Analysis & Dashboard Reporting Using Ms. Excel Jakarta 2022 - 23 MeiEffective Sparepart ManagementJakarta 2122 - 23 MeiFinance For Non FinanceJakarta 2229 - 30 MeiCorporate JournalismJakarta 2330 - 31 MeiEffective Assertive CommunicationJakarta
