{"product_id":"excel-in-hr","title":"Excel in HR","description":"\u003cp\u003eThe Excel in HR course covers all the practical skills you need in Excel to help you organize your work as an HR manager or personnel officer.\u003cbr\u003eTraining Topics Covered\u003cbr\u003eExcel Fundamentals\u003cbr\u003e●    Getting familiar with the program interface and basic tools.\u003cbr\u003e●    Formatting tables and professional navigation within files.\u003cbr\u003e●    Using references and named ranges.\u003cbr\u003e●    Basic functions: SUM, AVERAGE, MIN, MAX.\u003cbr\u003e●    Sort \u0026amp; Filter.\u003cbr\u003e●    Conditional Formatting.\u003cbr\u003eExcel Functions in HR\u003cbr\u003e●    Lookup functions: VLOOKUP, HLOOKUP, INDEX, MATCH.\u003cbr\u003e●    Date functions: TODAY, NOW, DATEDIF, YEARFRAC.\u003cbr\u003e●    Logical functions: IF, IFS, AND, OR.\u003cbr\u003e●    Text functions: LEFT, RIGHT, LEN, TEXT, TRIM.\u003cbr\u003ePractical HR Applications\u003cbr\u003e●    Using special text functions in the HR field.\u003cbr\u003e●    Using logical functions to obtain the desired results.\u003cbr\u003e●    Using pivot tables and charts.\u003cbr\u003e●    Creating pivot tables.\u003cbr\u003e●    The Lookup function and its uses in HR.\u003cbr\u003e●    Building an integrated employee database.\u003cbr\u003e●    Designing attendance and time-tracking sheets.\u003cbr\u003e●    Tracking leaves and absences.\u003cbr\u003e●    Performance evaluation using Excel.\u003cbr\u003e●    Linking multiple worksheets together.\u003cbr\u003e●    Calculating salaries, allowances, and deductions.\u003cbr\u003e●    Analyzing employee data using pivot tables.\u003cbr\u003eReports and Charts\u003cbr\u003e●    Preparing monthly and quarterly reports.\u003cbr\u003e●    Designing an interactive HR dashboard.\u003cbr\u003e●    Turnover analysis.\u003cbr\u003e●    Linking multiple worksheets together.\u003cbr\u003e\u003c\/p\u003e","brand":"Trust Point","offers":[{"title":"Online \/ 20 Sep - 24 Sep \/ 06:00 pm - 10:00 pm","offer_id":45948708487251,"sku":null,"price":977.5,"currency_code":"SAR","in_stock":true},{"title":"On-premise \/ 20 Sep - 24 Sep \/ 06:00 pm - 10:00 pm","offer_id":45948708520019,"sku":null,"price":1380.0,"currency_code":"SAR","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0696\/3901\/2435\/files\/WhatsAppImage2026-08-09at10.55.08PM.jpg?v=1786397398","url":"https:\/\/trustpoint.net.sa\/products\/excel-in-hr","provider":"Trust Point","version":"1.0","type":"link"}