{"id":24236,"date":"2022-04-12T10:14:52","date_gmt":"2022-04-12T03:14:52","guid":{"rendered":"http:\/\/helpsme.misa.vn\/2022\/?post_type=ht_kb&#038;p=24236"},"modified":"2025-11-07T15:49:27","modified_gmt":"2025-11-07T08:49:27","slug":"nhap-khau-bang-tinh-luong-tu-excel","status":"publish","type":"ht_kb","link":"https:\/\/helpsme.misa.vn\/2026\/kb\/nhap-khau-bang-tinh-luong-tu-excel\/","title":{"rendered":"Nh\u1eadp kh\u1ea9u b\u1ea3ng t\u00ednh l\u01b0\u01a1ng t\u1eeb excel"},"content":{"rendered":"<div class=\"su-accordion su-u-trim\">\n<div class=\"su-spoiler su-spoiler-style-default su-spoiler-icon-plus\" data-scroll-offset=\"0\" data-anchor-in-url=\"no\"><div class=\"su-spoiler-title\" tabindex=\"0\" role=\"button\"><span class=\"su-spoiler-icon\"><\/span><\/p>\n<h3><strong>1. T\u1ed5ng quan<\/strong><\/h3>\n<p><\/div><div class=\"su-spoiler-content su-u-clearfix su-u-trim\">\n<p><strong>M\u1ee5c \u0111\u00edch:<\/strong>\u00a0B\u00e0i vi\u1ebft gi\u00fap Anh\/Ch\u1ecb n\u1eafm \u0111\u01b0\u1ee3c quy tr\u00ecnh t\u1ed5ng th\u1ec3 khi nh\u1eadp kh\u1ea9u d\u1eef li\u1ec7u b\u1ea3ng l\u01b0\u01a1ng t\u1eeb file Excel v\u00e0o ph\u1ea7n m\u1ec1m. Vi\u1ec7c n\u00e0y gi\u00fap ti\u1ebft ki\u1ec7m th\u1eddi gian, gi\u1ea3m sai s\u00f3t khi l\u1eadp b\u1ea3ng l\u01b0\u01a1ng v\u00e0 \u0111\u1ea3m b\u1ea3o d\u1eef li\u1ec7u \u0111\u01b0\u1ee3c \u0111\u1ed3ng b\u1ed9 ch\u00ednh x\u00e1c.<\/p>\n<p><strong>N\u1ed9i dung b\u00e0i vi\u1ebft g\u1ed3m:<\/strong><\/p>\n<ul>\n<li>Ch\u1ecdn t\u1ec7p ngu\u1ed3n Excel v\u00e0 ph\u01b0\u01a1ng th\u1ee9c nh\u1eadp kh\u1ea9u<\/li>\n<li>Gh\u00e9p d\u1eef li\u1ec7u gi\u1eefa ph\u1ea7n m\u1ec1m v\u00e0 file Excel<\/li>\n<li>Ki\u1ec3m tra, x\u1eed l\u00fd d\u1eef li\u1ec7u kh\u00f4ng h\u1ee3p l\u1ec7<\/li>\n<\/ul>\n<p><strong>Ph\u1ea1m vi \u00e1p d\u1ee5ng:<\/strong>\u00a0K\u1ebf to\u00e1n, nh\u00e2n s\u1ef1<\/p>\n<\/div><\/div> <div class=\"su-spoiler su-spoiler-style-default su-spoiler-icon-plus\" data-scroll-offset=\"0\" data-anchor-in-url=\"no\"><div class=\"su-spoiler-title\" tabindex=\"0\" role=\"button\"><span class=\"su-spoiler-icon\"><\/span><\/p>\n<h3><strong>2. C\u00e1c b\u01b0\u1edbc th\u1ef1c hi\u1ec7n<\/strong><\/h3>\n<p><\/div><div class=\"su-spoiler-content su-u-clearfix su-u-trim\">\n<p><strong>B\u01b0\u1edbc 1<\/strong>: Tr\u00ean giao di\u1ec7n <a href=\"\/2026\/kb\/lap_bang_tinh_luong\/\" target=\"_blank\" rel=\"noopener\">l\u1eadp b\u1ea3ng t\u00ednh l\u01b0\u01a1ng<\/a>, ch\u1ecdn ch\u1ee9c n\u0103ng <strong>Nh\u1eadp kh\u1ea9u<\/strong><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-24764\" src=\"https:\/\/helpsme.misa.vn\/2022\/wp-content\/uploads\/2022\/04\/nk-luong_1.png\" alt=\"\" width=\"975\" height=\"742\" srcset=\"\/2026\/wp-content\/uploads\/2022\/04\/nk-luong_1.png 975w, \/2026\/wp-content\/uploads\/2022\/04\/nk-luong_1-700x533.png 700w, \/2026\/wp-content\/uploads\/2022\/04\/nk-luong_1-800x609.png 800w, \/2026\/wp-content\/uploads\/2022\/04\/nk-luong_1-768x584.png 768w, \/2026\/wp-content\/uploads\/2022\/04\/nk-luong_1-50x38.png 50w, \/2026\/wp-content\/uploads\/2022\/04\/nk-luong_1-60x46.png 60w, \/2026\/wp-content\/uploads\/2022\/04\/nk-luong_1-100x76.png 100w\" sizes=\"auto, (max-width: 975px) 100vw, 975px\" \/><\/p>\n<p><strong>B\u01b0\u1edbc 2<\/strong>: L\u1ea7n l\u01b0\u1ee3t th\u1ef1c hi\u1ec7n c\u00e1c b\u01b0\u1edbc <a href=\"https:\/\/helpsme.misa.vn\/2026\/kb\/html_10050000\/\" target=\"_blank\" rel=\"noopener\">nh\u1eadp kh\u1ea9u excel<\/a> nh\u01b0 sau:<\/p>\n<ul style=\"list-style-type: circle;\">\n<li><strong>\u00a0Ch\u1ecdn t\u1ec7p ngu\u1ed3n<\/strong>: Ch\u1ecdn file excel ch\u1ee9a d\u1eef li\u1ec7u c\u1ea7n nh\u1eadp kh\u1ea9u. Sau \u0111\u00f3, ch\u1ecdn ph\u01b0\u01a1ng th\u1ee9c nh\u1eadp kh\u1ea9u.<\/li>\n<\/ul>\n<p style=\"padding-left: 40px;\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-24766\" src=\"https:\/\/helpsme.misa.vn\/2022\/wp-content\/uploads\/2022\/04\/nk-luong_2.png\" alt=\"\" width=\"918\" height=\"706\" srcset=\"\/2026\/wp-content\/uploads\/2022\/04\/nk-luong_2.png 918w, \/2026\/wp-content\/uploads\/2022\/04\/nk-luong_2-700x538.png 700w, \/2026\/wp-content\/uploads\/2022\/04\/nk-luong_2-800x615.png 800w, \/2026\/wp-content\/uploads\/2022\/04\/nk-luong_2-768x591.png 768w, \/2026\/wp-content\/uploads\/2022\/04\/nk-luong_2-50x38.png 50w, \/2026\/wp-content\/uploads\/2022\/04\/nk-luong_2-60x46.png 60w, \/2026\/wp-content\/uploads\/2022\/04\/nk-luong_2-100x77.png 100w\" sizes=\"auto, (max-width: 918px) 100vw, 918px\" \/><\/p>\n<ul style=\"list-style-type: circle;\">\n<li><strong>Gh\u00e9p d\u1eef li\u1ec7u<\/strong>: Gh\u00e9p c\u1ed9t d\u1eef li\u1ec7u tr\u00ean ph\u1ea7n m\u1ec1m v\u1edbi c\u1ed9t d\u1eef li\u1ec7u trong file excel.<\/li>\n<\/ul>\n<p style=\"padding-left: 40px;\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-24767\" src=\"https:\/\/helpsme.misa.vn\/2022\/wp-content\/uploads\/2022\/04\/nk-luong_3.png\" alt=\"\" width=\"920\" height=\"707\" srcset=\"\/2026\/wp-content\/uploads\/2022\/04\/nk-luong_3.png 920w, \/2026\/wp-content\/uploads\/2022\/04\/nk-luong_3-700x538.png 700w, \/2026\/wp-content\/uploads\/2022\/04\/nk-luong_3-800x615.png 800w, \/2026\/wp-content\/uploads\/2022\/04\/nk-luong_3-768x590.png 768w, \/2026\/wp-content\/uploads\/2022\/04\/nk-luong_3-50x38.png 50w, \/2026\/wp-content\/uploads\/2022\/04\/nk-luong_3-60x46.png 60w, \/2026\/wp-content\/uploads\/2022\/04\/nk-luong_3-100x77.png 100w\" sizes=\"auto, (max-width: 920px) 100vw, 920px\" \/><\/p>\n<ul style=\"list-style-type: circle;\">\n<li><strong>Ki\u1ec3m tra d\u1eef li\u1ec7u<\/strong>: Ch\u01b0\u01a1ng tr\u00ecnh hi\u1ec3n th\u1ecb c\u00e1c d\u1eef li\u1ec7u kh\u00f4ng h\u1ee3p l\u1ec7 (n\u1ebfu c\u00f3) \u0111\u1ec3 ng\u01b0\u1eddi d\u00f9ng ki\u1ec3m tra l\u1ea1i.<\/li>\n<\/ul>\n<p style=\"padding-left: 40px;\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-24768\" src=\"https:\/\/helpsme.misa.vn\/2022\/wp-content\/uploads\/2022\/04\/nk-luong_4.png\" alt=\"\" width=\"919\" height=\"705\" srcset=\"\/2026\/wp-content\/uploads\/2022\/04\/nk-luong_4.png 919w, \/2026\/wp-content\/uploads\/2022\/04\/nk-luong_4-700x537.png 700w, \/2026\/wp-content\/uploads\/2022\/04\/nk-luong_4-800x614.png 800w, \/2026\/wp-content\/uploads\/2022\/04\/nk-luong_4-768x589.png 768w, \/2026\/wp-content\/uploads\/2022\/04\/nk-luong_4-50x38.png 50w, \/2026\/wp-content\/uploads\/2022\/04\/nk-luong_4-60x46.png 60w, \/2026\/wp-content\/uploads\/2022\/04\/nk-luong_4-100x77.png 100w\" sizes=\"auto, (max-width: 919px) 100vw, 919px\" \/><\/p>\n<\/div><\/div> <\/div>\n","protected":false},"excerpt":{"rendered":"","protected":false},"author":107,"comment_status":"closed","ping_status":"closed","template":"","format":"standard","meta":{"_links_to":"","_links_to_target":"","footnotes":""},"ht-kb-category":[2592],"ht-kb-tag":[],"class_list":["post-24236","ht_kb","type-ht_kb","status-publish","format-standard","hentry","ht_kb_category-tien-luong"],"_links":{"self":[{"href":"https:\/\/helpsme.misa.vn\/2026\/wp-json\/wp\/v2\/ht-kb\/24236","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/helpsme.misa.vn\/2026\/wp-json\/wp\/v2\/ht-kb"}],"about":[{"href":"https:\/\/helpsme.misa.vn\/2026\/wp-json\/wp\/v2\/types\/ht_kb"}],"author":[{"embeddable":true,"href":"https:\/\/helpsme.misa.vn\/2026\/wp-json\/wp\/v2\/users\/107"}],"replies":[{"embeddable":true,"href":"https:\/\/helpsme.misa.vn\/2026\/wp-json\/wp\/v2\/comments?post=24236"}],"version-history":[{"count":4,"href":"https:\/\/helpsme.misa.vn\/2026\/wp-json\/wp\/v2\/ht-kb\/24236\/revisions"}],"predecessor-version":[{"id":55747,"href":"https:\/\/helpsme.misa.vn\/2026\/wp-json\/wp\/v2\/ht-kb\/24236\/revisions\/55747"}],"wp:attachment":[{"href":"https:\/\/helpsme.misa.vn\/2026\/wp-json\/wp\/v2\/media?parent=24236"}],"wp:term":[{"taxonomy":"ht_kb_category","embeddable":true,"href":"https:\/\/helpsme.misa.vn\/2026\/wp-json\/wp\/v2\/ht-kb-category?post=24236"},{"taxonomy":"ht_kb_tag","embeddable":true,"href":"https:\/\/helpsme.misa.vn\/2026\/wp-json\/wp\/v2\/ht-kb-tag?post=24236"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}