{"id":21435,"date":"2022-06-29T10:02:35","date_gmt":"2022-06-29T03:02:35","guid":{"rendered":"http:\/\/helpact.misa.vn\/?post_type=ht_kb&#038;p=21435"},"modified":"2025-12-09T09:02:49","modified_gmt":"2025-12-09T02:02:49","slug":"nhap-khau-bang-tinh-luong-tu-excel","status":"publish","type":"ht_kb","link":"http:\/\/helpasp.misa.vn\/accounting\/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>1. T\u1ed5ng quan<\/h3>\n<p><\/div><div class=\"su-spoiler-content su-u-clearfix su-u-trim\">\n<p><strong>M\u1ee5c \u0111\u00edch:<\/strong>B\u00e0i vi\u1ebft gi\u00fap Anh\/Ch\u1ecb hi\u1ec3u r\u00f5 m\u1ee5c \u0111\u00edch v\u00e0 c\u00e1ch th\u1ef1c hi\u1ec7n nh\u1eadp kh\u1ea9u d\u1eef li\u1ec7u b\u1ea3ng l\u01b0\u01a1ng t\u1eeb file Excel v\u00e0o ph\u1ea7n m\u1ec1m, h\u1ed7 tr\u1ee3 ti\u1ebft ki\u1ec7m th\u1eddi gian, gi\u1ea3m sai s\u00f3t khi l\u1eadp b\u1ea3ng l\u01b0\u01a1ng.<\/p>\n<p><strong>N\u1ed9i dung:<\/strong><\/p>\n<ul style=\"list-style-type: disc;\">\n<li>H\u01b0\u1edbng d\u1eabn c\u00e1c b\u01b0\u1edbc th\u1ef1c hi\u1ec7n nh\u1eadp kh\u1ea9u b\u1ea3ng t\u00ednh l\u01b0\u01a1ng t\u1eeb Excel.<\/li>\n<li>Tr\u00ecnh b\u00e0y chi ti\u1ebft t\u1eebng thao t\u00e1c: ch\u1ecdn t\u1ec7p ngu\u1ed3n, gh\u00e9p d\u1eef li\u1ec7u, ki\u1ec3m tra d\u1eef li\u1ec7u v\u00e0 nh\u1eadp d\u1eef li\u1ec7u v\u00e0o ph\u1ea7n m\u1ec1m.<\/li>\n<\/ul>\n<p><strong>Ph\u1ea1m vi \u00e1p d\u1ee5ng:<\/strong> K\u1ebf to\u00e1n, nh\u00e2n s\u1ef1, qu\u1ea3n tr\u1ecb vi\u00ean.<\/p>\n<\/div><\/div>\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>2. C\u00e1c b\u01b0\u1edbc th\u1ef1c hi\u1ec7n<\/h3>\n<p><\/div><div class=\"su-spoiler-content su-u-clearfix su-u-trim\">\n<ul style=\"list-style-type: disc;\">\n<li>Tr\u00ean giao di\u1ec7n <a href=\"https:\/\/helpasp.misa.vn\/accounting\/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 t\u1eeb excel<\/strong>.<\/li>\n<\/ul>\n<p><img decoding=\"async\" src=\"https:\/\/helpact.misa.vn\/wp-content\/uploads\/2022\/10\/nk_1.png\" \/><\/p>\n<ul style=\"list-style-type: disc;\">\n<li>L\u1ea7n l\u01b0\u1ee3t th\u1ef1c hi\u1ec7n c\u00e1c b\u01b0\u1edbc nh\u1eadp kh\u1ea9u excel nh\u01b0 sau:<\/li>\n<\/ul>\n<p><strong>B\u01b0\u1edbc 1:<\/strong> <strong>Ch\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.<\/p>\n<p><em><strong>L\u01b0u \u00fd<\/strong>: Khi ch\u1ecdn t\u1ea3i t\u1ec7p d\u1eef li\u1ec7u b\u1ea3ng l\u01b0\u01a1ng m\u1eabu, ch\u01b0\u01a1ng tr\u00ecnh s\u1ebd t\u1ef1 \u0111\u1ed9ng l\u1ea5y lu\u00f4n danh s\u00e1ch nh\u00e2n vi\u00ean v\u00e0 c\u00e1c c\u1ed9t d\u1eef li\u1ec7u t\u01b0\u01a1ng \u1ee9ng tr\u00ean ph\u1ea7n m\u1ec1m xu\u1ed1ng file excel, ng\u01b0\u1eddi d\u00f9ng ch\u1ec9 c\u1ea7n b\u1ed5 sung c\u00e1c s\u1ed1 li\u1ec7u li\u00ean quan.<\/em><\/p>\n<p><img decoding=\"async\" src=\"https:\/\/helpact.misa.vn\/wp-content\/uploads\/2022\/10\/nk_2.png\" \/><\/p>\n<p><strong>B\u01b0\u1edbc 2:<\/strong> <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.<\/p>\n<p><img decoding=\"async\" src=\"https:\/\/helpact.misa.vn\/wp-content\/uploads\/2022\/10\/nk_3.png\" \/><\/p>\n<p><strong>B\u01b0\u1edbc 3: 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 Anh\/Ch\u1ecb ki\u1ec3m tra l\u1ea1i.<strong><\/p>\n<p><img decoding=\"async\" src=\"https:\/\/helpact.misa.vn\/wp-content\/uploads\/2022\/10\/nk_4.png\" \/><\/strong><\/p>\n<p><strong>B\u01b0\u1edbc 4:\u00a0<\/strong>Nh\u1ea5n <strong>Nh\u1eadp d\u1eef li\u1ec7u<\/strong>: Ch\u01b0\u01a1ng tr\u00ecnh hi\u1ec3n th\u1ecb k\u1ebft qu\u1ea3 nh\u1eadp kh\u1ea9u.<\/p>\n<p><img decoding=\"async\" src=\"https:\/\/helpact.misa.vn\/wp-content\/uploads\/2022\/10\/nk_5.png\" \/><\/p>\n<\/div><\/div>\n<\/div>\n","protected":false},"excerpt":{"rendered":"","protected":false},"author":115,"comment_status":"closed","ping_status":"closed","template":"","format":"standard","meta":{"footnotes":"","_links_to":"","_links_to_target":""},"ht-kb-category":[3493],"ht-kb-tag":[],"class_list":["post-21435","ht_kb","type-ht_kb","status-publish","format-standard","hentry","ht_kb_category-tien-luong"],"_links":{"self":[{"href":"http:\/\/helpasp.misa.vn\/accounting\/wp-json\/wp\/v2\/ht-kb\/21435","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/helpasp.misa.vn\/accounting\/wp-json\/wp\/v2\/ht-kb"}],"about":[{"href":"http:\/\/helpasp.misa.vn\/accounting\/wp-json\/wp\/v2\/types\/ht_kb"}],"author":[{"embeddable":true,"href":"http:\/\/helpasp.misa.vn\/accounting\/wp-json\/wp\/v2\/users\/115"}],"replies":[{"embeddable":true,"href":"http:\/\/helpasp.misa.vn\/accounting\/wp-json\/wp\/v2\/comments?post=21435"}],"version-history":[{"count":4,"href":"http:\/\/helpasp.misa.vn\/accounting\/wp-json\/wp\/v2\/ht-kb\/21435\/revisions"}],"predecessor-version":[{"id":47521,"href":"http:\/\/helpasp.misa.vn\/accounting\/wp-json\/wp\/v2\/ht-kb\/21435\/revisions\/47521"}],"wp:attachment":[{"href":"http:\/\/helpasp.misa.vn\/accounting\/wp-json\/wp\/v2\/media?parent=21435"}],"wp:term":[{"taxonomy":"ht_kb_category","embeddable":true,"href":"http:\/\/helpasp.misa.vn\/accounting\/wp-json\/wp\/v2\/ht-kb-category?post=21435"},{"taxonomy":"ht_kb_tag","embeddable":true,"href":"http:\/\/helpasp.misa.vn\/accounting\/wp-json\/wp\/v2\/ht-kb-tag?post=21435"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}