{"id":33289,"date":"2025-01-15T16:07:44","date_gmt":"2025-01-15T09:07:44","guid":{"rendered":"https:\/\/helpmimosa.misa.vn\/2025\/?post_type=ht_kb&#038;p=33289"},"modified":"2025-01-15T16:07:44","modified_gmt":"2025-01-15T09:07:44","slug":"them-nhanh-hang-loat-giay-rut-du-toan","status":"publish","type":"ht_kb","link":"https:\/\/helpmimosa.misa.vn\/2025\/kb\/them-nhanh-hang-loat-giay-rut-du-toan\/","title":{"rendered":"Th\u00eam nhanh h\u00e0ng lo\u1ea1t gi\u1ea5y r\u00fat d\u1ef1 to\u00e1n"},"content":{"rendered":"<h2 id=\"1-muc-dich\">1. M\u1ee5c \u0111\u00edch<\/h2>\n<p>K\u1ebf to\u00e1n c\u00f3 th\u1ec3 th\u00eam nhanh h\u00e0ng lo\u1ea1t gi\u1ea5y r\u00fat d\u1ef1 to\u00e1n b\u1eb1ng c\u00e1ch nh\u1eadp kh\u1ea9u v\u00e0o ph\u1ea7n m\u1ec1m \u0111\u1ec3 ti\u1ebft ki\u1ec7m th\u1eddi gian l\u00e0m vi\u1ec7c.<\/p>\n<h2 id=\"2-chi-tiet-thay-doi\">2. Chi ti\u1ebft thay \u0111\u1ed5i<\/h2>\n<p>H\u00e0ng th\u00e1ng, \u0111\u01a1n v\u1ecb ph\u00e1t sinh c\u00e1c ch\u1ee9ng t\u1eeb gi\u1ed1ng nhau v\u1ec1 n\u1ed9i dung thanh to\u00e1n nh\u01b0: Thanh to\u00e1n ti\u1ec1n \u0111i\u1ec7n\/n\u01b0\u1edbc\/vi\u1ec5n th\u00f4ng, ti\u1ec1n l\u01b0\u01a1ng, n\u1ed9p b\u1ea3o hi\u1ec3m&#8230;\u00a0<\/p>\n<p>Th\u00f4ng th\u01b0\u1eddng, khi sang n\u0103m m\u1edbi, \u0111\u01a1n v\u1ecb s\u1ebd chuy\u1ec3n n\u0103m h\u1ea1ch to\u00e1n v\u00e0 nh\u00e2n b\u1ea3n c\u00e1c ch\u1ee9ng t\u1eeb sang n\u0103m sau. Tuy nhi\u00ean, sang n\u0103m 2025, khi s\u1eed d\u1ee5ng ph\u1ea7n m\u1ec1m theo ch\u1ebf \u0111\u1ed9 k\u1ebf to\u00e1n m\u1edbi, d\u1eef li\u1ec7u c\u1ee7a 2 ch\u1ebf \u0111\u1ed9 k\u1ebf to\u00e1n \u0111\u1ed9c l\u1eadp v\u1edbi nhau, do \u0111\u00f3 kh\u00f4ng th\u1ec3 nh\u00e2n b\u1ea3n ch\u1ee9ng t\u1eeb n\u0103m tr\u01b0\u1edbc.<\/p>\n<p><strong>K\u1ec3 t\u1eeb phi\u00ean b\u1ea3n R2<\/strong>, ph\u1ea7n m\u1ec1m MISA Mimosa 2025 cho ph\u00e9p nh\u1eadp kh\u1ea9u th\u00eam lo\u1ea1i ch\u1ee9ng t\u1eeb: R\u00fat d\u1ef1 to\u00e1n ti\u1ec1n g\u1eedi, R\u00fat d\u1ef1 to\u00e1n chuy\u1ec3n kho\u1ea3n, R\u00fat d\u1ef1 to\u00e1n chuy\u1ec3n kho\u1ea3n l\u01b0\u01a1ng, b\u1ea3o hi\u1ec3m, gi\u00fap k\u1ebf to\u00e1n th\u00eam nhanh gi\u1ea5y r\u00fat d\u1ef1 to\u00e1n l\u00ean ph\u1ea7n m\u1ec1m.<\/p>\n<p><strong>C\u1ee5 th\u1ec3 nh\u01b0 sau:<\/strong><\/p>\n<p>1. V\u00e0o <strong>T\u1ec7p<\/strong>, ch\u1ecdn <strong>Nh\u1eadp kh\u1ea9u d\u1eef li\u1ec7u t\u1eeb Excel.<\/strong><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-33293 size-full\" src=\"\/2025\/wp-content\/uploads\/2025\/01\/1-8.png\" alt=\"\" width=\"683\" height=\"503\" srcset=\"\/2025\/wp-content\/uploads\/2025\/01\/1-8.png 683w, \/2025\/wp-content\/uploads\/2025\/01\/1-8-300x221.png 300w, \/2025\/wp-content\/uploads\/2025\/01\/1-8-50x37.png 50w, \/2025\/wp-content\/uploads\/2025\/01\/1-8-60x44.png 60w, \/2025\/wp-content\/uploads\/2025\/01\/1-8-100x74.png 100w\" sizes=\"auto, (max-width: 683px) 100vw, 683px\" \/><\/p>\n<p>2. Th\u1ef1c hi\u1ec7n nh\u1eadp kh\u1ea9u d\u1eef li\u1ec7u:<\/p>\n<h4><strong>B\u01b0\u1edbc 1: Ch\u1ecdn t\u1ec7p ngu\u1ed3n<\/strong><\/h4>\n<ul>\n<li>T\u00edch ch\u1ecdn <strong>Lo\u1ea1i d\u1eef li\u1ec7u<\/strong> l\u00e0 <strong>Ch\u1ee9ng t\u1eeb<\/strong>.<\/li>\n<li>Ch\u1ecdn lo\u1ea1i ch\u1ee9ng t\u1eeb nh\u1eadp kh\u1ea9u l\u00e0 <strong>R\u00fat d\u1ef1 to\u00e1n ti\u1ec1n g\u1eedi, R\u00fat d\u1ef1 to\u00e1n chuy\u1ec3n kho\u1ea3n<\/strong> ho\u1eb7c <strong>R\u00fat d\u1ef1 to\u00e1n chuy\u1ec3n kho\u1ea3n l\u01b0\u01a1ng, b\u1ea3o hi\u1ec3m.<\/strong><\/li>\n<li>Nh\u1ea5n <strong>T\u1ea3i t\u1ec7p m\u1eabu ng\u1ea7m \u0111\u1ecbnh<\/strong> \u0111\u1ec3 t\u1ea3i m\u1eabu nh\u1eadp li\u1ec7u.<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-33297 size-full\" src=\"\/2025\/wp-content\/uploads\/2025\/01\/2-8.png\" alt=\"\" width=\"841\" height=\"602\" srcset=\"\/2025\/wp-content\/uploads\/2025\/01\/2-8.png 841w, \/2025\/wp-content\/uploads\/2025\/01\/2-8-300x215.png 300w, \/2025\/wp-content\/uploads\/2025\/01\/2-8-768x550.png 768w, \/2025\/wp-content\/uploads\/2025\/01\/2-8-50x36.png 50w, \/2025\/wp-content\/uploads\/2025\/01\/2-8-60x43.png 60w, \/2025\/wp-content\/uploads\/2025\/01\/2-8-100x72.png 100w\" sizes=\"auto, (max-width: 841px) 100vw, 841px\" \/><\/p>\n<ul>\n<li>Sau khi nh\u1eadp v\u00e0 l\u01b0u th\u00f4ng tin gi\u1ea5y r\u00fat d\u1ef1 to\u00e1n v\u00e0o t\u1ec7p m\u1eabu \u0111\u00e3 t\u1ea3i v\u1ec1, ch\u1ecdn v\u00e0o bi\u1ec3u t\u01b0\u1ee3ng th\u01b0 m\u1ee5c t\u1ea1i <strong>\u0110\u01b0\u1eddng d\u1eabn \u0111\u1ebfn t\u1ec7p d\u1eef li\u1ec7u<\/strong> \u0111\u1ec3 t\u1ea3i t\u1ec7p l\u00ean ph\u1ea7n m\u1ec1m.<\/li>\n<li><strong>Ch\u1ecdn sheet ch\u1ee9a d\u1eef li\u1ec7u<\/strong> c\u1ea7n nh\u1eadp kh\u1ea9u.<\/li>\n<li>Nh\u1ea5n <strong>Ti\u1ebfp t\u1ee5c<\/strong> \u0111\u1ec3 chuy\u1ec3n sang b\u01b0\u1edbc 2.<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-33299 size-full\" src=\"\/2025\/wp-content\/uploads\/2025\/01\/3-7.png\" alt=\"\" width=\"1023\" height=\"601\" srcset=\"\/2025\/wp-content\/uploads\/2025\/01\/3-7.png 1023w, \/2025\/wp-content\/uploads\/2025\/01\/3-7-300x176.png 300w, \/2025\/wp-content\/uploads\/2025\/01\/3-7-768x451.png 768w, \/2025\/wp-content\/uploads\/2025\/01\/3-7-50x29.png 50w, \/2025\/wp-content\/uploads\/2025\/01\/3-7-60x35.png 60w, \/2025\/wp-content\/uploads\/2025\/01\/3-7-100x59.png 100w\" sizes=\"auto, (max-width: 1023px) 100vw, 1023px\" \/><\/p>\n<h4><strong>B\u01b0\u1edbc 2: Gh\u00e9p c\u1ed9t d\u1eef li\u1ec7u<\/strong><\/h4>\n<p><em><strong>L\u01b0u \u00fd<\/strong>: N\u1ebfu anh\/ch\u1ecb s\u1eed d\u1ee5ng file m\u1eabu ng\u1ea7m \u0111\u1ecbnh c\u1ee7a ph\u1ea7n m\u1ec1m \u0111\u1ec3 nh\u1eadp kh\u1ea9u v\u00e0o ph\u1ea7n m\u1ec1m th\u00ec t\u1ea1i b\u01b0\u1edbc n\u00e0y kh\u00f4ng c\u1ea7n ph\u1ea3i th\u1ef1c hi\u1ec7n gh\u00e9p c\u1ed9t d\u1eef li\u1ec7u.<\/em><\/p>\n<ul>\n<li>Th\u1ef1c hi\u1ec7n gh\u00e9p\u00a0<strong>Th\u00f4ng tin d\u1eef li\u1ec7u ph\u1ea7n m\u1ec1m<\/strong>\u00a0(t\u00ean c\u00e1c c\u1ed9t d\u1eef li\u1ec7u tr\u00ean ph\u1ea7n m\u1ec1m) v\u1edbi\u00a0<strong>Th\u00f4ng tin trong t\u1ec7p excel<\/strong>\u00a0(t\u00ean c\u00e1c c\u1ed9t tr\u00ean file excel c\u1ea7n nh\u1eadp kh\u1ea9u).\u00a0<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-33303 size-full\" src=\"\/2025\/wp-content\/uploads\/2025\/01\/4-6.png\" alt=\"\" width=\"838\" height=\"601\" srcset=\"\/2025\/wp-content\/uploads\/2025\/01\/4-6.png 838w, \/2025\/wp-content\/uploads\/2025\/01\/4-6-300x215.png 300w, \/2025\/wp-content\/uploads\/2025\/01\/4-6-768x551.png 768w, \/2025\/wp-content\/uploads\/2025\/01\/4-6-50x36.png 50w, \/2025\/wp-content\/uploads\/2025\/01\/4-6-60x43.png 60w, \/2025\/wp-content\/uploads\/2025\/01\/4-6-100x72.png 100w\" sizes=\"auto, (max-width: 838px) 100vw, 838px\" \/><\/p>\n<ul>\n<li>Nh\u1ea5n\u00a0<strong>Ti\u1ebfp t\u1ee5c<\/strong>\u00a0\u0111\u1ec3 chuy\u1ec3n sang b\u01b0\u1edbc 3.<\/li>\n<\/ul>\n<h4><strong>B\u01b0\u1edbc 3: Ki\u1ec3m tra d\u1eef li\u1ec7u<\/strong><\/h4>\n<p>\u2013 Ki\u1ec3m tra l\u1ea1i c\u00e1c d\u1eef li\u1ec7u c\u1ea7n nh\u1eadp kh\u1ea9u.<\/p>\n<ul>\n<li>N\u1ebfu t\u1ea1i b\u01b0\u1edbc n\u00e0y ph\u00e1t hi\u1ec7n d\u1eef li\u1ec7u b\u1ecb l\u1ed7i, c\u00f3 th\u1ec3 nh\u1ea5n<strong>\u00a0S\u1eeda t\u1ec7p d\u1eef li\u1ec7u<\/strong>\u00a0\u0111\u1ec3 ch\u1ec9nh s\u1eeda d\u1eef li\u1ec7u ngay tr\u00ean file excel.<\/li>\n<li>Sau khi s\u1eeda xong d\u1eef li\u1ec7u,\u00a0<strong>Save<\/strong>\u00a0v\u00e0\u00a0<strong>\u0110\u00f3ng<\/strong>\u00a0file excel.<\/li>\n<li>Ch\u1ecdn\u00a0<strong>Ki\u1ec3m tra l\u1ea1i d\u1eef li\u1ec7u<\/strong>\u00a0\u0111\u1ec3 ph\u1ea7n m\u1ec1m ki\u1ec3m tra l\u1ea1i d\u1eef li\u1ec7u nh\u1eadp kh\u1ea9u sau khi \u0111\u00e3 \u0111\u01b0\u1ee3c ch\u1ec9nh s\u1eeda.<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-33305 size-full\" src=\"\/2025\/wp-content\/uploads\/2025\/01\/5-5.png\" alt=\"\" width=\"840\" height=\"601\" srcset=\"\/2025\/wp-content\/uploads\/2025\/01\/5-5.png 840w, \/2025\/wp-content\/uploads\/2025\/01\/5-5-300x215.png 300w, \/2025\/wp-content\/uploads\/2025\/01\/5-5-768x549.png 768w, \/2025\/wp-content\/uploads\/2025\/01\/5-5-50x36.png 50w, \/2025\/wp-content\/uploads\/2025\/01\/5-5-60x43.png 60w, \/2025\/wp-content\/uploads\/2025\/01\/5-5-100x72.png 100w\" sizes=\"auto, (max-width: 840px) 100vw, 840px\" \/><\/p>\n<p>&#8211; Nh\u1ea5n <strong>Nh\u1eadp kh\u1ea9u.<\/strong><\/p>\n<p>&#8211; Ph\u1ea7n m\u1ec1m hi\u1ec3n th\u1ecb th\u00f4ng b\u00e1o. Nh\u1ea5n <strong>\u0110\u1ed3ng \u00fd<\/strong> \u0111\u1ec3\u00a0ch\u01b0\u01a1ng tr\u00ecnh th\u1ef1c hi\u1ec7n nh\u1eadp kh\u1ea9u d\u1eef li\u1ec7u.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-33307 size-full\" src=\"\/2025\/wp-content\/uploads\/2025\/01\/6-4.png\" alt=\"\" width=\"406\" height=\"158\" srcset=\"\/2025\/wp-content\/uploads\/2025\/01\/6-4.png 406w, \/2025\/wp-content\/uploads\/2025\/01\/6-4-300x117.png 300w, \/2025\/wp-content\/uploads\/2025\/01\/6-4-50x19.png 50w, \/2025\/wp-content\/uploads\/2025\/01\/6-4-60x23.png 60w, \/2025\/wp-content\/uploads\/2025\/01\/6-4-100x39.png 100w\" sizes=\"auto, (max-width: 406px) 100vw, 406px\" \/><\/p>\n<h4><strong>\u00a0B\u01b0\u1edbc 4: Nh\u1eadp kh\u1ea9u<\/strong><\/h4>\n<ul>\n<li>Ph\u1ea7n m\u1ec1m th\u00f4ng b\u00e1o k\u1ebft qu\u1ea3 nh\u1eadp kh\u1ea9u: S\u1ed1 b\u1ea3n ghi nh\u1eadp kh\u1ea9u th\u00e0nh c\u00f4ng, s\u1ed1 b\u1ea3n ghi nh\u1eadp kh\u1ea9u kh\u00f4ng th\u00e0nh c\u00f4ng.<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-33311 size-full\" src=\"\/2025\/wp-content\/uploads\/2025\/01\/7-3.png\" alt=\"\" width=\"840\" height=\"601\" srcset=\"\/2025\/wp-content\/uploads\/2025\/01\/7-3.png 840w, \/2025\/wp-content\/uploads\/2025\/01\/7-3-300x215.png 300w, \/2025\/wp-content\/uploads\/2025\/01\/7-3-768x549.png 768w, \/2025\/wp-content\/uploads\/2025\/01\/7-3-50x36.png 50w, \/2025\/wp-content\/uploads\/2025\/01\/7-3-60x43.png 60w, \/2025\/wp-content\/uploads\/2025\/01\/7-3-100x72.png 100w\" sizes=\"auto, (max-width: 840px) 100vw, 840px\" \/><\/p>\n<ul>\n<li>Nh\u1ea5n\u00a0<strong>\u0110\u00f3ng<\/strong>\u00a0\u0111\u1ec3 k\u1ebft th\u00fac vi\u1ec7c nh\u1eadp kh\u1ea9u d\u1eef li\u1ec7u t\u1eeb excel.<\/li>\n<li>Anh\/ch\u1ecb xem chi ti\u1ebft d\u1eef li\u1ec7u \u0111\u00e3 nh\u1eadp t\u1ea1i danh s\u00e1ch gi\u1ea5y r\u00fat d\u1ef1 to\u00e1n t\u01b0\u01a1ng \u1ee9ng.<\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>1. M\u1ee5c \u0111\u00edch K\u1ebf to\u00e1n c\u00f3 th\u1ec3 th\u00eam nhanh h\u00e0ng lo\u1ea1t gi\u1ea5y r\u00fat d\u1ef1 to\u00e1n b\u1eb1ng c\u00e1ch nh\u1eadp kh\u1ea9u v\u00e0o ph\u1ea7n m\u1ec1m \u0111\u1ec3 ti\u1ebft ki\u1ec7m th\u1eddi gian l\u00e0m vi\u1ec7c. 2. Chi ti\u1ebft thay \u0111\u1ed5i H\u00e0ng th\u00e1ng, \u0111\u01a1n v\u1ecb ph\u00e1t sinh c\u00e1c ch\u1ee9ng t\u1eeb gi\u1ed1ng nhau v\u1ec1 n\u1ed9i dung thanh to\u00e1n&#8230;<\/p>\n","protected":false},"author":23,"template":"","format":"standard","meta":{"ub_ctt_via":"","footnotes":""},"ht-kb-category":[965],"ht-kb-tag":[],"class_list":["post-33289","ht_kb","type-ht_kb","status-publish","format-standard","hentry","ht_kb_category-r2"],"_links":{"self":[{"href":"https:\/\/helpmimosa.misa.vn\/2025\/wp-json\/wp\/v2\/ht-kb\/33289","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/helpmimosa.misa.vn\/2025\/wp-json\/wp\/v2\/ht-kb"}],"about":[{"href":"https:\/\/helpmimosa.misa.vn\/2025\/wp-json\/wp\/v2\/types\/ht_kb"}],"author":[{"embeddable":true,"href":"https:\/\/helpmimosa.misa.vn\/2025\/wp-json\/wp\/v2\/users\/23"}],"version-history":[{"count":1,"href":"https:\/\/helpmimosa.misa.vn\/2025\/wp-json\/wp\/v2\/ht-kb\/33289\/revisions"}],"predecessor-version":[{"id":33315,"href":"https:\/\/helpmimosa.misa.vn\/2025\/wp-json\/wp\/v2\/ht-kb\/33289\/revisions\/33315"}],"wp:attachment":[{"href":"https:\/\/helpmimosa.misa.vn\/2025\/wp-json\/wp\/v2\/media?parent=33289"}],"wp:term":[{"taxonomy":"ht_kb_category","embeddable":true,"href":"https:\/\/helpmimosa.misa.vn\/2025\/wp-json\/wp\/v2\/ht-kb-category?post=33289"},{"taxonomy":"ht_kb_tag","embeddable":true,"href":"https:\/\/helpmimosa.misa.vn\/2025\/wp-json\/wp\/v2\/ht-kb-tag?post=33289"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}