{"id":80459,"date":"2024-08-20T08:59:29","date_gmt":"2024-08-20T01:59:29","guid":{"rendered":"http:\/\/amis.misa.vn\/?p=80459"},"modified":"2024-11-29T15:08:14","modified_gmt":"2024-11-29T08:08:14","slug":"quan-ly-nhan-su-mien-phi-bang-excel","status":"publish","type":"post","link":"https:\/\/amis.misa.vn\/80459\/quan-ly-nhan-su-mien-phi-bang-excel\/","title":{"rendered":"Ph\u1ea7n m\u1ec1m qu\u1ea3n l\u00fd nh\u00e2n s\u1ef1 b\u1eb1ng Excel Mi\u1ec5n ph\u00ed, chu\u1ea9n nh\u1ea5t"},"content":{"rendered":"<p style=\"text-align: justify;\">Qu\u1ea3n l\u00fd nh\u00e2n s\u1ef1 b\u1eb1ng Excel l\u00e0 m\u1ed9t h\u00ecnh th\u1ee9c qu\u1ea3n l\u00fd \u0111\u01b0\u1ee3c r\u1ea5t nhi\u1ec1u doanh nghi\u1ec7p \u00e1p d\u1ee5ng. H\u00ecnh th\u1ee9c n\u00e0y \u0111\u00e3 tr\u1edf n\u00ean qu\u00e1 th\u00e2n thu\u1ed9c v\u00e0 ph\u1ed5 bi\u1ebfn t\u1ea1i nhi\u1ec1u c\u00f4ng ty, doanh nghi\u1ec7p t\u1eeb l\u1edbn t\u1edbi nh\u1ecf. V\u1eady \u0111\u1ec3 t\u1ea1o l\u1eadp v\u00e0 s\u1eed d\u1ee5ng \u0111\u01b0\u1ee3c file\/ ph\u1ea7n m\u1ec1m Excel qu\u1ea3n l\u00fd nh\u00e2n s\u1ef1 ph\u1ea3i l\u00e0m nh\u01b0 th\u1ebf n\u00e0o? H\u00e3y c\u00f9ng v\u1edbi <a href=\"https:\/\/amis.misa.vn\/amis-nhan-su\/\" target=\"_blank\" rel=\"noopener\"><strong>MISA AMIS Nh\u00e2n s\u1ef1<\/strong><\/a>\u00a0t\u00ecm hi\u1ec3u nh\u1eefng c\u00e1ch s\u1eed d\u1ee5ng\u00a0excel qu\u1ea3n l\u00fd nh\u00e2n s\u1ef1 nhanh nh\u1ea5t nh\u00e9.<\/p>\n<h2 style=\"text-align: justify;\"><b>1. Qu\u1ea3n l\u00fd nh\u00e2n s\u1ef1 mi\u1ec5n ph\u00ed b\u1eb1ng excel l\u00e0 g\u00ec?<\/b><\/h2>\n<blockquote>\n<p style=\"text-align: justify;\"><span style=\"font-size: 14pt;\"><span style=\"font-weight: 400;\"><a href=\"https:\/\/amis.misa.vn\/80459\/quan-ly-nhan-su-mien-phi-bang-excel\/\" target=\"_blank\" rel=\"noopener\"><strong>Ph\u1ea7n m\u1ec1m Qu\u1ea3n l\u00fd nh\u00e2n s\u1ef1 b\u1eb1ng excel mi\u1ec5n ph\u00ed<\/strong> <\/a>l\u00e0 qu\u1ea3n l\u00fd t\u1ea5t t\u1ea7n t\u1eadt c\u00e1c th\u00f4ng tin bao g\u1ed3m: <\/span><i><span style=\"font-weight: 400;\">m\u00e3 nh\u00e2n vi\u00ean, b\u1ed9 ph\u1eadn, v\u1ecb tr\u00ed c\u00f4ng vi\u1ec7c c\u1ee7a t\u1eebng nh\u00e2n vi\u00ean, c\u00e1c lo\u1ea1i h\u00ecnh nh\u00e2n s\u1ef1,\u2026 <\/span><\/i><span style=\"font-weight: 400;\">c\u1ee7a c\u00f4ng ty tr\u00ean Excel.\u00a0<\/span><\/span><\/p>\n<\/blockquote>\n<figure id=\"attachment_80460\" aria-describedby=\"caption-attachment-80460\" style=\"width: 1024px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-80460 size-full\" src=\"\/wp-content\/uploads\/2023\/01\/phan-mem-quan-ly-nhan-su-bang-excel-1.jpg\" alt=\"Ph\u1ea7n m\u1ec1m qu\u1ea3n l\u00fd nh\u00e2n s\u1ef1 mi\u1ec5n ph\u00ed b\u1eb1ng Excel\" width=\"1024\" height=\"575\" srcset=\"\/wp-content\/uploads\/2023\/01\/phan-mem-quan-ly-nhan-su-bang-excel-1.jpg 1024w, \/wp-content\/uploads\/2023\/01\/phan-mem-quan-ly-nhan-su-bang-excel-1-500x281.jpg 500w, \/wp-content\/uploads\/2023\/01\/phan-mem-quan-ly-nhan-su-bang-excel-1-768x431.jpg 768w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><figcaption id=\"caption-attachment-80460\" class=\"wp-caption-text\">Ph\u1ea7n m\u1ec1m qu\u1ea3n l\u00fd nh\u00e2n s\u1ef1 mi\u1ec5n ph\u00ed b\u1eb1ng Excel<\/figcaption><\/figure>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">Ph\u1ea7n m\u1ec1m qu\u1ea3n l\u00fd nh\u00e2n s\u1ef1 mi\u1ec5n ph\u00ed b\u1eb1ng Excel \u0111\u01b0\u1ee3c r\u1ea5t nhi\u1ec1u ng\u01b0\u1eddi l\u00e0m nh\u00e2n s\u1ef1 s\u1eed d\u1ee5ng. \u0110\u00e2y l\u00e0 c\u00f4ng c\u1ee5 \u0111\u01b0\u1ee3c thi\u1ebft k\u1ebf kh\u00e1 tr\u1ef1c quan v\u00e0 v\u00f4 c\u00f9ng th\u00e2n thi\u1ec7n v\u1edbi ng\u01b0\u1eddi d\u00f9ng. Ch\u00fang th\u1ec3 hi\u1ec7n r\u00f5 c\u00e1c y\u00eau c\u1ea7u qu\u1ea3n l\u00fd t\u1eeb cao t\u1edbi th\u1ea5p c\u1ee7a doanh nghi\u1ec7p, cho ph\u00e9p nh\u00e2n vi\u00ean v\u00e0 qu\u1ea3n l\u00fd quan s\u00e1t \u0111\u01b0\u1ee3c ti\u1ebfn \u0111\u1ed9 l\u00e0m vi\u1ec7c c\u1ee7a nh\u00e2n vi\u00ean v\u00e0 gi\u00fap nh\u00e2n vi\u00ean t\u00ednh \u0111\u01b0\u1ee3c l\u01b0\u01a1ng v\u00e0 quan s\u00e1t \u0111\u01b0\u1ee3c s\u1ed1 ng\u00e0y, gi\u1edd \u0111i l\u00e0m c\u1ee7a m\u00ecnh.<\/span><\/p>\n<p><!-- AMIS aiMarketing Form Embed Code --><\/p>\n<div class=\"aimarketing-form-embed-code\"><script env=production id=\"ladizone-form-renderer\" src=\"https:\/\/amismisa.misacdn.net\/apps\/aimarketing\/form-editor\/static\/js\/form-renderer.js\"><\/script><br \/>\n<script render-for=\"d22f9ab4-f238-4968-97cb-0276def326c9\">\n                    globalThis.lzfr.renderExternalForm({formId: \"d22f9ab4-f238-4968-97cb-0276def326c9\", tenantId: \"56c33c47-78ec-4b3a-92ba-9fdb7830a6d4\", domainUnomi: \"https:\/\/ladizone.com\" });\n                <\/script><\/div>\n<p><!-- end AMIS aiMarketing Form Embed Code --><\/p>\n<h2 style=\"text-align: justify;\"><b>2. \u01afu nh\u01b0\u1ee3c \u0111i\u1ec3m c\u1ee7a excel khi qu\u1ea3n l\u00fd nh\u00e2n s\u1ef1<\/b><\/h2>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">Qu\u1ea3n l\u00fd nh\u00e2n s\u1ef1 mi\u1ec5n ph\u00ed b\u1eb1ng Excel gi\u00fap h\u1ed7 tr\u1ee3 t\u1ed1i \u0111a ng\u01b0\u1eddi qu\u1ea3n l\u00fd nh\u00e2n s\u1ef1 b\u1eb1ng c\u00e1c t\u00ednh n\u0103ng b\u1ed5 tr\u1ee3. Song \u0111i c\u00f9ng v\u1edbi nh\u1eefng \u01b0u \u0111i\u1ec3m th\u00ec v\u1eabn c\u00f2n m\u1ed9t s\u1ed1 h\u1ea1n ch\u1ebf khi\u1ebfn ng\u01b0\u1eddi d\u00f9ng khi s\u1eed d\u1ee5ng g\u1eb7p m\u1ed9t s\u1ed1 r\u1eafc r\u1ed1i nh\u1ecf. <\/span><\/p>\n<h3 style=\"text-align: justify;\"><b>2.1 \u01afu \u0111i\u1ec3m<\/b><\/h3>\n<ul style=\"text-align: justify;\">\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Khi s\u1eed d\u1ee5ng excel, b\u1ea1n s\u1ebd \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng ho\u00e0n to\u00e0n mi\u1ec5n ph\u00ed m\u00e0 kh\u00f4ng c\u1ea7n ph\u1ea3i tr\u1ea3 b\u1ea5t c\u1ee9 m\u1ed9t chi ph\u00ed n\u00e0o<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Khi s\u1eed d\u1ee5ng tr\u00ean File Excel, b\u1ea1n s\u1ebd \u0111\u01b0\u1ee3c l\u01b0u tr\u1eef h\u1ed3 s\u01a1 nh\u00e2n vi\u00ean c\u1ee7a m\u00ecnh \u0111\u1ea7y \u0111\u1ee7, ch\u00ednh x\u00e1c v\u00e0 chi ti\u1ebft nh\u1ea5t. Ngo\u00e0i ra vi\u1ec7c l\u01b0u tr\u00ean file c\u00f2n h\u1ea1n ch\u1ebf kh\u1ea3 n\u0103ng b\u1ecb m\u1ea5t so v\u1edbi c\u00e1ch s\u1eed d\u1ee5ng c\u1ee7a ph\u01b0\u01a1ng th\u1ee9c truy\u1ec1n th\u1ed1ng nh\u01b0 tr\u00ean gi\u1ea5y t\u1edd b\u00ecnh th\u01b0\u1eddng.\u00a0<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Qu\u1ea3n tr\u1ecb nh\u00e2n s\u1ef1 tr\u00ean Excel, b\u1ea1n s\u1ebd \u0111\u01b0\u1ee3c d\u00f9ng r\u1ea5t nhi\u1ec1u ki\u1ec3u bi\u1ec3u m\u1eabu kh\u00e1c nhau, tho\u1ea3i m\u00e1i cho b\u1ea1n l\u1ef1a ch\u1ecdn \u0111\u1ec3 sao cho ph\u00f9 h\u1ee3p v\u1edbi doanh nghi\u1ec7p c\u1ee7a m\u00ecnh<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Qua c\u00e1c file qu\u1ea3n l\u00fd, nh\u00e2n vi\u00ean c\u00f2n c\u00f3 th\u1ec3 th\u01b0\u1eddng xuy\u00ean c\u1eadp nh\u1eadt, so s\u00e1nh \u0111\u1ed1i chi\u1ebfu \u0111\u1ec3 xem th\u1eed k\u1ebft qu\u1ea3 c\u1ee7a m\u00ecnh \u0111\u00e3 chu\u1ea9n v\u00e0 ch\u00ednh x\u00e1c ch\u01b0a?<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">C\u00e1c thao t\u00e1c s\u1eed d\u1ee5ng \u0111\u01a1n gi\u1ea3n, kh\u00f4ng qu\u00e1 r\u01b0\u1eddm r\u00e0.<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Ti\u1ebft ki\u1ec7m \u0111\u01b0\u1ee3c nhi\u1ec1u chi ph\u00ed, nh\u00e2n l\u1ef1c v\u00e0 th\u1eddi gian cho c\u00f4ng ty.<\/span><\/li>\n<\/ul>\n<h3 style=\"text-align: justify;\"><b>2.2 Nh\u01b0\u1ee3c \u0111i\u1ec3m<\/b><\/h3>\n<ul style=\"text-align: justify;\">\n<li style=\"font-weight: 400;\" aria-level=\"1\"><b>Khi s\u1eed d\u1ee5ng d\u1eef li\u1ec7u r\u1ea5t kh\u00f3 ph\u00e2n t\u00e1n v\u00e0 kh\u00f3 r\u00e0 so\u00e1t t\u1ed5ng th\u1ec3 l\u1edbn<\/b><span style=\"font-weight: 400;\">: Khi s\u1eed d\u1ee5ng d\u1eef li\u1ec7u tr\u00ean Excel, h\u1ea7u h\u1ebft c\u00e1c d\u1eef li\u1ec7u s\u1ebd \u0111\u01b0\u1ee3c ph\u00e2n t\u00e1n th\u00e0nh r\u1ea5t nhi\u1ec1u file kh\u00e1c nhau ch\u1ee9 kh\u00f4ng t\u1eadp trung v\u00e0o m\u1ed9t file nh\u1ea5t \u0111\u1ecbnh. Vi\u1ec7c n\u00e0y s\u1ebd g\u00e2y ra b\u1ea5t ti\u1ec7n cho vi\u1ec7c t\u1ed5ng h\u1ee3p c\u0169ng nh\u01b0 l\u00e0m ra d\u1eef li\u1ec7u \u0111\u1ec3 b\u00e1o c\u00e1o to\u00e0n di\u1ec7n v\u00e0 \u1ea3nh h\u01b0\u1edfng r\u1ea5t l\u1edbn t\u1edbi c\u00f4ng vi\u1ec7c chung c\u1ee7a c\u1ea3 c\u00f4ng ty<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><b>D\u1eef li\u1ec7u kh\u00f4ng b\u1ea3o m\u1eadt<\/b><span style=\"font-weight: 400;\">: Excel l\u00e0 m\u1ed9t \u1ee9ng d\u1ee5ng m\u00e0 b\u1ea5t c\u1ee9 ng\u01b0\u1eddi d\u00f9ng n\u00e0o c\u0169ng c\u00f3 th\u1ec3 click v\u00e0o \u0111\u01b0\u1ee3c, v\u00ec th\u1ebf n\u00f3 ho\u00e0n to\u00e0n kh\u00f4ng b\u1ea3o m\u1eadt v\u00e0 ti\u1ec1m \u1ea9n r\u1ea5t nhi\u1ec1u m\u1ed1i nguy h\u1ea1i. \u0110i\u1ec3m h\u1ea1n ch\u1ebf \u1edf m\u1ee5c n\u00e0y l\u00e0 n\u00f3 kh\u00f4ng h\u1ec1 \u0111\u01b0\u1ee3c ph\u00e2n quy\u1ec1n ri\u00eang d\u00e0nh cho ng\u01b0\u1eddi qu\u1ea3n l\u00fd. M\u1eb7c d\u00f9 b\u1ea1n c\u00f3 th\u1ec3 \u0111\u1eb7t m\u1eadt kh\u1ea9u truy c\u1eadp nh\u01b0ng ch\u1eafc ch\u1eafn m\u1ed9t \u0111i\u1ec1u r\u1eb1ng l\u00e0 d\u1eef li\u1ec7u kh\u00f4ng th\u1ec3 \u0111\u01b0\u1ee3c b\u1ea3o m\u1eadt m\u1ed9t c\u00e1ch tuy\u1ec7t \u0111\u1ed1i, th\u1eadm ch\u00ed trong nhi\u1ec1u tr\u01b0\u1eddng h\u1ee3p khi b\u1ea1n \u0111\u00e3 \u0111\u1eb7t m\u1eadt kh\u1ea9u th\u00ec ch\u1eafc ch\u1eafn s\u1ebd kh\u00f3 l\u1ea5y l\u1ea1i.\u00a0<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><b>Kh\u1ea3 n\u0103ng t\u00edch h\u1ee3p h\u1ea1n ch\u1ebf<\/b><span style=\"font-weight: 400;\">: Excel c\u00f3 t\u00ean tu\u1ed5i v\u00e0 r\u1ea5t l\u00e2u \u0111\u1eddi, v\u00ec th\u1ebf n\u00ean c\u00e1c kh\u1ea3 n\u0103ng t\u00edch h\u1ee3p c\u00e1c c\u00f4ng c\u1ee5 kh\u00e1c nh\u01b0: Ch\u1ea5m c\u00f4ng, t\u00ednh l\u01b0\u01a1ng, qu\u1ea3n l\u00fd KPI hay qu\u1ea3n l\u00fd t\u00e0i s\u1ea3n,.. \u0111\u1ec1u kh\u00e1 kh\u00f3 kh\u0103n, trong khi c\u00e1c \u1ee9ng d\u1ee5ng qu\u1ea3n l\u00fd nh\u00e2n s\u1ef1 hi\u1ec7n nay \u0111\u1ec1u c\u00f3 th\u1ec3 l\u00e0m \u0111\u01b0\u1ee3c \u0111i\u1ec1u n\u00e0y m\u1ed9t c\u00e1ch r\u1ea5t d\u1ec5 d\u00e0ng.\u00a0<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><b>Kh\u00f3 m\u1edf r\u1ed9ng khi quy m\u00f4 t\u0103ng<\/b><span style=\"font-weight: 400;\">: Khi doanh nghi\u1ec7p c\u1ee7a b\u1ea1n ng\u00e0y c\u00e0ng l\u1edbn m\u1ea1nh, s\u1ed1 l\u01b0\u1ee3ng nh\u00e2n vi\u00ean ng\u00e0y c\u00e0ng l\u1edbn, ngu\u1ed3n d\u1eef li\u1ec7u c\u1ea7n l\u01b0u tr\u1eef l\u1ea1i c\u00e0ng l\u1edbn h\u01a1n th\u00ec excel r\u1ea5t kh\u00f3 \u0111\u1ec3 \u0111\u00e1p \u1ee9ng \u0111\u01b0\u1ee3c nhu c\u1ea7u n\u00e0y v\u00ec th\u1ebf n\u00ean qu\u1ea3n l\u00fd nh\u00e2n s\u1ef1 b\u1eb1ng bi\u1ec3u m\u1eabu Excel g\u1ea7n nh\u01b0 l\u00e0 r\u1ea5t kh\u00f3.\u00a0<\/span><\/li>\n<\/ul>\n<p>Doanh nghi\u1ec7p t\u0103ng quy m\u00f4 c\u00f9ng s\u1ed1 l\u01b0\u1ee3ng nh\u00e2n vi\u00ean l\u1edbn, do v\u1eady s\u1ebd c\u00f3 nhi\u1ec1u r\u1ee7i ro v\u00e0 nh\u01b0\u1ee3c \u0111i\u1ec3m khi qu\u1ea3n l\u00fd nh\u00e2n s\u1ef1 b\u1eb1ng excel. L\u00fac n\u00e0y, doanh nghi\u1ec7p n\u00ean c\u00e2n nh\u1eafc s\u1eed d\u1ee5ng <strong>c\u00e1c ph\u1ea7n m\u1ec1m qu\u1ea3n l\u00fd nh\u00e2n s\u1ef1<\/strong> tr\u1ea3 ph\u00ed \u0111\u1ec3 t\u1ed1i \u01b0u ho\u1ea1t \u0111\u1ed9ng v\u1eadn h\u00e0nh v\u00e0 qu\u1ea3n l\u00fd nh\u00e2n s\u1ef1 trong doanh nghi\u1ec7p.<\/p>\n<p style=\"text-align: justify;\"><a href=\"https:\/\/amis.misa.vn\/amis-nhan-su\/?source=80459\/quan-ly-nhan-su-mien-phi-bang-excel&amp;medium=banner&amp;campaign=SEO&amp;content=amis-nhan-su&amp;term=btnquynh\" target=\"_blank\" rel=\"nofollow noopener\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-69677 size-full\" src=\"\/wp-content\/uploads\/2020\/10\/cta-nhan-su.png\" alt=\"\" width=\"2220\" height=\"450\" srcset=\"\/wp-content\/uploads\/2020\/10\/cta-nhan-su.png 2220w, \/wp-content\/uploads\/2020\/10\/cta-nhan-su-500x101.png 500w, \/wp-content\/uploads\/2020\/10\/cta-nhan-su-1024x208.png 1024w, \/wp-content\/uploads\/2020\/10\/cta-nhan-su-768x156.png 768w, \/wp-content\/uploads\/2020\/10\/cta-nhan-su-1536x311.png 1536w, \/wp-content\/uploads\/2020\/10\/cta-nhan-su-2048x415.png 2048w\" sizes=\"(max-width: 2220px) 100vw, 2220px\" \/><\/a><\/p>\n<h2 style=\"text-align: justify;\"><b>3. H\u01b0\u1edbng d\u1eabn s\u1eed d\u1ee5ng ph\u1ea7n m\u1ec1m qu\u1ea3n l\u00fd nh\u00e2n s\u1ef1 excel<\/b><\/h2>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">C\u00e1c d\u1eef li\u1ec7u v\u1ec1 nh\u00e2n s\u1ef1 c\u00f3 r\u1ea5t nhi\u1ec1u, do \u0111\u00f3 vi\u1ec7c l\u1eadp b\u00e1o c\u00e1o sao cho \u0111\u1ee7 h\u1ebft c\u00e1c n\u1ed9i dung m\u00e0 v\u1eabn mang t\u00ednh th\u1ea9m m\u1ef9 l\u00e0 \u0111i\u1ec1u r\u1ea5t c\u1ea7n thi\u1ebft. M\u1ed9t b\u00e1o c\u00e1o t\u1ed1t s\u1ebd \u0111\u00e1p \u1ee9ng c\u1ea3 2 y\u00eau c\u1ea7u tr\u00ean. <strong>MISA AMIS<\/strong> s\u1ebd h\u01b0\u1edbng d\u1eabn cho b\u1ea1n c\u00e1ch s\u1eed d\u1ee5ng t\u00ednh n\u0103ng c\u1ee7a excel \u1edf d\u01b0\u1edbi \u0111\u00e2y.<\/span><\/p>\n<p style=\"text-align: justify;\"><b>Ph\u1ea7n 1: T\u1ea1o danh s\u00e1ch ch\u1ecdn \u201cH\u1ecd v\u00e0 t\u00ean\u201d c\u1ee7a nh\u00e2n s\u1ef1 trong b\u1ea3ng b\u00e1o c\u00e1o chi ti\u1ebft<\/b><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">Sau khi \u0111\u00e3 x\u00e1c \u0111\u1ecbnh \u0111\u01b0\u1ee3c c\u00e1c m\u1ee5c c\u1ea7n c\u00f3 trong b\u1ea3ng b\u00e1o c\u00e1o th\u00ec c\u1ea7n ph\u1ea3i nh\u1eadp \u0111\u1ea7y \u0111\u1ee7 d\u1eef li\u1ec7u v\u00e0o trong b\u1ea3ng. Sau \u0111\u00f3,\u0111\u1ec3 t\u1ea1o danh s\u00e1ch ch\u1ecdn th\u00ec ta l\u00e0m nh\u01b0 sau:<\/span><\/p>\n<ul style=\"text-align: justify;\">\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Gi\u1ea3 s\u1eed \u00f4 c\u1ea7n t\u1ea1o l\u00e0 B3, ch\u1ecdn Data Validation trong th\u1ebb Data<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Ti\u1ebfp theo, trong Data Validation ch\u1ecdn nh\u01b0 sau: Allow (ch\u1ecdn List), Source (ch\u1ecdn t\u1edbi danh s\u00e1ch t\u00ean nh\u00e2n s\u1ef1 trong b\u1ea3ng Danh s\u00e1ch nh\u00e2n vi\u00ean).<\/span><\/li>\n<\/ul>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">T\u1ea1i \u0111\u00e2y, ta ch\u1ecdn n\u00fat Dropdown \u0111\u1ec3 ch\u1ecdn 1 nh\u00e2n s\u1ef1 b\u1ea5t k\u1ef3 trong danh s\u00e1ch nh\u00e2n s\u1ef1.<\/span><\/p>\n<p style=\"text-align: justify;\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-81066 size-full\" src=\"\/wp-content\/uploads\/2023\/01\/phan-mem-quan-ly-nhan-su-bang-excel-11.png\" alt=\"ph\u1ea7n m\u1ec1m qu\u1ea3n l\u00fd nh\u00e2n s\u1ef1 b\u1eb1ng excel\" width=\"600\" height=\"248\" srcset=\"\/wp-content\/uploads\/2023\/01\/phan-mem-quan-ly-nhan-su-bang-excel-11.png 600w, \/wp-content\/uploads\/2023\/01\/phan-mem-quan-ly-nhan-su-bang-excel-11-500x207.png 500w\" sizes=\"(max-width: 600px) 100vw, 600px\" \/><\/p>\n<p style=\"text-align: justify;\"><b>Ph\u1ea7n 2: L\u1ea5y th\u00f4ng tin v\u1ec1 nh\u00e2n s\u1ef1 th\u00f4ng qua t\u00ean nh\u00e2n s\u1ef1 \u0111\u01b0\u1ee3c ch\u1ecdn b\u1eb1ng h\u00e0m VLOOKUP<\/b><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">\u0110\u1ec3 tra c\u1ee9u th\u00f4ng tin c\u1ee7a nh\u00e2n s\u1ef1 \u0111\u01b0\u1ee3c ch\u1ecdn, ta l\u00e0m nh\u01b0 sau: Gi\u1ea3 s\u1eed \u00f4 tra c\u1ee9u H\u0110L\u0110 c\u1ee7a nh\u00e2n vi\u00ean \u0111\u01b0\u1ee3c ch\u1ecdn l\u00e0 D5, ta vi\u1ebft h\u00e0m: =VLOOKUP($B$3,Bang_DSNV,DSNV!$H$5,0)<\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">Trong \u0111\u00f3:<\/span><\/p>\n<ul style=\"text-align: justify;\">\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\"><strong>lookup_value:<\/strong> \u0111\u00e2y l\u00e0 \u0111\u1ed1i t\u01b0\u1ee3ng tham chi\u1ebfu, ch\u00ednh l\u00e0 t\u00ean nh\u00e2n s\u1ef1 \u0111\u00e3 \u0111\u01b0\u1ee3c ch\u1ecdn tr\u01b0\u1edbc \u0111\u00f3 t\u1ea1i \u00f4 B3.<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\"><strong>table_array:<\/strong> \u0111\u00e2y l\u00e0 b\u1ea3ng d\u1eef li\u1ec7u c\u1ea7n tra c\u1ee9u, hay c\u00f2n l\u00e0 b\u1ea3ng danh s\u00e1ch nh\u00e2n vi\u00ean. Trong \u0111\u00f3, c\u1ed9t \u0111\u1ea7u ti\u00ean l\u00e0 c\u1ed9t H\u1ecd v\u00e0 T\u00ean.<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\"><strong>col_index_num:<\/strong> k\u1ebft qu\u1ea3 s\u1ebd cho ra \u1edf m\u1ed9t trong s\u1ed1 c\u00e1c c\u1ed9t \u1edf b\u1ea3ng table_array. D\u1ef1a theo s\u1ed1 c\u1ed9t \u0111\u01b0\u1ee3c ghi trong ti\u00eau \u0111\u1ec1 c\u1ee7a b\u1ea3ng danh s\u00e1ch nh\u00e2n vi\u00ean, ta c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng k\u1ebft qu\u1ea3 \u1edf \u00f4 H5 &#8211; ch\u00ednh l\u00e0 s\u1ed1 c\u1ed9t c\u1ea7n t\u00ecm (c\u1ed9t s\u1ed1 H\u0110L\u0110).<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\"><strong>range_lookup:<\/strong> \u0111\u00e2y l\u00e0 ph\u01b0\u01a1ng th\u1ee9c t\u00ecm ki\u1ebfm nh\u00e2n s\u1ef1, do l\u00e0 ch\u00fang ta t\u00ecm ch\u00ednh x\u00e1c t\u00ean nh\u00e2n vi\u00ean n\u00ean s\u1ebd s\u1eed d\u1ee5ng s\u1ed1 0.<\/span><\/li>\n<\/ul>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">Ngo\u00e0i ra, \u0111\u1ec3 tr\u00e1nh l\u1ed7i \u00f4 B3 l\u00e0 \u00f4 tr\u1ed1ng (t\u1ee9c l\u00e0 kh\u00f4ng c\u00f3 nh\u00e2n vi\u00ean \u0111\u01b0\u1ee3c ch\u1ecdn), ta s\u1eed d\u1ee5ng h\u00e0m IF \u0111\u1ec3 bi\u1ec7n lu\u1eadn cho tr\u01b0\u1eddng h\u1ee3p n\u00e0y tr\u01b0\u1edbc khi s\u1eed d\u1ee5ng h\u00e0m VLOOKUP. K\u1ebft qu\u1ea3 h\u00e0m cu\u1ed1i s\u1ebd l\u00e0: =IF($B$3=\u201d\u201d,\u201d\u201d,VLOOKUP($B$3,Bang_DSNV,DSNV!$H$5,0))<\/span><\/p>\n<p style=\"text-align: justify;\"><b>Ph\u1ea7n 3: L\u1ea5y th\u00f4ng tin v\u1ec1 l\u1ecbch s\u1eed l\u00e0m vi\u1ec7c c\u1ee7a nh\u00e2n vi\u00ean theo th\u1eddi gian b\u00e1o c\u00e1o<\/b><\/p>\n<p>Ta k\u1ebft h\u1ee3p \u0111i\u1ec1u ki\u1ec7n th\u1eddi gian l\u1ecdc d\u1eef li\u1ec7u \u1edf trong b\u1ea3ng theo d\u00f5i l\u00e0m vi\u1ec7c c\u1ee7a nh\u00e2n s\u1ef1 \u0111\u1ebf l\u1ea5y th\u00f4ng tin v\u1ec1 l\u1ecbch s\u1eed c\u1ee7a nh\u00e2n vi\u00ean. K\u1ef9 thu\u1eadt l\u1ecdc trong Excel th\u01b0\u1eddng \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng \u0111\u00f3 l\u00e0 Advanced Filter. Ta c\u00f3 th\u1ec3 th\u1ef1c hi\u1ec7n nh\u01b0 sau:<\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">\u0110\u1ea7u ti\u00ean ti\u1ebfn h\u00e0nh x\u00e2y d\u1ef1ng v\u00f9ng \u0111i\u1ec1u ki\u1ec7n, bao g\u1ed3m t\u00ean nh\u00e2n vi\u00ean v\u00e0 th\u1eddi gian b\u00e1o c\u00e1o. M\u1ed7i m\u1ed9t \u0111i\u1ec1u ki\u1ec7n s\u1ebd g\u1eafn li\u1ec1n v\u1edbi m\u1ed9t ti\u00eau \u0111\u1ec1 c\u1ed9t c\u00f3 li\u00ean quan trong b\u1ea3ng d\u1eef li\u1ec7u.<\/span><\/p>\n<p style=\"text-align: justify;\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-81068\" src=\"\/wp-content\/uploads\/2023\/01\/phan-mem-quan-ly-nhan-su-bang-excel-12.png\" alt=\"\" width=\"1024\" height=\"213\" srcset=\"\/wp-content\/uploads\/2023\/01\/phan-mem-quan-ly-nhan-su-bang-excel-12.png 1024w, \/wp-content\/uploads\/2023\/01\/phan-mem-quan-ly-nhan-su-bang-excel-12-500x104.png 500w, \/wp-content\/uploads\/2023\/01\/phan-mem-quan-ly-nhan-su-bang-excel-12-768x160.png 768w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">Ti\u1ebfp theo, x\u00e1c \u0111\u1ecbnh s\u1eb5n nh\u1eefng k\u1ebft qu\u1ea3 c\u1ea7n l\u1ecdc. Nh\u01b0 \u1edf trong v\u00ed d\u1ee5 n\u00e0y l\u00e0 to\u00e0n b\u1ed9 c\u00e1c c\u1ed9t \u1edf b\u1ea3ng theo d\u00f5i qu\u00e1 tr\u00ecnh l\u00e0m vi\u1ec7c.<\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">Cu\u1ed1i c\u00f9ng ta \u00e1p d\u1ee5ng Advanced Filter l\u1ecdc c\u00e1c k\u1ebft qu\u1ea3 \u0111\u1ec3 ra b\u00e1o c\u00e1o. K\u1ebft h\u1ee3p v\u1edbi VBA, ta ho\u00e0n to\u00e0n c\u00f3 th\u1ec3 khi\u1ebfn b\u00e1o c\u00e1o t\u1ef1 \u0111\u1ed9ng \u00e1p d\u1ee5ng Advanced Filter \u0111\u1ec3 cho ra k\u1ebft qu\u1ea3 t\u01b0\u01a1ng \u1ee9ng m\u1ed7i khi thay \u0111\u1ed5i m\u1ed9t t\u00ean nh\u00e2n vi\u00ean kh\u00e1c.<\/span><\/p>\n<p style=\"text-align: justify;\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-81069 size-full\" src=\"\/wp-content\/uploads\/2023\/01\/phan-mem-quan-ly-nhan-su-bang-excel-13.png\" alt=\"ph\u1ea7n m\u1ec1m qu\u1ea3n l\u00fd nh\u00e2n s\u1ef1 b\u1eb1ng excel\" width=\"1024\" height=\"302\" srcset=\"\/wp-content\/uploads\/2023\/01\/phan-mem-quan-ly-nhan-su-bang-excel-13.png 1024w, \/wp-content\/uploads\/2023\/01\/phan-mem-quan-ly-nhan-su-bang-excel-13-500x147.png 500w, \/wp-content\/uploads\/2023\/01\/phan-mem-quan-ly-nhan-su-bang-excel-13-768x227.png 768w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/p>\n<h2 style=\"text-align: justify;\"><b>4. So s\u00e1nh qu\u1ea3n l\u00fd nh\u00e2n s\u1ef1 b\u1eb1ng Excel v\u00e0 qu\u1ea3n l\u00fd th\u00f4ng minh<\/b><\/h2>\n<ul style=\"text-align: justify;\">\n<li aria-level=\"1\"><b>\u0110i\u1ec3m gi\u1ed1ng:\u00a0<\/b><\/li>\n<\/ul>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">Th\u1ee9 nh\u1ea5t, c\u1ea3 hai lo\u1ea1i \u0111\u1ec1u \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng kh\u00e1 \u0111\u01a1n gi\u1ea3n v\u1edbi ng\u01b0\u1eddi d\u00f9ng, b\u1ea5t c\u1ee9 ai ch\u1ec9 c\u1ea7n bi\u1ebft thao t\u00e1c tr\u00ean m\u00e1y t\u00ednh th\u00ec \u0111\u1ec1u c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng \u0111\u01b0\u1ee3c.\u00a0<\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">Th\u1ee9 hai l\u00e0 c\u1ea3 hai lo\u1ea1i \u0111\u1ec1u c\u00f3 th\u1ec3 t\u00f9y ch\u1ec9nh v\u00e0 d\u1ec5 d\u00e0ng s\u1eed d\u1ee5ng.\u00a0<\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">Th\u1ee9 ba, m\u1eb7c d\u00f9 hi\u1ec7u qu\u1ea3 \u0111em l\u1ea1i cao nh\u01b0ng chi ph\u00ed \u0111\u1ec3 s\u1eed d\u1ee5ng l\u1ea1i h\u1ee3p l\u00fd, h\u01a1n th\u1ebf n\u1eefa khi s\u1eed d\u1ee5ng b\u1eb1ng Excel b\u1ea1n c\u00f2n c\u00f3 th\u1ec3 \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng m\u1ed9t c\u00e1ch ho\u00e0n to\u00e0n mi\u1ec5n ph\u00ed.\u00a0<\/span><\/p>\n<ul style=\"text-align: justify;\">\n<li aria-level=\"1\"><b>\u0110i\u1ec3m kh\u00e1c:\u00a0<\/b><\/li>\n<\/ul>\n<table>\n<tbody>\n<tr>\n<td><\/td>\n<td style=\"text-align: center;\"><b>\u01afu \u0111i\u1ec3m<\/b><\/td>\n<td style=\"text-align: center;\"><b>H\u1ea1n ch\u1ebf<\/b><\/td>\n<\/tr>\n<tr>\n<td><b>Qu\u1ea3n l\u00fd nh\u00e2n s\u1ef1 b\u1eb1ng Excel<\/b><\/td>\n<td><span style=\"font-weight: 400;\">Mi\u1ec5n ph\u00ed v\u00e0 c\u00f3 th\u1ec3 c\u00e0i \u0111\u1eb7t \u0111\u01b0\u1ee3c<\/span><\/td>\n<td><span style=\"font-weight: 400;\">R\u1ee7i ro b\u1ea3o m\u1eadt cao<\/span><\/p>\n<p><span style=\"font-weight: 400;\">Thi\u1ebfu \u0111i t\u00ednh t\u1ef1 \u0111\u1ed9ng h\u00f3a: Khi b\u1ea1n s\u1eed d\u1ee5ng Excel, b\u1ea1n kh\u00f4ng th\u1ec3 t\u1ef1 \u0111\u1ed9ng nh\u1eafc vi\u1ec7c \u0111\u01b0\u1ee3c m\u00e0 ph\u1ea3i ch\u1ee7 \u0111\u1ed9ng truy c\u1eadp v\u00e0o Excel th\u00ec m\u1edbi c\u00f3 th\u1ec3 quan s\u00e1t \u0111\u01b0\u1ee3c t\u00ecnh h\u00ecnh c\u00f4ng vi\u1ec7c<\/span><\/p>\n<p><span style=\"font-weight: 400;\">H\u1ea1n ch\u1ebf qu\u1ea3n tr\u1ecb c\u00f4ng vi\u1ec7c cao v\u1edbi kh\u1ed1i l\u01b0\u1ee3ng l\u1edbn.\u00a0<\/span><\/td>\n<\/tr>\n<tr>\n<td><b>Qu\u1ea3n l\u00fd nh\u00e2n s\u1ef1 b\u1eb1ng ph\u1ea7n m\u1ec1m<\/b><\/td>\n<td><span style=\"font-weight: 400;\">C\u00f3 th\u1ec3 qu\u1ea3n l\u00fd th\u00f4ng tin m\u1ed9t c\u00e1ch c\u00e1ch t\u1eadp trung<\/span><\/p>\n<p><span style=\"font-weight: 400;\">\u01afu \u0111i\u1ec3m tuy\u1ec7t v\u1eddi c\u1ee7a vi\u1ec7c ki\u1ec3m so\u00e1t qua ph\u1ea7n m\u1ec1m \u0111\u00f3 l\u00e0 b\u1ea1n c\u00f3 th\u1ec3 d\u1ec5 d\u00e0ng qu\u1ea3n l\u00fd r\u1ea5t nhi\u1ec1u c\u00f4ng vi\u1ec7c l\u1edbn nh\u1ecf chi tr\u00ean m\u1ed9t h\u1ec7 th\u1ed1ng duy nh\u1ea5t.\u00a0<\/span><\/p>\n<p><span style=\"font-weight: 400;\">C\u00f3 t\u00ednh n\u0103ng t\u1ef1 \u0111\u1ed9ng h\u00f3a: \u0110\u00e2y l\u00e0 m\u1ed9t t\u00ednh n\u0103ng v\u01b0\u1ee3t tr\u1ed9i m\u00e0 b\u1ea1n kh\u00f4ng th\u1ec3 b\u1ecf qua, v\u00ec khi s\u1eed d\u1ee5ng c\u00e1c ph\u1ea7n m\u1ec1m \u0111\u1ec3 qu\u1ea3n l\u00fd c\u00f4ng vi\u1ec7c, nh\u1eefng thay \u0111\u1ed5i trong qu\u00e1 tr\u00ecnh l\u00e0m vi\u1ec7c s\u1ebd \u0111\u01b0\u1ee3c th\u00f4ng b\u00e1o v\u00e0 nh\u1eafc nh\u1edf t\u1edbi ng\u01b0\u1eddi d\u00f9ng. V\u00ec th\u1ebf s\u1ebd h\u1ea1n ch\u1ebf \u0111\u01b0\u1ee3c vi\u1ec7c b\u1ea1n qu\u00ean \u0111i c\u00f4ng vi\u1ec7c ho\u1eb7c s\u00f3t c\u00f4ng vi\u1ec7c\u00a0<\/span><\/p>\n<p><span style=\"font-weight: 400;\">C\u00f3 th\u1ec3 t\u1ea1o \u0111\u01b0\u1ee3c quy tr\u00ecnh c\u00f4ng vi\u1ec7c tr\u1ef1c tuy\u1ebfn th\u00f4ng minh v\u00e0 nhanh ch\u00f3ng.<\/span><\/td>\n<td><span style=\"font-weight: 400;\">Nhi\u1ec1u ph\u1ea7n m\u1ec1m bu\u1ed9c b\u1ea1n ph\u1ea3i tr\u1ea3 ph\u00ed cao v\u00e0 duy tr\u00ec theo t\u1eebng n\u0103m<\/span><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p><a href=\"https:\/\/ld.amis.vn\/tron-bo-17-mau-quy-trinh-cho-ceo-hrm?source=quan-ly-nhan-su-mien-phi-bang-excel&amp;medium=CTA-Sapo\" target=\"_blank\" rel=\"noopener nooper\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone\" src=\"https:\/\/amis.misa.vn\/wp-content\/uploads\/2023\/10\/HRM-banner-blog-20230925-02.jpg\" alt=\"\" width=\"1667\" height=\"508\" \/><\/a><\/p>\n<h2 style=\"text-align: justify;\"><strong>5. Qu\u1ea3n l\u00fd nh\u00e2n s\u1ef1 b\u1eb1ng MISA AMIS HRM<\/strong><\/h2>\n<p style=\"text-align: justify;\">Qu\u1ea3n l\u00fd nh\u00e2n s\u1ef1 th\u1ee7 c\u00f4ng b\u1eb1ng excel c\u00f3 th\u1ec3 g\u00e2y ra nhi\u1ec1u sai s\u00f3t, t\u1ed1n k\u00e9m. L\u00fac n\u00e0y doanh nghi\u1ec7p c\u00f3 th\u1ec3 tham kh\u1ea3o <strong>AMIS nh\u00e2n s\u1ef1<\/strong> v\u1edbi h\u00e0ng lo\u1ea1t t\u00ednh n\u0103ng h\u1eefu \u00edch nh\u01b0:<\/p>\n<ul style=\"text-align: justify;\">\n<li><strong>AMIS Tuy\u1ec3n d\u1ee5ng:<\/strong> H\u1ed7 tr\u1ee3 n\u00e2ng cao tuy\u1ec3n d\u1ee5ng, thu h\u00fat \u1ee9ng vi\u00ean, l\u00e0m b\u00e0i test online, t\u1ef1 \u0111\u1ed9ng g\u1eedi email k\u1ebft qu\u1ea3 ph\u1ecfng v\u1ea5n, t\u1ea1o th\u01b0\u01a1ng hi\u1ec7u tuy\u1ec3n d\u1ee5ng v\u1edbi website mi\u1ec5n ph\u00ed.<\/li>\n<\/ul>\n<ul style=\"text-align: justify;\">\n<li><strong>AMIS Th\u00f4ng tin nh\u00e2n s\u1ef1:<\/strong> L\u01b0u tr\u1eef s\u1ed1 l\u01b0\u1ee3ng l\u1edbn h\u1ed3 s\u01a1 nh\u00e2n vi\u00ean, theo d\u00f5i k\u1ebft qu\u1ea3 khen th\u01b0\u1edfng, k\u1ef7 lu\u1eadt&#8230; b\u00e1o c\u00e1o chi ti\u1ebft v\u1ec1 t\u00ecnh h\u00ecnh h\u1ee3p \u0111\u1ed3ng nh\u00e2n vi\u00ean, lu\u00e2n chuy\u1ec3n lao \u0111\u1ed9ng,&#8230;.<\/li>\n<\/ul>\n<ul style=\"text-align: justify;\">\n<li><strong>AMIS Ch\u1ea5m c\u00f4ng:<\/strong> Ch\u1ea5m c\u00f4ng \u0111a h\u00ecnh th\u1ee9c, d\u1eef li\u1ec7u \u0111\u1ed3ng b\u1ed9, nh\u00e2n vi\u00ean t\u1ef1 theo d\u00f5i c\u00f4ng, t\u1ef1 \u0111\u1ed9ng y\u00eau c\u1ea7u c\u1eadp nh\u1eadt c\u00f4ng n\u1ebfu c\u00f3.<\/li>\n<\/ul>\n<p><a href=\"https:\/\/amis.misa.vn\/register\/?appcode=EmployeesProfile;Payroll;Timesheet;EmployeeSelfService;MISAIVAN;MinTax&amp;source=80459\/quan-ly-nhan-su-mien-phi-bang-excel&amp;medium=banner&amp;campaign=SEO&amp;content=Dungthumienphi&amp;term=btnquynh\" target=\"_blank\" rel=\"nofollow noopener\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-69874\" src=\"\/wp-content\/uploads\/2022\/10\/banner-HRm-2-01.png\" alt=\"\" width=\"1542\" height=\"834\" srcset=\"\/wp-content\/uploads\/2022\/10\/banner-HRm-2-01.png 1542w, \/wp-content\/uploads\/2022\/10\/banner-HRm-2-01-500x270.png 500w, \/wp-content\/uploads\/2022\/10\/banner-HRm-2-01-1024x554.png 1024w, \/wp-content\/uploads\/2022\/10\/banner-HRm-2-01-768x415.png 768w, \/wp-content\/uploads\/2022\/10\/banner-HRm-2-01-1536x831.png 1536w\" sizes=\"(max-width: 1542px) 100vw, 1542px\" \/><\/a><\/p>\n<p><a href=\"http:\/\/x&amp;source=80459\/quan-ly-nhan-su-mien-phi-bang-excel&amp;medium=banner&amp;campaign=SEO&amp;content=Dungthumienphi&amp;term=btnquynh\"><img decoding=\"async\" class=\"aligncenter\" src=\"https:\/\/amis.misa.vn\/wp-content\/uploads\/2023\/08\/Screenshot_5-2.png\" alt=\"D\u00f9ng th\u1eed ph\u1ea7n m\u1ec1m nh\u00e2n s\u1ef1\" \/><\/a><\/p>\n<ul style=\"text-align: justify;\">\n<li><strong>AMIS Ti\u1ec1n l\u01b0\u01a1ng:<\/strong>\u00a0 ph\u1ea7n m\u1ec1m c\u0169ng t\u1ef1 \u0111\u1ed9ng tr\u00edch c\u00e1c kho\u1ea3n ph\u1ea3i kh\u1ea5u tr\u1eeb theo quy \u0111\u1ecbnh c\u1ee7a ph\u00e1p lu\u1eadt.<\/li>\n<\/ul>\n<p style=\"text-align: justify;\">AMIS HRM ph\u00f9 h\u1ee3 v\u1edbi m\u1ecdi quy m\u00f4 doanh nghi\u1ec7p v\u00e0 \u0111\u01b0\u1ee3c nhi\u1ec1u c\u00f4ng ty t\u1ea1i Vi\u1ec7t Nam tin d\u00f9ng nh\u01b0: IVY moda, Xu\u00e2n C\u01b0\u01a1ng, Tr\u1ed1ng \u0110\u1ed3ng Palace&#8230;..<\/p>\n<style>\r\n\t\t.custom-slider .owl-nav button[type=\"button\"] {\r\n\t\t\toutline: none !important;\r\n\t\t\tbackground: none !important;\r\n\t\t\tposition: absolute;\r\n\t\t\ttop: calc(50% - 95px);\r\n\t\t}\r\n\t\t.custom-slider .owl-prev {\r\n\t\t\tposition: absolute;\r\n\t\t\ttop: calc(50% - 90px);\r\n\t\t\tleft: calc(0% - 40px);\r\n\t\t}\r\n\t\t.custom-slider .ic-back {\r\n\t\t\ttransform: scale(-1);\r\n\t\t}\r\n\t\t.custom-slider .owl-nav button.owl-next {\r\n\t\t\tright: calc(0% - 40px);\r\n\t\t}\r\n\r\n\t\t.custom-slider .owl-dots .owl-dot.active span {\r\n\t\t\theight: 10px;\r\n\t\t\twidth: 10px;\r\n\t\t\tborder: 0;\r\n\t\t\tbackground: #0060f9;\r\n\t\t}\r\n\t\t.custom-slider .owl-nav button[type=\"button\"].owl-prev {\r\n\t\t\tleft: 24px;\r\n\t\t}\r\n\r\n\t\t.custom-slider .owl-nav button[type=\"button\"].owl-next {\r\n\t\t\tright: 24px;\r\n\t\t}\r\n   <\/style><div class=\"custom-slider owl-carousel owl-theme\">\r\n\t        <div class=\"carousel-inner\">\r\n\t        \t<img decoding=\"async\" src=\"\/wp-content\/uploads\/2023\/06\/template-CCTC-02.png\" alt=\"AMIS\">\r\n\t\t\t<\/div>\r\n\t    \r\n\t        <div class=\"carousel-inner\">\r\n\t        \t<img decoding=\"async\" src=\" \/wp-content\/uploads\/2023\/06\/CCTC-Tranthithu-Trongdongpalace.png\" alt=\"AMIS\">\r\n\t\t\t<\/div>\r\n\t    \r\n\t        <div class=\"carousel-inner\">\r\n\t        \t<img decoding=\"async\" src=\" \/wp-content\/uploads\/2023\/06\/CCTC-Caothanhphuc-Ctycophandautuchuoidautusangtao.png\" alt=\"AMIS\">\r\n\t\t\t<\/div>\r\n\t    \r\n\t        <div class=\"carousel-inner\">\r\n\t        \t<img decoding=\"async\" src=\" \/wp-content\/uploads\/2023\/06\/template-CCTC-04.png\" alt=\"AMIS\">\r\n\t\t\t<\/div>\r\n\t    \r\n\t        <div class=\"carousel-inner\">\r\n\t        \t<img decoding=\"async\" src=\" \/wp-content\/uploads\/2023\/06\/Asset-10-1.png\" alt=\"AMIS\">\r\n\t\t\t<\/div>\r\n\t    \r\n\t        <div class=\"carousel-inner\">\r\n\t        \t<img decoding=\"async\" src=\" \/wp-content\/uploads\/2023\/06\/template-CCTC-06.png\" alt=\"AMIS\">\r\n\t\t\t<\/div>\r\n\t    \r\n\t        <div class=\"carousel-inner\">\r\n\t        \t<img decoding=\"async\" src=\" \/wp-content\/uploads\/2023\/06\/template-CCTC-07.png\" alt=\"AMIS\">\r\n\t\t\t<\/div>\r\n\t    <\/div><script>\r\n    jQuery(document).ready(function ($) {\r\n            jQuery(\".custom-slider.owl-carousel\").owlCarousel({\r\n                loop: true,\r\n                margin: 10,\r\n                nav: true,\r\n                items: 1,\r\n                \r\n                smartSpeed: 250,autoplay: false,navText: [\"<img class='ic-back' alt='' src='\/wp-content\/plugins\/embed-popup-aimarketing\/icon-right.svg'\/>\", \"<img alt='' src='\/wp-content\/plugins\/embed-popup-aimarketing\/icon-right.svg'\/>\"],\r\n            \r\n            })\r\n        })\r\n\t<\/script> \n<h2 style=\"text-align: justify;\"><b>6. K\u1ebft lu\u1eadn<\/b><\/h2>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">Tr\u00ean \u0111\u00e2y, l\u00e0 to\u00e0n b\u1ed9 th\u00f4ng tin v\u1ec1 qu\u1ea3n l\u00fd nh\u00e2n s\u1ef1 b\u1eb1ng Excel trong ho\u1ea1t \u0111\u1ed9ng c\u1ee7a Doanh nghi\u1ec7p. Hi v\u1ecdng nh\u1eefng th\u00f4ng tin h\u1eefu \u00edch cho Doanh nghi\u1ec7p c\u1ee7a b\u1ea1n.<\/span><\/p>\n<div class=\"pvc_clear\"><\/div>\n<p id=\"pvc_stats_80459\" class=\"pvc_stats total_only  \" data-element-id=\"80459\" style=\"\"><i class=\"pvc-stats-icon medium\" aria-hidden=\"true\"><svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" version=\"1.0\" viewBox=\"0 0 502 315\" preserveAspectRatio=\"xMidYMid meet\"><g transform=\"translate(0,332) scale(0.1,-0.1)\" fill=\"\" stroke=\"none\"><path d=\"M2394 3279 l-29 -30 -3 -207 c-2 -182 0 -211 15 -242 39 -76 157 -76 196 0 15 31 17 60 15 243 l-3 209 -33 29 c-26 23 -41 29 -80 29 -41 0 -53 -5 -78 -31z\"\/><path d=\"M3085 3251 c-45 -19 -58 -50 -96 -229 -47 -217 -49 -260 -13 -295 52 -53 146 -42 177 20 16 31 87 366 87 410 0 70 -86 122 -155 94z\"\/><path d=\"M1751 3234 c-13 -9 -29 -31 -37 -50 -12 -29 -10 -49 21 -204 19 -94 39 -189 45 -210 14 -50 54 -80 110 -80 34 0 48 6 76 34 21 21 34 44 34 59 0 14 -18 113 -40 219 -37 178 -43 195 -70 221 -36 32 -101 37 -139 11z\"\/><path d=\"M1163 3073 c-36 -7 -73 -59 -73 -102 0 -56 133 -378 171 -413 34 -32 83 -37 129 -13 70 36 67 87 -16 290 -86 209 -89 214 -129 231 -35 14 -42 15 -82 7z\"\/><path d=\"M3689 3066 c-15 -9 -33 -30 -42 -48 -48 -103 -147 -355 -147 -375 0 -98 131 -148 192 -74 13 15 57 108 97 206 80 196 84 226 37 273 -30 30 -99 39 -137 18z\"\/><path d=\"M583 2784 c-38 -19 -67 -74 -58 -113 9 -42 211 -354 242 -373 16 -10 45 -18 66 -18 51 0 107 52 107 100 0 39 -1 41 -124 234 -80 126 -108 162 -133 173 -41 17 -61 16 -100 -3z\"\/><path d=\"M4250 2784 c-14 -9 -74 -91 -133 -183 -95 -150 -107 -173 -107 -213 0 -55 33 -94 87 -104 67 -13 90 8 211 198 130 202 137 225 78 284 -27 27 -42 34 -72 34 -22 0 -50 -8 -64 -16z\"\/><path d=\"M2275 2693 c-553 -48 -1095 -270 -1585 -649 -135 -104 -459 -423 -483 -476 -23 -49 -22 -139 2 -186 73 -142 361 -457 571 -626 285 -228 642 -407 990 -497 242 -63 336 -73 660 -74 310 0 370 5 595 52 535 111 1045 392 1455 803 122 121 250 273 275 326 19 41 19 137 0 174 -41 79 -309 363 -465 492 -447 370 -946 591 -1479 653 -113 14 -422 18 -536 8z m395 -428 c171 -34 330 -124 456 -258 112 -119 167 -219 211 -378 27 -96 24 -300 -5 -401 -72 -255 -236 -447 -474 -557 -132 -62 -201 -76 -368 -76 -167 0 -236 14 -368 76 -213 98 -373 271 -451 485 -162 444 86 934 547 1084 153 49 292 57 452 25z m909 -232 c222 -123 408 -262 593 -441 76 -74 138 -139 138 -144 0 -16 -233 -242 -330 -319 -155 -123 -309 -223 -461 -299 l-81 -41 32 46 c18 26 49 83 70 128 143 306 141 649 -6 957 -25 52 -61 116 -79 142 l-34 47 45 -20 c26 -10 76 -36 113 -56z m-2057 25 c-40 -58 -105 -190 -130 -263 -110 -324 -59 -707 132 -981 25 -35 42 -64 37 -64 -19 0 -241 119 -326 174 -188 122 -406 314 -532 468 l-58 71 108 103 c185 178 428 349 672 473 66 33 121 60 123 61 2 0 -10 -19 -26 -42z\"\/><path d=\"M2375 1950 c-198 -44 -350 -190 -395 -379 -18 -76 -8 -221 19 -290 114 -284 457 -406 731 -260 98 52 188 154 231 260 27 69 37 214 19 290 -38 163 -166 304 -326 360 -67 23 -215 33 -279 19z\"\/><\/g><\/svg><\/i> <img loading=\"lazy\" decoding=\"async\" width=\"16\" height=\"16\" alt=\"Loading\" src=\"\/wp-content\/plugins\/page-views-count\/ajax-loader-2x.gif\" border=0 \/><\/p>\n<div class=\"pvc_clear\"><\/div>\n<div style='text-align:center' class='yasr-auto-insert-visitor'><\/div>","protected":false},"excerpt":{"rendered":"<p>Qu\u1ea3n l\u00fd nh\u00e2n s\u1ef1 b\u1eb1ng Excel l\u00e0 m\u1ed9t h\u00ecnh th\u1ee9c qu\u1ea3n l\u00fd \u0111\u01b0\u1ee3c r\u1ea5t nhi\u1ec1u doanh nghi\u1ec7p \u00e1p d\u1ee5ng. H\u00ecnh th\u1ee9c n\u00e0y \u0111\u00e3 tr\u1edf n\u00ean qu\u00e1 th\u00e2n thu\u1ed9c v\u00e0 ph\u1ed5 bi\u1ebfn t\u1ea1i nhi\u1ec1u c\u00f4ng ty, doanh nghi\u1ec7p t\u1eeb l\u1edbn t\u1edbi nh\u1ecf. V\u1eady \u0111\u1ec3 t\u1ea1o l\u1eadp v\u00e0 s\u1eed d\u1ee5ng \u0111\u01b0\u1ee3c file\/ ph\u1ea7n m\u1ec1m Excel qu\u1ea3n l\u00fd [&hellip;]<\/p>\n<div class=\"pvc_clear\"><\/div>\n<p id=\"pvc_stats_80459\" class=\"pvc_stats total_only  \" data-element-id=\"80459\" style=\"\"><i class=\"pvc-stats-icon medium\" aria-hidden=\"true\"><svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" version=\"1.0\" viewBox=\"0 0 502 315\" preserveAspectRatio=\"xMidYMid meet\"><g transform=\"translate(0,332) scale(0.1,-0.1)\" fill=\"\" stroke=\"none\"><path d=\"M2394 3279 l-29 -30 -3 -207 c-2 -182 0 -211 15 -242 39 -76 157 -76 196 0 15 31 17 60 15 243 l-3 209 -33 29 c-26 23 -41 29 -80 29 -41 0 -53 -5 -78 -31z\"\/><path d=\"M3085 3251 c-45 -19 -58 -50 -96 -229 -47 -217 -49 -260 -13 -295 52 -53 146 -42 177 20 16 31 87 366 87 410 0 70 -86 122 -155 94z\"\/><path d=\"M1751 3234 c-13 -9 -29 -31 -37 -50 -12 -29 -10 -49 21 -204 19 -94 39 -189 45 -210 14 -50 54 -80 110 -80 34 0 48 6 76 34 21 21 34 44 34 59 0 14 -18 113 -40 219 -37 178 -43 195 -70 221 -36 32 -101 37 -139 11z\"\/><path d=\"M1163 3073 c-36 -7 -73 -59 -73 -102 0 -56 133 -378 171 -413 34 -32 83 -37 129 -13 70 36 67 87 -16 290 -86 209 -89 214 -129 231 -35 14 -42 15 -82 7z\"\/><path d=\"M3689 3066 c-15 -9 -33 -30 -42 -48 -48 -103 -147 -355 -147 -375 0 -98 131 -148 192 -74 13 15 57 108 97 206 80 196 84 226 37 273 -30 30 -99 39 -137 18z\"\/><path d=\"M583 2784 c-38 -19 -67 -74 -58 -113 9 -42 211 -354 242 -373 16 -10 45 -18 66 -18 51 0 107 52 107 100 0 39 -1 41 -124 234 -80 126 -108 162 -133 173 -41 17 -61 16 -100 -3z\"\/><path d=\"M4250 2784 c-14 -9 -74 -91 -133 -183 -95 -150 -107 -173 -107 -213 0 -55 33 -94 87 -104 67 -13 90 8 211 198 130 202 137 225 78 284 -27 27 -42 34 -72 34 -22 0 -50 -8 -64 -16z\"\/><path d=\"M2275 2693 c-553 -48 -1095 -270 -1585 -649 -135 -104 -459 -423 -483 -476 -23 -49 -22 -139 2 -186 73 -142 361 -457 571 -626 285 -228 642 -407 990 -497 242 -63 336 -73 660 -74 310 0 370 5 595 52 535 111 1045 392 1455 803 122 121 250 273 275 326 19 41 19 137 0 174 -41 79 -309 363 -465 492 -447 370 -946 591 -1479 653 -113 14 -422 18 -536 8z m395 -428 c171 -34 330 -124 456 -258 112 -119 167 -219 211 -378 27 -96 24 -300 -5 -401 -72 -255 -236 -447 -474 -557 -132 -62 -201 -76 -368 -76 -167 0 -236 14 -368 76 -213 98 -373 271 -451 485 -162 444 86 934 547 1084 153 49 292 57 452 25z m909 -232 c222 -123 408 -262 593 -441 76 -74 138 -139 138 -144 0 -16 -233 -242 -330 -319 -155 -123 -309 -223 -461 -299 l-81 -41 32 46 c18 26 49 83 70 128 143 306 141 649 -6 957 -25 52 -61 116 -79 142 l-34 47 45 -20 c26 -10 76 -36 113 -56z m-2057 25 c-40 -58 -105 -190 -130 -263 -110 -324 -59 -707 132 -981 25 -35 42 -64 37 -64 -19 0 -241 119 -326 174 -188 122 -406 314 -532 468 l-58 71 108 103 c185 178 428 349 672 473 66 33 121 60 123 61 2 0 -10 -19 -26 -42z\"\/><path d=\"M2375 1950 c-198 -44 -350 -190 -395 -379 -18 -76 -8 -221 19 -290 114 -284 457 -406 731 -260 98 52 188 154 231 260 27 69 37 214 19 290 -38 163 -166 304 -326 360 -67 23 -215 33 -279 19z\"\/><\/g><\/svg><\/i> <img loading=\"lazy\" decoding=\"async\" width=\"16\" height=\"16\" alt=\"Loading\" src=\"\/wp-content\/plugins\/page-views-count\/ajax-loader-2x.gif\" border=0 \/><\/p>\n<div class=\"pvc_clear\"><\/div>\n","protected":false},"author":143,"featured_media":81072,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"yasr_overall_rating":0,"yasr_post_is_review":"","yasr_auto_insert_disabled":"","yasr_review_type":"","footnotes":""},"categories":[1689,21],"tags":[],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v22.9 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Ph\u1ea7n m\u1ec1m qu\u1ea3n l\u00fd nh\u00e2n s\u1ef1 b\u1eb1ng Excel Mi\u1ec5n ph\u00ed, chu\u1ea9n nh\u1ea5t<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Ph\u1ea7n m\u1ec1m qu\u1ea3n l\u00fd nh\u00e2n s\u1ef1 b\u1eb1ng Excel Mi\u1ec5n ph\u00ed, chu\u1ea9n nh\u1ea5t","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/amis.misa.vn\/80459\/quan-ly-nhan-su-mien-phi-bang-excel\/","url":"https:\/\/amis.misa.vn\/80459\/quan-ly-nhan-su-mien-phi-bang-excel\/","name":"Ph\u1ea7n m\u1ec1m qu\u1ea3n l\u00fd nh\u00e2n s\u1ef1 b\u1eb1ng Excel Mi\u1ec5n ph\u00ed, chu\u1ea9n nh\u1ea5t","isPartOf":{"@id":"https:\/\/amis.misa.vn\/#website"},"primaryImageOfPage":{"@id":"https:\/\/amis.misa.vn\/80459\/quan-ly-nhan-su-mien-phi-bang-excel\/#primaryimage"},"image":{"@id":"https:\/\/amis.misa.vn\/80459\/quan-ly-nhan-su-mien-phi-bang-excel\/#primaryimage"},"thumbnailUrl":"\/wp-content\/uploads\/2023\/01\/phan-mem-quan-ly-nhan-su-bang-exce.jpg","datePublished":"2024-08-20T01:59:29+00:00","dateModified":"2024-11-29T08:08:14+00:00","author":{"@id":"https:\/\/amis.misa.vn\/#\/schema\/person\/6dc806a31a02f53277bf3c8e7c95af3f"},"description":"H\u00e3y c\u00f9ng v\u1edbi MISA AMIS t\u00ecm hi\u1ec3u c\u00e1ch s\u1eed d\u1ee5ng ph\u1ea7n m\u1ec1m excel qu\u1ea3n l\u00fd nh\u00e2n s\u1ef1 mi\u1ec5n ph\u00ed cho ng\u01b0\u1eddi l\u00e0m nh\u00e2n s\u1ef1 trong b\u00e0i vi\u1ebft sau \u0111\u00e2y nh\u00e9.","breadcrumb":{"@id":"https:\/\/amis.misa.vn\/80459\/quan-ly-nhan-su-mien-phi-bang-excel\/#breadcrumb"},"inLanguage":"vi","potentialAction":[{"@type":"ReadAction","target":["https:\/\/amis.misa.vn\/80459\/quan-ly-nhan-su-mien-phi-bang-excel\/"]}]},{"@type":"ImageObject","inLanguage":"vi","@id":"https:\/\/amis.misa.vn\/80459\/quan-ly-nhan-su-mien-phi-bang-excel\/#primaryimage","url":"\/wp-content\/uploads\/2023\/01\/phan-mem-quan-ly-nhan-su-bang-exce.jpg","contentUrl":"\/wp-content\/uploads\/2023\/01\/phan-mem-quan-ly-nhan-su-bang-exce.jpg","width":678,"height":355,"caption":"H\u01b0\u1edbng d\u1eabn s\u1eed d\u1ee5ng ph\u1ea7n m\u1ec1m qu\u1ea3n l\u00fd nh\u00e2n s\u1ef1 mi\u1ec5n ph\u00ed b\u1eb1ng excel"},{"@type":"BreadcrumbList","@id":"https:\/\/amis.misa.vn\/80459\/quan-ly-nhan-su-mien-phi-bang-excel\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/m.amis.vn\/"},{"@type":"ListItem","position":2,"name":"Ph\u1ea7n m\u1ec1m qu\u1ea3n l\u00fd nh\u00e2n s\u1ef1 b\u1eb1ng Excel Mi\u1ec5n ph\u00ed, chu\u1ea9n nh\u1ea5t"}]},{"@type":"Person","@id":"https:\/\/amis.misa.vn\/#\/schema\/person\/6dc806a31a02f53277bf3c8e7c95af3f","name":"HRM.A0474.dkhuyen","url":"https:\/\/amis.misa.vn\/"}]}},"yasr_visitor_votes":{"stars_attributes":{"read_only":false,"span_bottom":false},"number_of_votes":6,"sum_votes":30},"_links":{"self":[{"href":"https:\/\/amis.misa.vn\/wp-json\/wp\/v2\/posts\/80459"}],"collection":[{"href":"https:\/\/amis.misa.vn\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/amis.misa.vn\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/amis.misa.vn\/wp-json\/wp\/v2\/users\/143"}],"replies":[{"embeddable":true,"href":"https:\/\/amis.misa.vn\/wp-json\/wp\/v2\/comments?post=80459"}],"version-history":[{"count":8,"href":"https:\/\/amis.misa.vn\/wp-json\/wp\/v2\/posts\/80459\/revisions"}],"predecessor-version":[{"id":183623,"href":"https:\/\/amis.misa.vn\/wp-json\/wp\/v2\/posts\/80459\/revisions\/183623"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/amis.misa.vn\/wp-json\/wp\/v2\/media\/81072"}],"wp:attachment":[{"href":"https:\/\/amis.misa.vn\/wp-json\/wp\/v2\/media?parent=80459"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/amis.misa.vn\/wp-json\/wp\/v2\/categories?post=80459"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/amis.misa.vn\/wp-json\/wp\/v2\/tags?post=80459"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}