{"id":34771,"date":"2026-10-13T08:34:28","date_gmt":"2026-10-13T01:34:28","guid":{"rendered":"\/tien-luong\/?post_type=ht_kb&#038;p=34771"},"modified":"2026-10-13T08:34:28","modified_gmt":"2026-10-13T01:34:28","slug":"lam-the-nao-de-xuat-danh-sach-can-bo-nhan-vien-ra-excel","status":"publish","type":"ht_kb","link":"\/tien-luong\/knowledge-base\/lam-the-nao-de-xuat-danh-sach-can-bo-nhan-vien-ra-excel\/","title":{"rendered":"L\u00e0m th\u1ebf n\u00e0o \u0111\u1ec3 xu\u1ea5t danh s\u00e1ch c\u00e1n b\u1ed9 nh\u00e2n vi\u00ean ra excel?"},"content":{"rendered":"<h3 id=\"1-tong-quan\"><strong>1. T\u1ed5ng quan<\/strong><\/h3>\n<p>B\u00e0i vi\u1ebft n\u00e0y h\u01b0\u1edbng d\u1eabn anh\/ch\u1ecb c\u00e1ch xu\u1ea5t danh s\u00e1ch c\u00e1n b\u1ed9 nh\u00e2n vi\u00ean tr\u00ean ph\u1ea7n m\u1ec1m ra excel \u0111\u1ec3 ki\u1ec3m tra, qu\u1ea3n l\u00fd, s\u1eed d\u1ee5ng theo nhu c\u1ea7u c\u1ee7a \u0111\u01a1n v\u1ecb.<\/p>\n<h3 id=\"2-cac-buoc-thuc-hien\"><strong>2. C\u00e1c b\u01b0\u1edbc th\u1ef1c hi\u1ec7n<\/strong><\/h3>\n<h4 id=\"2-1-cach-1-xuat-tu-bang-luong-phu-cap-hang-thang-da-lap\"><strong>2.1. C\u00e1ch 1: Xu\u1ea5t t\u1eeb b\u1ea3ng l\u01b0\u01a1ng, ph\u1ee5 c\u1ea5p h\u00e0ng th\u00e1ng \u0111\u00e3 l\u1eadp<\/strong><\/h4>\n<p><strong>B\u01b0\u1edbc 1:<\/strong>\u00a0V\u00e0o\u00a0<strong>T\u00ednh l\u01b0\u01a1ng\\L\u01b0\u01a1ng, ph\u1ee5 c\u1ea5p<\/strong><\/p>\n<p><strong>B\u01b0\u1edbc 2:<\/strong>\u00a0Nh\u1ea5n v\u00e0o bi\u1ec3u t\u01b0\u1ee3ng d\u1ea5u 3 ch\u1ea5m t\u1ea1i d\u00f2ng b\u1ea3ng l\u01b0\u01a1ng c\u1ea7n xu\u1ea5t ra excel\\ ch\u1ecdn\u00a0<strong>Xu\u1ea5t Excel.<\/strong><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-39569 size-full\" src=\"https:\/\/salagov2help.misa.vn\/wp-content\/uploads\/2026\/06\/2026-06-15-3f.png\" alt=\"\" width=\"1318\" height=\"606\" \/><\/p>\n<p><strong>B\u01b0\u1edbc 3:<\/strong>\u00a0S\u1eed d\u1ee5ng b\u1ea3ng l\u01b0\u01a1ng \u0111\u1ec3 t\u1ea1o danh s\u00e1ch c\u00e1n b\u1ed9 theo nhu c\u1ea7u \u0111\u01a1n v\u1ecb.<\/p>\n<p class=\"x12ofw9d\"><strong>L\u01b0u \u00fd:<\/strong> File Excel xu\u1ea5t t\u1eeb b\u1ea3ng l\u01b0\u01a1ng ch\u1ec9 hi\u1ec3n th\u1ecb c\u00e1c th\u00f4ng tin c\u00f3 tr\u00ean b\u1ea3ng l\u01b0\u01a1ng. Anh\/ch\u1ecb c\u00f3 th\u1ec3 thi\u1ebft l\u1eadp \u1ea9n\/hi\u1ec7n c\u1ed9t tr\u00ean b\u1ea3ng l\u01b0\u01a1ng \u0111\u1ec3 xem c\u00e1c th\u00f4ng tin c\u00f3 th\u1ec3 xu\u1ea5t.<\/p>\n<p class=\"x12ofw9d\">\u0110\u1ec3 xu\u1ea5t b\u1ea3ng l\u01b0\u01a1ng c\u00f3 th\u00f4ng tin t\u00e0i kho\u1ea3n ng\u00e2n h\u00e0ng\/ATM c\u1ee7a c\u00e1n b\u1ed9 nh\u00e2n vi\u00ean, anh\/ch\u1ecb c\u00f3 th\u1ec3 xu\u1ea5t <strong>B\u1ea3ng thanh to\u00e1n 20<\/strong> ho\u1eb7c ch\u1ecdn <strong>In b\u00e1o c\u00e1o C02a-HD<\/strong>, sau \u0111\u00f3 ch\u1ec9nh s\u1eeda m\u1eabu \u0111\u1ec3 hi\u1ec3n th\u1ecb th\u00f4ng tin t\u00e0i kho\u1ea3n theo h\u01b0\u1edbng d\u1eabn <a href=\"https:\/\/helpihos.misa.vn\/tien-luong\/kb\/lap-bao-cao-c02a-hd-bang-thanh-toan-tien-luong-va-cac-khoan-phu-cap-theo-luong-cac-khoan-trich-nop-theo-luong\/\" target=\"_blank\" rel=\"noopener\">t\u1ea1i \u0111\u00e2y.<\/a><\/p>\n<h4 id=\"2-2-cach-2-copy-bang-danh-sach-can-bo-nhan-vien-khi-thuc-hien-chuc-nang-cap-nhat-hang-loat\"><strong>2.2. C\u00e1ch 2: Copy b\u1ea3ng danh s\u00e1ch c\u00e1n b\u1ed9 nh\u00e2n vi\u00ean khi th\u1ef1c hi\u1ec7n ch\u1ee9c n\u0103ng c\u1eadp nh\u1eadt h\u00e0ng lo\u1ea1t<\/strong><\/h4>\n<p><strong>B\u01b0\u1edbc 1:<\/strong>\u00a0V\u00e0o\u00a0<strong>C\u00e1n b\u1ed9 nh\u00e2n vi\u00ean<\/strong><\/p>\n<p><strong>B\u01b0\u1edbc 2:<\/strong>\u00a0Nh\u1ea5n\u00a0<strong>Ti\u1ec7n \u00edch\\C\u1eadp nh\u1eadt th\u00f4ng tin h\u00e0ng lo\u1ea1t<\/strong><\/p>\n<p><strong>B\u01b0\u1edbc 3:<\/strong>\u00a0Ch\u1ecdn c\u00e1c th\u00f4ng tin c\u1ea7n xu\u1ea5t\\ Nh\u1ea5n\u00a0<strong>Ti\u1ebfp t\u1ee5c<\/strong><\/p>\n<p>Ch\u1ecdn th\u00f4ng tin c\u1ea7n xu\u1ea5t kh\u1ea9u:<\/p>\n<ul>\n<li><strong>Th\u00f4ng tin chung:<\/strong>\u00a0Ng\u00e0y v\u00e0o \u0111\u01a1n v\u1ecb, lo\u1ea1i c\u00e1n b\u1ed9, ph\u00f2ng ban, tr\u1ea1ng th\u00e1i l\u00e0m vi\u1ec7c, bi\u00ean ch\u1ebf, mail, s\u1ed1 t\u00e0i kho\u1ea3n ng\u00e2n h\u00e0ng,\u2026<\/li>\n<li><strong>Qu\u00e1 tr\u00ecnh l\u01b0\u01a1ng:<\/strong>\u00a0Th\u00f4ng tin ch\u01b0\u01a1ng kho\u1ea3n, ti\u1ec3u m\u1ee5c, ng\u1ea1ch l\u01b0\u01a1ng, h\u1ec7 s\u1ed1,\u2026 c\u1ee7a c\u00e1c qu\u00e1 tr\u00ecnh l\u01b0\u01a1ng.<\/li>\n<li><strong>Qu\u00e1 tr\u00ecnh ph\u1ee5 c\u1ea5p:<\/strong>\u00a0Th\u00f4ng tin qu\u00e1 tr\u00ecnh ph\u1ee5 c\u1ea5p nh\u01b0 ch\u01b0\u01a1ng, kho\u1ea3n, ti\u1ec3u m\u1ee5c, h\u1ec7 s\u1ed1, t\u1ef7 l\u1ec7 theo t\u1eebng lo\u1ea1i ph\u1ee5 c\u1ea5p t\u1ea1i \u0111\u01a1n v\u1ecb<\/li>\n<li><strong>Th\u00f4ng tin b\u1ea3o hi\u1ec3m:<\/strong>\u00a0Thay \u0111\u1ed5i ho\u1eb7c\u00a0<b data-path-to-node=\"8,2,0,0\" data-index-in-node=\"14\">x\u00f3a b\u1ecf danh s\u00e1ch<\/b>\u00a0n\u1ed9p Kinh ph\u00ed c\u00f4ng \u0111o\u00e0n (KPC\u0110) hay ch\u00ednh l\u00e0 s\u1eeda, x\u00f3a t\u1ef7 l\u1ec7 c\u01a1 quan \u0111\u00f3ng, ng\u01b0\u1eddi lao \u0111\u1ed9ng \u0111\u00f3ng, c\u00f4ng th\u1ee9c t\u00ednh t\u1eebng lo\u1ea1i b\u1ea3o hi\u1ec3m (BHXH, BHYT, BHTN) v\u00e0\u00a0<b data-path-to-node=\"10,3,2,0\" data-index-in-node=\"112\">2% Kinh ph\u00ed c\u00f4ng \u0111o\u00e0n (KPC\u0110)<\/b><\/li>\n<li><strong>Th\u00f4ng tin thu\u1ebf TNCN:<\/strong>\u00a0Th\u00f4ng tin v\u1ec1 c\u00e1 nh\u00e2n c\u01b0 tr\u00fa, m\u00e3 s\u1ed1 thu\u1ebf, s\u1ed1 CCCD,\u2026<\/li>\n<li><strong>Ng\u01b0\u1eddi ph\u1ee5 thu\u1ed9c:<\/strong>\u00a0C\u1eadp nh\u1eadt th\u00f4ng tin v\u1ec1 ng\u01b0\u1eddi ph\u1ee5 thu\u1ed9c<\/li>\n<\/ul>\n<p>Ch\u1ecdn\u00a0<strong>Ph\u1ea1m vi<\/strong>\u00a0<strong>c\u1eadp nh\u1eadt<\/strong>\u00a0t\u01b0\u01a1ng \u1ee9ng v\u1edbi ph\u1ea1m vi c\u1ea7n xu\u1ea5t kh\u1ea9u<\/p>\n<ul>\n<li><strong>T\u1ea5t c\u1ea3<\/strong>: Xu\u1ea5t to\u00e0n b\u1ed9 d\u1eef li\u1ec7u.<\/li>\n<li><strong>T\u00f9y ch\u1ecdn c\u00e1n b\u1ed9<\/strong>: Nh\u1ea5n\u00a0<strong>Ch\u1ecdn c\u00e1n b\u1ed9<\/strong>\u00a0\u0111\u1ec3 ch\u1ecdn c\u00e1c c\u00e1n b\u1ed9 c\u1ea7n xu\u1ea5t. Trong c\u1eeda s\u1ed5 ch\u1ecdn c\u00e1n b\u1ed9, c\u00f3 th\u1ec3 nh\u1ea5n\u00a0<strong>bi\u1ec3u t\u01b0\u1ee3ng L\u1ecdc<\/strong>\u00a0c\u1ea1nh \u00f4 t\u00ecm ki\u1ebfm \u0111\u1ec3 l\u1ecdc nhanh theo\u00a0<strong>ph\u00f2ng ban<\/strong>,\u00a0<strong>lo\u1ea1i c\u00e1n b\u1ed9<\/strong>\u00a0ho\u1eb7c\u00a0<strong>th\u1ebb<\/strong>.<\/li>\n<\/ul>\n<p><strong>L\u01b0u \u00fd:<\/strong> C\u1ea7n t\u00edch ch\u1ecdn <strong>S\u1eeda \u0111\u1ed5i<\/strong> v\u1edbi nh\u1eefng th\u00f4ng tin d\u1ea1ng danh s\u00e1ch nh\u01b0 qu\u00e1 tr\u00ecnh l\u01b0\u01a1ng, qu\u00e1 tr\u00ecnh ph\u1ee5 c\u1ea5p, Ng\u01b0\u1eddi ph\u1ee5 thu\u1ed9c.<\/p>\n<p><strong>B\u01b0\u1edbc 4:<\/strong>\u00a0Th\u1ef1c hi\u1ec7n copy b\u1ea3ng d\u1eef li\u1ec7u t\u1eeb ph\u1ea7n m\u1ec1m ra file excel<\/p>\n<p>Ph\u1ea7n m\u1ec1m hi\u1ec3n th\u1ecb danh s\u00e1ch c\u00e1n b\u1ed9, nh\u00e2n vi\u00ean theo c\u00e1c th\u00f4ng tin \u0111\u00e3 ch\u1ecdn \u1edf B\u01b0\u1edbc 3 d\u01b0\u1edbi d\u1ea1ng b\u1ea3ng Excel. Anh\/ch\u1ecb sao ch\u00e9p to\u00e0n b\u1ed9 b\u1ea3ng v\u00e0 d\u00e1n v\u00e0o file Excel b\u00ean ngo\u00e0i.<\/p>\n<p>Tham kh\u1ea3o h\u01b0\u1edbng d\u1eabn c\u1eadp nh\u1eadt th\u00f4ng tin h\u00e0ng lo\u1ea1t\u00a0<a href=\"https:\/\/helpihos.misa.vn\/tien-luong\/knowledge-base\/lam-the-nao-de-cap-nhat-thong-tin-hang-loat-cho-can-bo-nhan-vien\/\" target=\"_blank\" rel=\"noopener\">t\u1ea1i \u0111\u00e2y.<\/a><\/p>\n<h4 id=\"2-3-cach-3-xuat-khau-tu-igov-he-thong\"><strong>2.3. C\u00e1ch 3: Xu\u1ea5t kh\u1ea9u t\u1eeb iHOS H\u1ec7 th\u1ed1ng<\/strong><\/h4>\n<p><strong>1. <\/strong>K\u00edch ch\u1ecdn bi\u1ec3u t\u01b0\u1ee3ng 9 \u00f4 vu\u00f4ng g\u00f3c b\u00ean tr\u00e1i m\u00e0n h\u00ecnh, anh\/ ch\u1ecb ch\u1ecdn\u00a0<strong>H\u1ec7 th\u1ed1ng\u00a0<\/strong><\/p>\n<p>ho\u1eb7c \u0111\u0103ng nh\u1eadp v\u00e0o link<a href=\"https:\/\/ihosapp.misa.vn\/home,\" target=\"_blank\" rel=\"noopener\"> https:\/\/ihosapp.misa.vn\/home,<\/a> t\u00edch ch\u1ecdn\u00a0<strong>h\u1ec7 th\u1ed1ng.<\/strong><\/p>\n<p>L\u01b0u \u00fd: N\u1ebfu kh\u00f4ng \u0111\u01b0\u1ee3c ph\u00e2n quy\u1ec1n v\u00e0o \u1ee9ng d\u1ee5ng h\u1ec7 th\u1ed1ng anh\/ch\u1ecb li\u00ean h\u1ec7 c\u00e1n b\u1ed9 c\u00f3 quy\u1ec1n admin ho\u1eb7c c\u00f3 quy\u1ec1n tr\u00ean \u1ee9ng d\u1ee5ng iHOS H\u1ec7 th\u1ed1ng \u0111\u1ec3 th\u1ef1c hi\u1ec7n th\u00eam c\u00e1n b\u1ed9.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-34427 size-full\" src=\"https:\/\/helpihos.misa.vn\/tien-luong\/wp-content\/uploads\/2026\/09\/1.png\" alt=\"\" width=\"995\" height=\"863\" \/><\/p>\n<p><strong>B\u01b0\u1edbc 2. <\/strong>V\u00e0o\u00a0<b>Danh m\u1ee5c<\/b>, ch\u1ecdn\u00a0<b>\u0110\u1ed1i t\u01b0\u1ee3ng\\ <\/b>Ch\u1ecdn Tab<b> Nh\u00e2n vi\u00ean.<\/b><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-35823 size-full\" src=\"https:\/\/helpigov.misa.vn\/tien-luong\/wp-content\/uploads\/2026\/09\/2026-09-28-3ad.png\" alt=\"\" width=\"1602\" height=\"811\" \/><\/p>\n<p><strong>B\u01b0\u1edbc 3.<\/strong> Nh\u1ea5n v\u00e0o bi\u1ec3u t\u01b0\u1ee3ng xu\u1ea5t kh\u1ea9u <strong class=\"x7amdea\">b\u00ean tr\u00e1i bi\u1ec3u t\u01b0\u1ee3ng m\u0169i t\u00ean xoay \ud83d\udd04<\/strong> \u0111\u1ec3 xu\u1ea5t danh s\u00e1ch c\u00e1n b\u1ed9 nh\u00e2n vi\u00ean ra excel.<\/p>\n<h3 id=\"3-luu-y\"><strong>3. L\u01b0u \u00fd<\/strong><\/h3>\n<p>Tr\u01b0\u1eddng h\u1ee3p c\u1ea7n xu\u1ea5t th\u00f4ng tin c\u00e1n b\u1ed9 nh\u00e2n vi\u00ean \u0111\u00e3 c\u00f3 ra excel \u0111\u1ec3 ch\u1ec9nh s\u1eeda r\u1ed3i nh\u1eadp kh\u1ea9u nh\u1eadp nh\u1eadt l\u1ea1i anh\/ch\u1ecb l\u00e0m theo h\u01b0\u1edbng d\u1eabn <a href=\"https:\/\/helpihos.misa.vn\/tien-luong\/knowledge-base\/lam-the-nao-de-cap-nhat-thong-tin-hang-loat-cho-can-bo-nhan-vien\/\" target=\"_blank\" rel=\"noopener\">t\u1ea1i \u0111\u00e2y.<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>1. T\u1ed5ng quan B\u00e0i vi\u1ebft n\u00e0y h\u01b0\u1edbng d\u1eabn anh\/ch\u1ecb c\u00e1ch xu\u1ea5t danh s\u00e1ch c\u00e1n b\u1ed9 nh\u00e2n vi\u00ean tr\u00ean ph\u1ea7n m\u1ec1m ra excel \u0111\u1ec3 ki\u1ec3m tra, qu\u1ea3n l\u00fd, s\u1eed d\u1ee5ng theo nhu c\u1ea7u c\u1ee7a \u0111\u01a1n v\u1ecb. 2. C\u00e1c b\u01b0\u1edbc th\u1ef1c hi\u1ec7n 2.1. C\u00e1ch 1: Xu\u1ea5t t\u1eeb b\u1ea3ng l\u01b0\u01a1ng, ph\u1ee5 c\u1ea5p h\u00e0ng&#8230;<\/p>\n","protected":false},"author":59,"comment_status":"closed","ping_status":"closed","template":"","format":"standard","meta":{"_links_to":"","_links_to_target":"","footnotes":""},"ht-kb-category":[191],"ht-kb-tag":[],"class_list":["post-34771","ht_kb","type-ht_kb","status-publish","format-standard","hentry","ht_kb_category-can-bo-nhan-vien"],"_links":{"self":[{"href":"\/tien-luong\/wp-json\/wp\/v2\/ht-kb\/34771","targetHints":{"allow":["GET"]}}],"collection":[{"href":"\/tien-luong\/wp-json\/wp\/v2\/ht-kb"}],"about":[{"href":"\/tien-luong\/wp-json\/wp\/v2\/types\/ht_kb"}],"author":[{"embeddable":true,"href":"\/tien-luong\/wp-json\/wp\/v2\/users\/59"}],"replies":[{"embeddable":true,"href":"\/tien-luong\/wp-json\/wp\/v2\/comments?post=34771"}],"version-history":[{"count":1,"href":"\/tien-luong\/wp-json\/wp\/v2\/ht-kb\/34771\/revisions"}],"predecessor-version":[{"id":34773,"href":"\/tien-luong\/wp-json\/wp\/v2\/ht-kb\/34771\/revisions\/34773"}],"wp:attachment":[{"href":"\/tien-luong\/wp-json\/wp\/v2\/media?parent=34771"}],"wp:term":[{"taxonomy":"ht_kb_category","embeddable":true,"href":"\/tien-luong\/wp-json\/wp\/v2\/ht-kb-category?post=34771"},{"taxonomy":"ht_kb_tag","embeddable":true,"href":"\/tien-luong\/wp-json\/wp\/v2\/ht-kb-tag?post=34771"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}