{"id":11099,"date":"2025-01-15T01:23:18","date_gmt":"2025-01-15T01:23:18","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2025\/01\/15\/ham-cong-thuc-excel-su-dung-trong-ke-toan-tien-luong-nhan-su\/"},"modified":"2025-01-15T01:23:18","modified_gmt":"2025-01-15T01:23:18","slug":"ham-cong-thuc-excel-su-dung-trong-ke-toan-tien-luong-nhan-su","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2025\/01\/15\/ham-cong-thuc-excel-su-dung-trong-ke-toan-tien-luong-nhan-su\/","title":{"rendered":"H\u00e0m, c\u00f4ng th\u1ee9c Excel s\u1eed d\u1ee5ng trong k\u1ebf to\u00e1n ti\u1ec1n l\u01b0\u01a1ng, nh\u00e2n s\u1ef1"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-nJy84WMn#1\">\n<p>B\u1ea1n c\u00f2n\u00a0\u0111ang l\u00e0 sinh vi\u00ean, hay b\u1ea1n\u00a0\u0111\u00e3 ra tr\u01b0\u1eddng v\u00e0\u00a0\u0111ang\u00a0\u0111i xin vi\u1ec7c, hay b\u1ea1n\u00a0\u0111ang l\u00e0m nh\u00e2n vi\u00ean k\u1ebf to\u00e1n ti\u1ec1n l\u01b0\u01a1ng, khi g\u1eb7p ph\u1ea3i c\u00e2u h\u1ecfi: Khi l\u00e0m k\u1ebf to\u00e1n ti\u1ec1n l\u01b0\u01a1ng tr\u00ean\u00a0excel th\u01b0\u1eddng s\u1eed d\u1ee5ng c\u00f4ng th\u1ee9c n\u00e0o? , h\u1eb3n nhi\u1ec1u b\u1ea1n s\u1ebd r\u1ea5t b\u1ed1i r\u1ed1i.<\/p>\n<p>Trong b\u00e0i vi\u1ebft n\u00e0y, chu\u0301ng t\u00f4i\u00a0s\u1ebd h\u01b0\u01a1\u0301ng d\u00e2\u0303n cho ca\u0301c ba\u0323n ca\u0301ch <a href=\"http:\/\/blog.ezworkapp.com\">ho\u0323c excel ta\u0323i nha\u0300<\/a>\u00a0va\u0300 co\u0301 th\u00ea\u0309\u00a0n\u1eafm\u00a0\u0111\u01b0\u1ee3c c\u00e1ch s\u1eed d\u1ee5ng c\u00e1c h\u00e0m th\u01b0\u1eddng d\u00f9ng trong c\u00f4ng vi\u1ec7c k\u1ebf to\u00e1n ti\u1ec1n l\u01b0\u01a1ng.<\/p>\n<p><strong>1. Khi l\u00e0m k\u1ebf to\u00e1n ti\u1ec1n l\u01b0\u01a1ng, b\u1ea1n ph\u1ea3i n\u1eafm\u00a0\u0111\u01b0\u1ee3c danh s\u00e1ch nh\u00e2n vi\u00ean c\u1ee7a c\u00f4ng ty, th\u00f4ng tin v\u1ec1 h\u1ee3p \u0111\u1ed3ng lao \u0111\u1ed9ng c\u1ee7a m\u1ed7i ng\u01b0\u1eddi. V\u00ec v\u1eady c\u00e1c h\u00e0m truy v\u1ea5n, t\u00ecm ki\u1ebfm s\u1ebd th\u01b0\u1eddng s\u1eed d\u1ee5ng\u00a0\u0111\u1ec3 tra c\u1ee9u th\u00f4ng tin nh\u00e2n vi\u00ean c\u00f3 trong b\u1ea3ng danh s\u00e1ch nh\u00e2n vi\u00ean.<\/strong><\/p>\n<ul>\n<li><a href=\"http:\/\/blog.ezworkapp.com\/ham-vlookup-trong-excel-huong-dan-su-dung-chi-tiet-va-co-vi-du-cu-the.html\">H\u00e0m VLOOKUP<\/a>(lookup_value,table_array,col_index_num,[range_lookup]): h\u00e0m truy v\u1ea5n, t\u00ecm ki\u1ebfm th\u00f4ng d\u1ee5ng nh\u1ea5t. Tuy nhi\u00ean\u00a0\u0111\u1ed1i t\u01b0\u1ee3ng t\u00ecm ki\u1ebfm (lookup_value = M\u00e3 nh\u00e2n vi\u00ean \/ T\u00ean nh\u00e2n vi\u00ean) ph\u1ea3i n\u1eb1m trong c\u1ed9t\u00a0\u0111\u1ea7u ti\u00ean b\u00ean tr\u00e1i v\u00f9ng b\u1ea3ng t\u00ecm ki\u1ebfm (table_array = B\u1ea3ng Danh s\u00e1ch nh\u00e2n vi\u00ean)<\/li>\n<\/ul>\n<ul>\n<li>H\u00e0m INDEX+MATCH: k\u1ebft h\u1ee3p 2 h\u00e0m n\u00e0y v\u1edbi nhau \u0111\u1ec3 truy v\u1ea5n, t\u00ecm ki\u1ebfm th\u00f4ng tin. V\u1ec1 t\u00ednh n\u0103ng th\u00ec 2 h\u00e0m n\u00e0y c\u00f3\u00a0hi\u1ec7u qu\u1ea3 cao h\u01a1n h\u00e0m vlookup, kh\u00f4ng b\u1ecb gi\u1edbi h\u1ea1n c\u1ea5u tr\u00fac b\u1ea3ng t\u00ecm ki\u1ebfm nh\u01b0\u00a0\u0111\u00e3 n\u00f3i\u00a0\u1edf tr\u00ean,\u00a0\u0111\u1ec3 t\u00ecm hi\u1ec3u c\u00e1ch d\u00f9ng h\u00e0m index+match th\u1ebf n\u00e0o m\u1eddi c\u00e1c b\u1ea1n tham kh\u1ea3o b\u00e0i vi\u1ebft sau:<\/li>\n<\/ul>\n<blockquote>\n<p>T\u00ecm hi\u1ec3u ngay:\u00a0<a href=\"http:\/\/blog.ezworkapp.com\/khoa-hoc-excel-ke-toan.html\">l\u01a1\u0301p h\u1ecdc Excel k\u1ebf to\u00e1n<\/a> 1 th\u1ea7y 1 tr\u00f2<\/p>\n<\/blockquote>\n<p><strong>2. Vi\u1ec7c ch\u1ea5m c\u00f4ng, t\u00ednh l\u01b0\u01a1ng th\u1ef1c hi\u1ec7n theo th\u00e1ng, v\u00ec v\u1eady nh\u1eefng h\u00e0m x\u1eed l\u00fd ng\u00e0y th\u00e1ng, th\u1eddi gian trong\u00a0excel c\u0169ng th\u01b0\u1eddng\u00a0\u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng:<\/strong><\/p>\n<ul>\n<li>H\u00e0m DATE(year,month,day): t\u1ea1o ra 1 gi\u00e1 tr\u1ecb ng\u00e0y th\u00e1ng x\u00e1c\u00a0\u0111\u1ecbnh r\u00f5 b\u1edfi n\u0103m, th\u00e1ng, ng\u00e0y<\/li>\n<\/ul>\n<blockquote>\n<p>Tham kh\u1ea3o b\u00e0i vi\u1ebft: <a href=\"http:\/\/blog.ezworkapp.com\/ham-cong-thuc-su%E2%80%A6nhan-su-ham-date.html\">\u1ee8ng d\u1ee5ng c\u1ee7a h\u00e0m DATE: khi mu\u1ed1n x\u00e1c\u00a0\u0111\u1ecbnh ng\u00e0y\u00a0\u0111\u1ea7u v\u00e0 ng\u00e0y cu\u1ed1i c\u1ee7a c\u00e1c th\u00e1ng trong n\u0103m.<\/a><\/p>\n<\/blockquote>\n<ul>\n<li>H\u00e0m YEAR(serial_number) : theo d\u00f5i s\u1ed1 n\u0103m c\u1ee7a 1 gi\u00e1 tr\u1ecb ng\u00e0y th\u00e1ng<\/li>\n<li>H\u00e0m MONTH(serial_number): theo d\u00f5i s\u1ed1 th\u00e1ng c\u1ee7a 1 gi\u00e1 tr\u1ecb ng\u00e0y th\u00e1ng<\/li>\n<li>H\u00e0m DAY(serial_number): theo d\u00f5i s\u1ed1 ng\u00e0y c\u1ee7a 1 gi\u00e1 tr\u1ecb ng\u00e0y th\u00e1ng<\/li>\n<li>H\u00e0m HOUR(serial_number): theo d\u00f5i s\u1ed1 gi\u1edd c\u1ee7a 1 gi\u00e1 tr\u1ecb th\u1eddi gian<\/li>\n<li>H\u00e0m MIN(serial_number): theo d\u00f5i s\u1ed1 ph\u00fat c\u1ee7a 1 gi\u00e1 tr\u1ecb th\u1eddi gian<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-11421 aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/ham-cong-thuc-excel-su-dung-trong-ke-toan-tien-luong.jpeg\" alt=\"H\u00e0m, c\u00f4ng th\u1ee9c excel s\u1eed d\u1ee5ng trong k\u1ebf to\u00e1n ti\u1ec1n l\u01b0\u01a1ng\" width=\"600\" height=\"398\" title=\"ham-cong-thuc-excel-su-dung-trong-ke-toan-tien-luong\"><\/p>\n<p><strong>3.\u00a0\u0110\u1ec3 ch\u1ea5m c\u00f4ng l\u00e0m vi\u1ec7c c\u1ee7a nh\u00e2n vi\u00ean trong c\u00f4ng ty, th\u01b0\u1eddng s\u1eed d\u1ee5ng c\u00e1c c\u00f4ng th\u1ee9c sau:<\/strong><\/p>\n<ul>\n<li>COUNTIF :\u00a0\u0110\u1ebfm s\u1ed1\u00a0k\u00fd hi\u1ec7u c\u00f4ng trong b\u1ea3ng ch\u1ea5m c\u00f4ng (theo 1\u00a0\u0111i\u1ec1u ki\u1ec7n duy nh\u1ea5t)<\/li>\n<\/ul>\n<p>Tham kh\u1ea3o b\u00e0i vi\u1ebft:\u00a0<a href=\"http:\/\/blog.ezworkapp.com\/ham-cong-thuc-excel-su-dung-trong-ke-toan-tien-luong-nhan-su-countif.html\">H\u00e0m, c\u00f4ng th\u1ee9c Excel s\u1eed d\u1ee5ng trong k\u1ebf to\u00e1n ti\u1ec1n l\u01b0\u01a1ng, nh\u00e2n s\u1ef1: COUNTIF<\/a><\/p>\n<ul>\n<li>COUNTIFS :\u00a0\u0110\u1ebfm s\u1ed1\u00a0k\u00fd hi\u1ec7u c\u00f4ng trong b\u1ea3ng ch\u1ea5m c\u00f4ng (theo nhi\u1ec1u\u00a0\u0111i\u1ec1u ki\u1ec7n c\u00f9ng l\u00fac)<\/li>\n<li>SUMIF : T\u00ednh t\u1ed5ng s\u1ed1\u00a0gi\u1edd c\u00f4ng trong b\u1ea3ng ch\u1ea5m c\u00f4ng (theo 1\u00a0\u0111i\u1ec1u ki\u1ec7n duy nh\u1ea5t)<\/li>\n<li>SUMIFS : T\u00ednh t\u1ed5ng s\u1ed1\u00a0gi\u1edd c\u00f4ng trong b\u1ea3ng ch\u1ea5m c\u00f4ng\u00a0(theo\u00a0nhi\u1ec1u\u00a0\u0111i\u1ec1u ki\u1ec7n c\u00f9ng l\u00fac)<\/li>\n<\/ul>\n<p><strong>4.\u00a0\u0110\u1ec3 t\u00ednh l\u01b0\u01a1ng cho nh\u00e2n vi\u00ean, th\u01b0\u1eddng s\u1eed d\u1ee5ng c\u00e1c c\u00f4ng th\u1ee9c sau:<\/strong><\/p>\n<div class=\"code-block code-block-3\" style=\"margin: 8px 0;clear: both\">\n<div class=\"ad-inserterpro\">\n<p>D\u00f9 \u0111\u00e3 c\u00f3 ph\u1ea7n m\u1ec1m, nh\u01b0ng k\u1ef9 n\u0103ng Excel v\u1eabn c\u1ef1c k\u1ef3 quan tr\u1ecdng v\u1edbi k\u1ebf to\u00e1n, b\u1ea1n \u0111\u00e3 v\u1eefng Excel ch\u01b0a? H\u00e3y \u0111\u1ec3 t\u00f4i gi\u00fap b\u1ea1n, \u0111\u0103ng k\u00fd kho\u00e1 h\u1ecdc Excel:<\/p>\n<p><a href=\"https:\/\/hocexcel.online\/course\/preview\/ex101-excel-tu-co-ban-den-chuyen-gia-danh-cho-nguoi-di-lam\"><br \/>\n<img decoding=\"async\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/ex101_92019-nho-257.gif\" title=\"ex101_92019-nho-257\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<div class=\"code-block code-block-2\" style=\"margin: 8px 0;clear: both\">\n<div class=\"ad-inserterpro\">\n<a href=\"https:\/\/hocexcel.online\/course\/preview\/vba101-tu-dong-hoa-excel-voi-lap-trinh-vba-cho-nguoi-moi-bat-dau\"><br \/>\n<img decoding=\"async\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/vba101_92019-nho-32.gif\" title=\"vba101_92019-nho-32\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<div class=\"code-block code-block-1\" style=\"margin: 8px 0;clear: both\">\n<div class=\"ad-inserterpro\">\n<a href=\"https:\/\/hocexcel.online\/course\/preview\/ex101-excel-tu-co-ban-den-chuyen-gia-danh-cho-nguoi-di-lam\"><br \/>\n<img decoding=\"async\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/ex101_92019-nho-257.gif\" title=\"ex101_92019-nho-257\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<ul>\n<li>IF : C\u1ea7n bi\u1ec7n lu\u1eadn logic trong vi\u1ec7c t\u00ednh to\u00e1n trong 1 s\u1ed1 tr\u01b0\u1eddng h\u1ee3p (N\u1ebfu theo y\u00eau c\u1ea7u 1 th\u00ec k\u1ebft qu\u1ea3 l\u00e0 g\u00ec, n\u1ebfu kh\u00f4ng th\u1ecfa m\u00e3n y\u00eau c\u1ea7u 1 th\u00ec k\u1ebft qu\u1ea3 l\u00e0 g\u00ec)<\/li>\n<li>H\u00e0m AND \/\u00a0OR : Khi c\u1ea7n bi\u1ec7n lu\u1eadn nhi\u1ec1u\u00a0\u0111i\u1ec1u ki\u1ec7n k\u1ebft h\u1ee3p nhau th\u00ec s\u1ebd s\u1eed d\u1ee5ng h\u00e0m And\/Or\u00a0\u0111\u1ec3 gh\u00e9p n\u1ed1i c\u00e1c\u00a0\u0111i\u1ec1u ki\u1ec7n trong h\u00e0m\u00a0IF<\/li>\n<li>H\u00e0m LOOKUP \/ VLOOKUP : Truy v\u1ea5n t\u1edbi c\u00e1c n\u1ed9i dung: Th\u00f4ng tin t\u00ednh l\u01b0\u01a1ng, th\u00f4ng tin nh\u00e2n vi\u00ean, k\u1ebft qu\u1ea3 ch\u1ea5m c\u00f4ng\u2026<\/li>\n<li>H\u00e0m SUM \/ SUMIF \/ SUMIFS : T\u00ednh t\u1ed5ng (c\u00f3\u00a0\u0111i\u1ec1u ki\u1ec7n ho\u1eb7c kh\u00f4ng) c\u00e1c n\u1ed9i dung ti\u1ec1n l\u01b0\u01a1ng.<\/li>\n<\/ul>\n<p>\u0110\u1ec3 n\u1eafm \u0111\u01b0\u1ee3c nh\u1eefng ki\u1ebfn th\u1ee9c v\u00e0 c\u00e1ch \u1ee9ng d\u1ee5ng Excel trong c\u00f4ng vi\u1ec7c h\u00e0nh ch\u00ednh-nh\u00e2n s\u1ef1, m\u1eddi b\u1ea1n tham gia kh\u00f3a h\u1ecdc\u00a0<a href=\"http:\/\/bit.ly\/2opk8hB\">H\u00e0nh ch\u00ednh nh\u00e2n s\u1ef1 t\u1eeb A-Z c\u1ee7a H\u1ecdc Excel Online<\/a>. Kh\u00f3a h\u1ecdc n\u00e0y\u00a0s\u1ebd h\u01b0\u1edbng d\u1eabn b\u1ea1n c\u00e1ch s\u1eed d\u1ee5ng nh\u1eefng k\u1ef9 n\u0103ng tin h\u1ecdc v\u0103n ph\u00f2ng c\u0103n b\u1ea3n, c\u00e1ch \u00e1p d\u1ee5ng word, excel v\u00e0o t\u1eebng ph\u1ea7n vi\u1ec7c c\u1ee5 th\u1ec3 c\u1ee7a H\u00e0nh ch\u00ednh nh\u00e2n s\u1ef1. Ngo\u00e0i ra khi tham d\u1ef1 kh\u00f3a h\u1ecdc n\u00e0y, b\u1ea1n c\u00f2n \u0111\u01b0\u1ee3c t\u1eb7ng nh\u1eefng ch\u01b0\u01a1ng tr\u00ecnh, t\u00e0i li\u1ec7u h\u1ea5p d\u1eabn, h\u1eefu \u00edch \u0111\u1ec3 s\u1eed d\u1ee5ng ngay trong c\u00f4ng vi\u1ec7c.<\/p>\n<p>\u0110\u00e2y l\u00e0 kh\u00f3a h\u1ecdc Online n\u00ean kh\u00f4ng c\u00f3 gi\u1edbi h\u1ea1n v\u1ec1 th\u1eddi gian h\u1ecdc, b\u1ea1n c\u00f3 th\u1ec3 h\u1ecdc l\u1ea1i nhi\u1ec1u l\u1ea7n cho t\u1edbi khi l\u00e0m ch\u1ee7 ki\u1ebfn th\u1ee9c. Hi\u1ec7n nay h\u1ec7 th\u1ed1ng \u0111ang c\u00f3 \u01b0u \u0111\u00e3i r\u1ea5t h\u1ea5p d\u1eabn khi b\u1ea1n \u0111\u0103ng k\u00fd kh\u00f3a h\u1ecdc n\u00e0y.\u00a0Chi ti\u1ebft xem t\u1ea1i:<\/p>\n<p>\u00a0<\/p>\n<\/div>\n<div class=\"uk-panel uk-margin uk-width-xlarge\">\n<p>Click \u0111\u0103ng k\u00fd h\u1ecdc t\u1ea1i:<\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/khoa-hoc\" target=\"_blank\" rel=\"noopener\">T\u1ea5t c\u1ea3 kho\u00e1 h\u1ecdc\u00a0<span>\ud83d\udcd6<\/span><\/a><\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/huong-dan-kich-hoat-khoa-hoc-tai-hoc-excel-online.html\" target=\"_blank\" rel=\"noopener\">H\u01b0\u1edbng d\u1eabn k\u00edch ho\u1ea1t<\/a><\/p>\n<p>HKD H\u1ecdc Excel Online<br \/>S\u1ed1 \u0110K: 17A80048102<\/p>\n<\/div>\n<div class=\"uk-panel uk-text-small uk-margin uk-margin-remove-bottom uk-text-center\">\n<p>\u00a9  document.currentScript.insertAdjacentHTML(&#8216;afterend&#8217;, &#8221; + new Intl.DateTimeFormat(document.documentElement.lang, {year: &#8216;numeric&#8217;}).format() + &#8221;);  H\u1ecdc Excel Online. All rights reserved.<\/p>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<div class=\"ad-inserterpro\">\n<p>D\u00f9 \u0111\u00e3 c\u00f3 ph\u1ea7n m\u1ec1m, nh\u01b0ng k\u1ef9 n\u0103ng Excel v\u1eabn c\u1ef1c k\u1ef3 quan tr\u1ecdng v\u1edbi k\u1ebf to\u00e1n, b\u1ea1n \u0111\u00e3 v\u1eefng Excel ch\u01b0a? H\u00e3y \u0111\u1ec3 t\u00f4i gi\u00fap b\u1ea1n, \u0111\u0103ng k\u00fd kho\u00e1 h\u1ecdc Excel:<\/p>\n<p><a href=\"https:\/\/hocexcel.online\/course\/preview\/ex101-excel-tu-co-ban-den-chuyen-gia-danh-cho-nguoi-di-lam\"><br \/>\n<img decoding=\"async\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/ex101_92019-nho-257.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":11100,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[],"class_list":["post-11099","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-excel-co-ban"],"_links":{"self":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/11099","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/comments?post=11099"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/11099\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/11100"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=11099"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=11099"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=11099"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}