{"id":33996,"date":"2023-08-26T16:04:37","date_gmt":"2023-08-26T09:04:37","guid":{"rendered":"https:\/\/adsmo.vn\/ham-excel-quan-ly-nhan-su\/"},"modified":"2026-03-09T11:38:34","modified_gmt":"2026-03-09T04:38:34","slug":"excel-function-for-human-resource-management-in-business","status":"publish","type":"post","link":"https:\/\/adsmo.vn\/en\/excel-function-for-human-resource-management-in-business\/","title":{"rendered":"Excel function for human resource management in business"},"content":{"rendered":"<p style=\"text-align: justify;\"><b><i>Excel<\/i><\/b><span style=\"font-weight: 400;\"> is an extremely powerful tool for calculating, processing and presenting spreadsheets. Currently, in all operations related to Human Resources: Recruitment, Administration, Salary C&amp;B, Training&#8230; Excel is often used. <\/span><span style=\"font-weight: 400;\">Excel completely meets the above requirements, while helping users significantly reduce time, solving complex operations that are difficult for any program to compare with Excel. Therefore, many people feel like using Excel to manage human resources. Today ADSMO will introduce to you some Excel functions for human resource management.<\/span><\/p>\n<ol style=\"text-align: justify;\">\n<li>\n<h2><b> LEFT function<\/b><\/h2>\n<\/li>\n<\/ol>\n<ul style=\"text-align: justify;\">\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Syntax: LEFT(Text,n)<\/span><\/li>\n<\/ul>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">Text: is the original string;<\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">n: Number of characters to cut;<\/span><\/p>\n<ul style=\"text-align: justify;\">\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Use: Cut n characters from the left of a string<\/span><\/li>\n<\/ul>\n<ol style=\"text-align: justify;\" start=\"2\">\n<li>\n<h2><b> RIGHT function<\/b><\/h2>\n<\/li>\n<\/ol>\n<ul style=\"text-align: justify;\">\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Syntax: RIGHT(Text,n)<\/span><\/li>\n<\/ul>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">Text: is the original string;<\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">n: Number of characters to cut;<\/span><\/p>\n<ul style=\"text-align: justify;\">\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Use: Cut n characters in the original string starting from the right<\/span><\/li>\n<\/ul>\n<ol style=\"text-align: justify;\" start=\"3\">\n<li>\n<h2><b> MID function<\/b><\/h2>\n<\/li>\n<\/ol>\n<ul style=\"text-align: justify;\">\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Syntax: MID(Text, m, n)<\/span><\/li>\n<\/ul>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">Text: Text string;<\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">m: position corresponding to the first character to be taken in Text;<\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">n: Number of characters to cut;<\/span><\/p>\n<ul style=\"text-align: justify;\">\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Use: Extract n characters from any position (m) in the text string<\/span><\/li>\n<\/ul>\n<ol style=\"text-align: justify;\" start=\"4\">\n<li>\n<h2><b> LEN function<\/b><\/h2>\n<\/li>\n<\/ol>\n<ul style=\"text-align: justify;\">\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Syntax: LEN(Text)<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Use: Return the length of the character string;<\/span><\/li>\n<\/ul>\n<ol style=\"text-align: justify;\" start=\"5\">\n<li>\n<h2><b> TRIM function<\/b><\/h2>\n<\/li>\n<\/ol>\n<ul style=\"text-align: justify;\">\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">\u00a0Syntax: TRIM(Text);<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Use: Removes spaces in a string (leaving only one space between words)<\/span><\/li>\n<\/ul>\n<ol style=\"text-align: justify;\" start=\"6\">\n<li>\n<h2><b> SUM function<\/b><\/h2>\n<\/li>\n<\/ol>\n<ul style=\"text-align: justify;\">\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Syntax: SUM(Number1, Number2,\u2026)<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Use: Calculate the sum of a series of numbers;<\/span><\/li>\n<\/ul>\n<ol style=\"text-align: justify;\" start=\"7\">\n<li>\n<h2><b> SUMIF function<\/b><\/h2>\n<\/li>\n<\/ol>\n<ul style=\"text-align: justify;\">\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Syntax: SUMIF(Series 01, Comparison condition, Series 02)<\/span><\/li>\n<\/ul>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">Series 01: Used to calculate the sum and compare with the comparison condition;<\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">Series 02: Only numbers in series 02 are summed if the comparison condition between \u201cSeries 01 and Comparison condition\u201d is satisfied;<\/span><\/p>\n<ul style=\"text-align: justify;\">\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Use: Calculate the sum of a series of numbers according to a given condition;<\/span><\/li>\n<\/ul>\n<ol style=\"text-align: justify;\" start=\"8\">\n<li>\n<h2><b> AVERAGE function<\/b><\/h2>\n<\/li>\n<\/ol>\n<ul style=\"text-align: justify;\">\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Syntax: AVERAGE(Number1, Number2,\u2026)<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Use: Calculate the average of a series of numbers;<\/span><\/li>\n<\/ul>\n<ol style=\"text-align: justify;\" start=\"9\">\n<li>\n<h2><b> MAX function<\/b><\/h2>\n<\/li>\n<\/ol>\n<ul style=\"text-align: justify;\">\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Syntax: MAX(Number1, Number2,\u2026)\u00a0<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Uses:<\/span><\/li>\n<\/ul>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">Returns the largest value in the listed number sequence;<\/span><\/p>\n<ol style=\"text-align: justify;\" start=\"10\">\n<li>\n<h2><b> MIN function<\/b><\/h2>\n<\/li>\n<\/ol>\n<ul style=\"text-align: justify;\">\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Syntax: MIN(Number1, Number2,\u2026)<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Uses:<\/span><\/li>\n<\/ul>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">Returns the smallest number in the listed number sequence;<\/span><\/p>\n<ol style=\"text-align: justify;\" start=\"11\">\n<li>\n<h2><b> COUNT function<\/b><\/h2>\n<\/li>\n<\/ol>\n<ul style=\"text-align: justify;\">\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Syntax: COUNT(Value1, Value2,\u2026)<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Use: Count cells containing numbers in a table;<\/span><\/li>\n<\/ul>\n<ol style=\"text-align: justify;\" start=\"12\">\n<li>\n<h2><b>COUNTIF function<\/b><\/h2>\n<\/li>\n<\/ol>\n<ul style=\"text-align: justify;\">\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Syntax: COUNTIF(Number range, logical condition)<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Use: Returns the number of cells containing values \u200b\u200bthat satisfy a certain logical condition;<\/span><\/li>\n<\/ul>\n<ol style=\"text-align: justify;\" start=\"13\">\n<li>\n<h2><b> MOD function<\/b><\/h2>\n<\/li>\n<\/ol>\n<ul style=\"text-align: justify;\">\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Syntax: MOD(value1, value2)<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Use: Returns the remainder in the division of value1 by value2;<\/span><\/li>\n<\/ul>\n<ol style=\"text-align: justify;\" start=\"14\">\n<li>\n<h2><b> INT function<\/b><\/h2>\n<\/li>\n<\/ol>\n<ul style=\"text-align: justify;\">\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Syntax: INT(decimal);<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Use: Returns the integer part of a decimal number;<\/span><\/li>\n<\/ul>\n<ol style=\"text-align: justify;\" start=\"15\">\n<li>\n<h2><b> ROUND rounding function<\/b><\/h2>\n<\/li>\n<\/ol>\n<ul style=\"text-align: justify;\">\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Syntax: ROUND(Value 1, n)<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Use: Round decimal number Value1;<\/span><\/li>\n<\/ul>\n<p style=\"text-align: justify;\"><i><span style=\"font-weight: 400;\">Note<\/span><\/i><span style=\"font-weight: 400;\">: if n&gt;0 then round to the number n after the decimal point; If n&lt; 0 then round to the number |n|+1 before the decimal point, the digits immediately following the |n|+1 digit before the decimal point are all converted to 0;<\/span><\/p>\n<ol style=\"text-align: justify;\" start=\"16\">\n<li>\n<h2><b> IF branching control function<\/b><\/h2>\n<\/li>\n<\/ol>\n<ul style=\"text-align: justify;\">\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Syntax: IF(Logic_Test, Value1, Value2)<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Use: <\/span>If the Logic_test expression is True, the IF statement returns the value Value1, otherwise it returns the value Value2;<\/li>\n<\/ul>\n<ol style=\"text-align: justify;\" start=\"17\">\n<li>\n<h2><b> VLOOKUP Search Function<\/b><\/h2>\n<\/li>\n<\/ol>\n<ul style=\"text-align: justify;\">\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Syntax: VLOOKUP(Value1, Table_Array, Col_Index, Range_Lookup)<\/span><\/li>\n<\/ul>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">Value1: The value to look up;<\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">Table_Array: The table of values \u200b\u200bto look up;<\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">Col_Index: The column number to get data from Table_Array;<\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">Range_Lookup: The search range (1: Relative search; 0: Exact search correct);<\/span><\/p>\n<ul style=\"text-align: justify;\">\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Use: <\/span>Returns the value of a cell corresponding to the Col_Index column in the Table_Array table and the row corresponding to the Value01 value found in the Table_Array table;<\/li>\n<\/ul>\n<ol style=\"text-align: justify;\" start=\"18\">\n<li>\n<h2><b> TODAY() function<\/b><\/h2>\n<\/li>\n<\/ol>\n<ul style=\"text-align: justify;\">\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Syntax: TODAY()<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Use: <\/span>Returns the current system date and time;<\/li>\n<\/ul>\n<ol style=\"text-align: justify;\" start=\"19\">\n<li>\n<h2><b> NOW() function<\/b><\/h2>\n<\/li>\n<\/ol>\n<ul style=\"text-align: justify;\">\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Syntax: NOW()<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Use: <\/span>Returns the current system date and time;<\/li>\n<\/ul>\n<ol style=\"text-align: justify;\" start=\"20\">\n<li>\n<h2><b> DAY function<\/b><\/h2>\n<\/li>\n<\/ol>\n<ul style=\"text-align: justify;\">\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Syntax: DAY(DateValue)<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Use: <\/span>Returns the day status of a value of the date-month-year data type<\/li>\n<\/ul>\n<ol style=\"text-align: justify;\" start=\"21\">\n<li>\n<h2><b> MONTH function<\/b><\/h2>\n<\/li>\n<\/ol>\n<ul style=\"text-align: justify;\">\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Syntax: MONTH(DateValue)<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Use: <\/span>Returns the month corresponding to the value of the date-month-year format or the number of days in the year;<\/li>\n<\/ul>\n<ol style=\"text-align: justify;\" start=\"22\">\n<li>\n<h2><b> YEAR function<\/b><\/h2>\n<\/li>\n<\/ol>\n<ul style=\"text-align: justify;\">\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Syntax: YEAR(DateValue)<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Use: <\/span>Returns the year corresponding to the date data type;<\/li>\n<\/ul>\n<ol style=\"text-align: justify;\" start=\"23\">\n<li>\n<h2><b> WEEKDAY function<\/b><\/h2>\n<\/li>\n<\/ol>\n<ul style=\"text-align: justify;\">\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Syntax: WEEKDAY(Datevalue)<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Use: <\/span>Returns the day of the week corresponding to the date-month-year data type;<\/li>\n<\/ul>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">The function returns a value in the range from 1 to 7 (corresponding to Sunday to Saturday);<\/span><\/p>\n<ol style=\"text-align: justify;\" start=\"24\">\n<li>\n<h2><b> AND function<\/b><\/h2>\n<\/li>\n<\/ol>\n<ul style=\"text-align: justify;\">\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Syntax: AND(Logic1, Logic2,\u2026)<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Use: <\/span>The function returns TRUE if the expressions Logic1, Logic1,\u2026 all return TRUE; The function returns FALSE when at least one Logic expression returns FALSE;<\/li>\n<\/ul>\n<ol style=\"text-align: justify;\" start=\"25\">\n<li>\n<h2><b> OR function<\/b><\/h2>\n<\/li>\n<\/ol>\n<ul style=\"text-align: justify;\">\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Syntax: OR(Logic1, Logic2,\u2026)<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Use: <\/span>The function returns the value TRUE if one of the expressions Logic1, Logic1,\u2026 returns the value TRUE; The function returns the value FALSE when all the expressions Logic1, Logic2,\u2026 return the value FALSE;<\/li>\n<\/ul>\n<ol style=\"text-align: justify;\" start=\"26\">\n<li>\n<h2><b> NOT function<\/b><\/h2>\n<\/li>\n<\/ol>\n<ul style=\"text-align: justify;\">\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Syntax: NOT(Logic)<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Use: <\/span>The function returns the negation value of a logical expression;<\/li>\n<\/ul>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">Through the article<\/span><b> Formulas for Excel functions for human resource management<\/b><span style=\"font-weight: 400;\">, ADSMO hopes that you will have more useful Excel functions for human resource management. However, instead of having to memorize all the above Excel functions, the HRM Plus human resource management software<span style=\"font-weight: 400;\"> can solve all problems for each business. <\/span><b><i>HRM Plus<\/i><\/b><span style=\"font-weight: 400;\"> is built and programmed with great care and dedication, and is always the top priority choice of thousands of businesses today. HRM Plus human resource software possesses dozens of different diverse features to support all tasks in human resource management.<\/span><\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">With time spent researching, testing and editing, HRM Plus has overcome most of the disadvantages of existing human resource management tracking software on the market <span style=\"font-weight: 400;\">as well as maximizing the strengths that a human resource management software should have. <\/span><span style=\"font-weight: 400;\">To experience the software <\/span><b><i>HRM Plus<\/i><\/b><span style=\"font-weight: 400;\"> right now, please contact<\/span><span style=\"font-weight: 400;\"> ADSMO via Hotline: <\/span><a href=\"tel: 0356105388\"><b>0356.105.388<\/b><\/a><span style=\"font-weight: 400;\"> &#8211; a software that helps businesses optimize human resource processes, improve work performance and save costs.<\/span><\/span><\/p>\n<p><em><strong>&gt;&gt;&gt;You may be interested in:<\/strong><\/em> <a href=\"https:\/\/adsmo.vn\/huong-dan-tao-bang-tinh-luong-trong-excel-va-cach-su-dung-cac-ham-thong-dung\/\"><strong>Instructions for Creating a Salary Table in Excel and How to Use Common Functions<\/strong><\/a><\/p>\n<div class=\"entry-contentsss\">\n<p>Contact ADSMO now &#8211; Specializing in providing customized business software solutions, consulting on building digital platforms with the mission.<\/p>\n<p><strong><b>TOTAL Solution, BREAKTHROUGH Development &#8211; Optimize COSTS &#8211; Increase PROFIT<\/b>. We are committed to providing you with:<\/strong><\/p>\n<ul>\n<li>Management solutions tailored to your business needs.<\/li>\n<li>Easy-to-use and efficient systems.<\/li>\n<li>Professional customer support services.<\/li>\n<\/ul>\n<p><b>Contact ADSMO now for a free consultation:<\/b><\/p>\n<ul>\n<li>Address:<strong><a href=\"https:\/\/www.google.com\/maps\/place\/ADSMO+Digital+Marketing+Marketing+Service+Traffic\/@20.91282,106.6718193,17z\/data=!3m1!4b1!4m5!3m4!1s0x314a7b6a35be4ead:0xae645af55cbb86de!8m2!3d20.91282!4d106.674008\" target=\"_blank\" rel=\"nofollow noopener\">8th Floor, HD Tower Building &#8211; 22 Pho Moi &#8211; Thuy Nguyen Ward &#8211; City. Hai Phong<\/a><\/strong><\/li>\n<li>Website:\u00a0<strong><a href=\"https:\/\/adsmo.vn\/en\/\">https:\/\/adsmo.vn<\/a><\/strong><\/li>\n<li>Email:\u00a0<strong><a href=\"mailto:info@adsmo.vn\">info@adsmo.vn<\/a><\/strong><\/li>\n<li>Hotline:\u00a0<strong><a href=\"tel: 0356105388\">0356 105 388<\/a><\/strong><\/li>\n<\/ul>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<p>Excel is an extremely powerful tool for calculating, processing and presenting spreadsheets. Currently, in all operations related&#8230;<\/p>\n","protected":false},"author":1,"featured_media":32131,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[255,252],"tags":[],"class_list":["post-33996","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-digital-transformation-knowledge","category-insights-hub"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v26.3 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Excel function for human resource management in business - ADSMO<\/title>\n<meta name=\"description\" content=\"Excel function for human resource management in business - ADSMO\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/adsmo.vn\/en\/excel-function-for-human-resource-management-in-business\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Excel function for human resource management in business - ADSMO\" \/>\n<meta property=\"og:description\" content=\"Excel function for human resource management in business - ADSMO\" \/>\n<meta property=\"og:url\" content=\"https:\/\/adsmo.vn\/en\/excel-function-for-human-resource-management-in-business\/\" \/>\n<meta property=\"og:site_name\" content=\"ADSMO\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/adsmo.vn\/\" \/>\n<meta property=\"article:published_time\" content=\"2023-08-26T09:04:37+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2026-03-09T04:38:34+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/adsmo.vn\/wp-content\/uploads\/2023\/08\/ham-excel-quan-ly-nhan-su.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"650\" \/>\n\t<meta property=\"og:image:height\" content=\"340\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"adsmo\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@Unikerycompany\" \/>\n<meta name=\"twitter:site\" content=\"@Unikerycompany\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"adsmo\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"6 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/adsmo.vn\/en\/excel-function-for-human-resource-management-in-business\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/adsmo.vn\/en\/excel-function-for-human-resource-management-in-business\/\"},\"author\":{\"name\":\"adsmo\",\"@id\":\"https:\/\/adsmo.vn\/#\/schema\/person\/43dbdd39e61acfcaba3d2e3dfa356a30\"},\"headline\":\"Excel function for human resource management in business\",\"datePublished\":\"2023-08-26T09:04:37+00:00\",\"dateModified\":\"2026-03-09T04:38:34+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/adsmo.vn\/en\/excel-function-for-human-resource-management-in-business\/\"},\"wordCount\":1028,\"publisher\":{\"@id\":\"https:\/\/adsmo.vn\/#organization\"},\"image\":{\"@id\":\"https:\/\/adsmo.vn\/en\/excel-function-for-human-resource-management-in-business\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/adsmo.vn\/wp-content\/uploads\/2023\/08\/ham-excel-quan-ly-nhan-su.jpg\",\"articleSection\":[\"Digital transformation knowledge\",\"Insights Hub\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/adsmo.vn\/en\/excel-function-for-human-resource-management-in-business\/\",\"url\":\"https:\/\/adsmo.vn\/en\/excel-function-for-human-resource-management-in-business\/\",\"name\":\"Excel function for human resource management in business - ADSMO\",\"isPartOf\":{\"@id\":\"https:\/\/adsmo.vn\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/adsmo.vn\/en\/excel-function-for-human-resource-management-in-business\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/adsmo.vn\/en\/excel-function-for-human-resource-management-in-business\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/adsmo.vn\/wp-content\/uploads\/2023\/08\/ham-excel-quan-ly-nhan-su.jpg\",\"datePublished\":\"2023-08-26T09:04:37+00:00\",\"dateModified\":\"2026-03-09T04:38:34+00:00\",\"description\":\"Excel function for human resource management in business - ADSMO\",\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/adsmo.vn\/en\/excel-function-for-human-resource-management-in-business\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/adsmo.vn\/en\/excel-function-for-human-resource-management-in-business\/#primaryimage\",\"url\":\"https:\/\/adsmo.vn\/wp-content\/uploads\/2023\/08\/ham-excel-quan-ly-nhan-su.jpg\",\"contentUrl\":\"https:\/\/adsmo.vn\/wp-content\/uploads\/2023\/08\/ham-excel-quan-ly-nhan-su.jpg\",\"width\":650,\"height\":340,\"caption\":\"Adsmo - Gi\u1ea3i Ph\u00e1p Digital Marketing T\u1ed5ng Th\u1ec3\"},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/adsmo.vn\/#website\",\"url\":\"https:\/\/adsmo.vn\/\",\"name\":\"ADSMO\",\"description\":\"Gi\u1ea3i ph\u00e1p ph\u1ea7n m\u1ec1m doanh nghi\u1ec7p t\u1ed5ng th\u1ec3\",\"publisher\":{\"@id\":\"https:\/\/adsmo.vn\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/adsmo.vn\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/adsmo.vn\/#organization\",\"name\":\"ADSMO\",\"url\":\"https:\/\/adsmo.vn\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/adsmo.vn\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/adsmo.vn\/wp-content\/uploads\/2025\/09\/cropped-cropped-ADSMO-Giai-Phap-Digital-Marketing-Tong-The-DOT-PHA-Traffic-2.png.png\",\"contentUrl\":\"https:\/\/adsmo.vn\/wp-content\/uploads\/2025\/09\/cropped-cropped-ADSMO-Giai-Phap-Digital-Marketing-Tong-The-DOT-PHA-Traffic-2.png.png\",\"width\":248,\"height\":93,\"caption\":\"ADSMO\"},\"image\":{\"@id\":\"https:\/\/adsmo.vn\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/adsmo.vn\/\",\"https:\/\/x.com\/Unikerycompany\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/adsmo.vn\/#\/schema\/person\/43dbdd39e61acfcaba3d2e3dfa356a30\",\"name\":\"adsmo\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/adsmo.vn\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/dc4d504a9acf09dd6bc4d7e4616f5c1e6ad54f757265d89e381815577c437ac1?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/dc4d504a9acf09dd6bc4d7e4616f5c1e6ad54f757265d89e381815577c437ac1?s=96&d=mm&r=g\",\"caption\":\"adsmo\"},\"url\":\"https:\/\/adsmo.vn\/en\/author\/admin\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Excel function for human resource management in business - ADSMO","description":"Excel function for human resource management in business - ADSMO","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/adsmo.vn\/en\/excel-function-for-human-resource-management-in-business\/","og_locale":"en_US","og_type":"article","og_title":"Excel function for human resource management in business - ADSMO","og_description":"Excel function for human resource management in business - ADSMO","og_url":"https:\/\/adsmo.vn\/en\/excel-function-for-human-resource-management-in-business\/","og_site_name":"ADSMO","article_publisher":"https:\/\/www.facebook.com\/adsmo.vn\/","article_published_time":"2023-08-26T09:04:37+00:00","article_modified_time":"2026-03-09T04:38:34+00:00","og_image":[{"width":650,"height":340,"url":"https:\/\/adsmo.vn\/wp-content\/uploads\/2023\/08\/ham-excel-quan-ly-nhan-su.jpg","type":"image\/jpeg"}],"author":"adsmo","twitter_card":"summary_large_image","twitter_creator":"@Unikerycompany","twitter_site":"@Unikerycompany","twitter_misc":{"Written by":"adsmo","Est. reading time":"6 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/adsmo.vn\/en\/excel-function-for-human-resource-management-in-business\/#article","isPartOf":{"@id":"https:\/\/adsmo.vn\/en\/excel-function-for-human-resource-management-in-business\/"},"author":{"name":"adsmo","@id":"https:\/\/adsmo.vn\/#\/schema\/person\/43dbdd39e61acfcaba3d2e3dfa356a30"},"headline":"Excel function for human resource management in business","datePublished":"2023-08-26T09:04:37+00:00","dateModified":"2026-03-09T04:38:34+00:00","mainEntityOfPage":{"@id":"https:\/\/adsmo.vn\/en\/excel-function-for-human-resource-management-in-business\/"},"wordCount":1028,"publisher":{"@id":"https:\/\/adsmo.vn\/#organization"},"image":{"@id":"https:\/\/adsmo.vn\/en\/excel-function-for-human-resource-management-in-business\/#primaryimage"},"thumbnailUrl":"https:\/\/adsmo.vn\/wp-content\/uploads\/2023\/08\/ham-excel-quan-ly-nhan-su.jpg","articleSection":["Digital transformation knowledge","Insights Hub"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/adsmo.vn\/en\/excel-function-for-human-resource-management-in-business\/","url":"https:\/\/adsmo.vn\/en\/excel-function-for-human-resource-management-in-business\/","name":"Excel function for human resource management in business - ADSMO","isPartOf":{"@id":"https:\/\/adsmo.vn\/#website"},"primaryImageOfPage":{"@id":"https:\/\/adsmo.vn\/en\/excel-function-for-human-resource-management-in-business\/#primaryimage"},"image":{"@id":"https:\/\/adsmo.vn\/en\/excel-function-for-human-resource-management-in-business\/#primaryimage"},"thumbnailUrl":"https:\/\/adsmo.vn\/wp-content\/uploads\/2023\/08\/ham-excel-quan-ly-nhan-su.jpg","datePublished":"2023-08-26T09:04:37+00:00","dateModified":"2026-03-09T04:38:34+00:00","description":"Excel function for human resource management in business - ADSMO","inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/adsmo.vn\/en\/excel-function-for-human-resource-management-in-business\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/adsmo.vn\/en\/excel-function-for-human-resource-management-in-business\/#primaryimage","url":"https:\/\/adsmo.vn\/wp-content\/uploads\/2023\/08\/ham-excel-quan-ly-nhan-su.jpg","contentUrl":"https:\/\/adsmo.vn\/wp-content\/uploads\/2023\/08\/ham-excel-quan-ly-nhan-su.jpg","width":650,"height":340,"caption":"Adsmo - Gi\u1ea3i Ph\u00e1p Digital Marketing T\u1ed5ng Th\u1ec3"},{"@type":"WebSite","@id":"https:\/\/adsmo.vn\/#website","url":"https:\/\/adsmo.vn\/","name":"ADSMO","description":"Gi\u1ea3i ph\u00e1p ph\u1ea7n m\u1ec1m doanh nghi\u1ec7p t\u1ed5ng th\u1ec3","publisher":{"@id":"https:\/\/adsmo.vn\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/adsmo.vn\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/adsmo.vn\/#organization","name":"ADSMO","url":"https:\/\/adsmo.vn\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/adsmo.vn\/#\/schema\/logo\/image\/","url":"https:\/\/adsmo.vn\/wp-content\/uploads\/2025\/09\/cropped-cropped-ADSMO-Giai-Phap-Digital-Marketing-Tong-The-DOT-PHA-Traffic-2.png.png","contentUrl":"https:\/\/adsmo.vn\/wp-content\/uploads\/2025\/09\/cropped-cropped-ADSMO-Giai-Phap-Digital-Marketing-Tong-The-DOT-PHA-Traffic-2.png.png","width":248,"height":93,"caption":"ADSMO"},"image":{"@id":"https:\/\/adsmo.vn\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/adsmo.vn\/","https:\/\/x.com\/Unikerycompany"]},{"@type":"Person","@id":"https:\/\/adsmo.vn\/#\/schema\/person\/43dbdd39e61acfcaba3d2e3dfa356a30","name":"adsmo","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/adsmo.vn\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/dc4d504a9acf09dd6bc4d7e4616f5c1e6ad54f757265d89e381815577c437ac1?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/dc4d504a9acf09dd6bc4d7e4616f5c1e6ad54f757265d89e381815577c437ac1?s=96&d=mm&r=g","caption":"adsmo"},"url":"https:\/\/adsmo.vn\/en\/author\/admin\/"}]}},"_links":{"self":[{"href":"https:\/\/adsmo.vn\/en\/wp-json\/wp\/v2\/posts\/33996","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/adsmo.vn\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/adsmo.vn\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/adsmo.vn\/en\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/adsmo.vn\/en\/wp-json\/wp\/v2\/comments?post=33996"}],"version-history":[{"count":3,"href":"https:\/\/adsmo.vn\/en\/wp-json\/wp\/v2\/posts\/33996\/revisions"}],"predecessor-version":[{"id":38259,"href":"https:\/\/adsmo.vn\/en\/wp-json\/wp\/v2\/posts\/33996\/revisions\/38259"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/adsmo.vn\/en\/wp-json\/wp\/v2\/media\/32131"}],"wp:attachment":[{"href":"https:\/\/adsmo.vn\/en\/wp-json\/wp\/v2\/media?parent=33996"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/adsmo.vn\/en\/wp-json\/wp\/v2\/categories?post=33996"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/adsmo.vn\/en\/wp-json\/wp\/v2\/tags?post=33996"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}