Excel For HR
..................... Course content HR Database • Database basics • How to Create an HR Database Using Microsoft Access • Case study (Rec database ) Dealing with Data • Importing & Exporting data • How to create live reports • How to create HR reports using pivot table • Case study ( HIRS + reports ) Com & Ben Using Microsoft Excel • Building live payroll sheet • HR formulas ( insurance , tax, penalties) • New way for calculation • Case study (payroll formulas) • Monthly variables • Case study ( Employees loans ) Attendance • Time formulas • Case study (Man Power Plan) • Case study (Man Power Plan new way ) • Advanced HR formulas • Case study (HR variable ) • Case study (create Leave sheet ) Another useful Excel for HR Applications • Mail merge • Case study( Payroll slip , sending other mails ) • Using Microsoft excel in job posting (new way ) • Linking Excel with Visio • Case study (org chart ) • Case study (org chart , more accurate way) • Org chat reports • Some advanced tools • Case study (payroll revision ) • Some Excel for HR templates Instructor Mr. Walid Al Wakeel • More than 16 years' experience in HR filed including 8 years in managerial position. • HR consultant in Egypt, UAE and Libya • Founder of Excel for HR course in Egypt Duration • 24 Hours Price • 550 In Cairo • 500 In Alex * Required http://www.arab
ليست هناك تعليقات:
إرسال تعليق