{"product_id":"hr-track-aphri-excel-in-hr","title":"HR Track (aPHRi – Excel in HR)","description":"\u003cp\u003eThis track covers the core principles of human resources management across five main areas — HR operations, recruitment, compensation, professional development, and employee relations and well-being. It is designed for beginners, with no prior experience required, as well as for professionals. The Excel for HR course also covers all the practical skills you need in Excel to help you organize your work as an HR manager or personnel officer.\u003cbr\u003eaPHRi Modules\u003cbr\u003eModule 1 – HR Operations: Covers day-to-day operational tasks such as workforce management, compliance with organizational regulations and policies, and organizing administrative processes within the company.\u003cbr\u003eModule 2 – Recruitment and Selection: Focuses on the organizational requirements of recruitment, talent attraction, sourcing, interviewing and selection processes, and onboarding procedures for new employees.\u003cbr\u003eModule 3 – Compensation and Benefits: Addresses pay and benefits programs and how to design comprehensive rewards strategies that enhance employee satisfaction and maintain competitiveness.\u003cbr\u003eModule 4 – HR Development and Retention: Covers learning and development, career development, and succession planning to ensure continuity of performance.\u003cbr\u003eModule 5 – Employee Relations, Health, and Safety: Covers employee relations and labor laws, workplace ethics, diversity and inclusion, risk management, and workplace safety.\u003cbr\u003eExcel in HR Course Topics\u003cbr\u003eLookup function and its uses in human resources.\u003cbr\u003eExcel fundamentals: getting to know the interface and basic tools.\u003cbr\u003eFormatting tables and professional navigation within files.\u003cbr\u003eUsing references and named ranges.\u003cbr\u003eBasic functions: SUM, AVERAGE, MIN, MAX.\u003cbr\u003eSort \u0026amp; Filter.\u003cbr\u003eConditional Formatting.\u003cbr\u003eExcel functions in human resources.\u003cbr\u003eLookup functions: VLOOKUP, HLOOKUP, INDEX, MATCH.\u003cbr\u003eDate functions: TODAY, NOW, DATEDIF, YEARFRAC.\u003cbr\u003eLogical functions: IF, IFS, AND, OR.\u003cbr\u003eText functions: LEFT, RIGHT, LEN, TEXT, TRIM.\u003cbr\u003ePractical HR applications.\u003cbr\u003eUsing special text functions in the HR field.\u003cbr\u003eUsing logical functions to obtain the desired results.\u003cbr\u003eUsing pivot tables and charts.\u003cbr\u003eCreating pivot tables.\u003cbr\u003eBuilding a complete employee database.\u003cbr\u003eDesigning attendance and check-in\/check-out sheets.\u003cbr\u003eTracking leaves and absences.\u003cbr\u003ePerformance evaluation using Excel.\u003cbr\u003eLinking multiple worksheets together.\u003cbr\u003eCalculating salaries, allowances, and deductions.\u003cbr\u003eAnalyzing employee data using pivot tables.\u003cbr\u003eReports and charts.\u003cbr\u003ePreparing monthly and quarterly reports.\u003cbr\u003eDesigning an interactive HR dashboard.\u003cbr\u003eTurnover analysis.\u003cbr\u003eLearning Objectives\u003cbr\u003eEnhance your CV with a globally recognized certification from HRCI.\u003cbr\u003eGain comprehensive knowledge of HR best practices.\u003cbr\u003eImprove practical skills in recruitment, compensation, employee development, and relationship management.\u003cbr\u003eIncrease employment and promotion opportunities in local and international companies.\u003cbr\u003eBuild a strong foundation that qualifies you to move on to higher certifications in the future.\u003cbr\u003eUnderstand the fundamentals of Excel.\u003cbr\u003eUnderstand formulas and how to create pivot tables and charts and apply them in your work.\u003cbr\u003eUnderstand and use special text functions in the HR field.\u003cbr\u003eUnderstand and use logical functions to obtain the results you want.\u003cbr\u003eSecure Excel files.\u003cbr\u003eTarget Audience\u003cbr\u003eIndividuals new to HR or wishing to enter the field without prior experience.\u003cbr\u003eProfessionals working in HR outside the United States.\u003cbr\u003eCorporate employees in HR departments who need a global certification to strengthen their professional standing.\u003cbr\u003eAnyone seeking to improve their HR management skills in a practical and fast way.\u003cbr\u003eBusiness owners who need to manage their operations in a more organized manner.\u003cbr\u003eHR supervisors or managers.\u003cbr\u003ePersonnel officers.\u003cbr\u003eThose responsible for payroll, compensation, and other financial tasks.\u003c\/p\u003e","brand":"Trust Point","offers":[{"title":"Online \/ 27 Sep - 15 Oct \/ 7:00pm – 10:00pm","offer_id":46001888493651,"sku":null,"price":2500.0,"currency_code":"SAR","in_stock":true},{"title":"On-premise \/ 27 Sep - 15 Oct \/ 7:00pm – 10:00pm","offer_id":46001888526419,"sku":null,"price":3300.0,"currency_code":"SAR","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0696\/3901\/2435\/files\/WhatsAppImage2026-08-20at4.34.29PM.jpg?v=1787241560","url":"https:\/\/trustpoint.net.sa\/products\/hr-track-aphri-excel-in-hr","provider":"Trust Point","version":"1.0","type":"link"}