{"id":2749,"date":"2018-12-25T18:04:26","date_gmt":"2018-12-25T11:04:26","guid":{"rendered":"http:\/\/help.sme2019.misa.local\/?post_type=ht_kb&#038;p=2749"},"modified":"2025-11-06T09:17:26","modified_gmt":"2025-11-06T02:17:26","slug":"xuat_khau_ra_excel","status":"publish","type":"ht_kb","link":"https:\/\/helpsme.misa.vn\/2023\/kb\/xuat_khau_ra_excel\/","title":{"rendered":"L\u00e0m th\u1ebf n\u00e0o \u0111\u1ec3 xu\u1ea5t kh\u1ea9u c\u00e1c Danh m\u1ee5c, Ch\u1ee9ng t\u1eeb ra file 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 style=\"text-align: justify;\"><strong>M\u1ee5c \u0111\u00edch:<\/strong> B\u00e0i vi\u1ebft h\u01b0\u1edbng d\u1eabn c\u00e1ch xu\u1ea5t kh\u1ea9u danh m\u1ee5c v\u00e0 ch\u1ee9ng t\u1eeb k\u1ebf to\u00e1n ra file Excel, gi\u00fap doanh nghi\u1ec7p l\u01b0u tr\u1eef, ph\u00e2n t\u00edch ho\u1eb7c chia s\u1ebb d\u1eef li\u1ec7u m\u1ed9t c\u00e1ch linh ho\u1ea1t, ph\u1ee5c v\u1ee5 cho c\u00e1c nhu c\u1ea7u qu\u1ea3n l\u00fd v\u00e0 b\u00e1o c\u00e1o ngo\u00e0i ph\u1ea7n m\u1ec1m.<\/p>\n<p style=\"text-align: justify;\"><strong>N\u1ed9i dung b\u00e0i vi\u1ebft g\u1ed3m:<\/strong><\/p>\n<ul style=\"text-align: justify;\">\n<li>H\u01b0\u1edbng d\u1eabn xu\u1ea5t kh\u1ea9u danh m\u1ee5c v\u00e0 ch\u1ee9ng t\u1eeb ra Excel v\u1edbi nhi\u1ec1u l\u1ef1a ch\u1ecdn chi ti\u1ebft<\/li>\n<li>L\u01b0u \u00fd v\u1ec1 \u0111i\u1ec1u ki\u1ec7n l\u1ecdc, l\u1ef1a ch\u1ecdn d\u1eef li\u1ec7u v\u00e0 c\u00e1ch xu\u1ea5t kh\u1ea9u ph\u00f9 h\u1ee3p v\u1edbi nhu c\u1ea7u<\/li>\n<li>H\u1ed7 tr\u1ee3 xu\u1ea5t kh\u1ea9u d\u1eef li\u1ec7u ph\u1ee5c v\u1ee5 ki\u1ec3m tra, \u0111\u1ed1i chi\u1ebfu ho\u1eb7c b\u00e1o c\u00e1o ngo\u00e0i h\u1ec7 th\u1ed1ng<\/li>\n<\/ul>\n<p style=\"text-align: justify;\"><strong>Ph\u1ea1m vi \u00e1p d\u1ee5ng:<\/strong>\u00a0K\u1ebf to\u00e1n, doanh nghi\u1ec7p s\u1eed d\u1ee5ng ph\u1ea7n m\u1ec1m k\u1ebf to\u00e1n c\u00f3 nhu c\u1ea7u xu\u1ea5t kh\u1ea9u d\u1eef li\u1ec7u<\/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><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<table style=\"border-collapse: collapse; width: 100%;\">\n<tbody>\n<tr>\n<td style=\"width: 100%;\"><\/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<h4><strong>2.1. Xu\u1ea5t kh\u1ea9u DANH M\u1ee4C ra excel<\/strong><\/h4>\n<p><\/div><div class=\"su-spoiler-content su-u-clearfix su-u-trim\">\n<p>\u0110\u00ea\u0309 xu\u00e2\u0301t kh\u00e2\u0309u danh m\u1ee5c ra t\u00ea\u0323p excel, th\u01b0\u0323c hi\u00ea\u0323n nh\u01b0 sau:<\/p>\n<p><strong>B\u01b0\u1edbc 1:<\/strong> Tr\u00ean giao di\u1ec7n danh m\u1ee5c, cho\u0323n ch\u1ee9c n\u0103ng <strong>Xu\u1ea5t kh\u1ea9u\u00a0<\/strong>tr\u00ean thanh c\u00f4ng c\u1ee5<\/p>\n<p><strong>B\u01b0\u1edbc 2: <\/strong>Tr\u00ean m\u00e0n h\u00ecnh h\u1ed9p tho\u1ea1i <strong>L\u01b0u t\u1ec7p<\/strong>, ch\u1ecdn \u0111\u01b0\u1eddng d\u1eabn l\u01b0u file d\u1eef li\u1ec7u xu\u1ea5t kh\u1ea9u t\u1eeb ch\u01b0\u01a1ng tr\u00ecnh ra m\u00e1y t\u00ednh<\/p>\n<p><strong>B\u01b0\u1edbc 3: <\/strong>Nh\u1ea5n <strong>Save<\/strong>.<\/p>\n<p style=\"padding-left: 40px;\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-26987\" src=\"\/2022\/wp-content\/uploads\/2018\/12\/xk_1.png\" alt=\"\" width=\"1156\" height=\"675\" srcset=\"\/2023\/wp-content\/uploads\/2018\/12\/xk_1.png 1156w, \/2023\/wp-content\/uploads\/2018\/12\/xk_1-700x409.png 700w, \/2023\/wp-content\/uploads\/2018\/12\/xk_1-800x467.png 800w, \/2023\/wp-content\/uploads\/2018\/12\/xk_1-768x448.png 768w, \/2023\/wp-content\/uploads\/2018\/12\/xk_1-50x29.png 50w, \/2023\/wp-content\/uploads\/2018\/12\/xk_1-60x35.png 60w, \/2023\/wp-content\/uploads\/2018\/12\/xk_1-100x58.png 100w\" sizes=\"auto, (max-width: 1156px) 100vw, 1156px\" \/><\/p>\n<p>Tham kh\u1ea3o th\u00eam h\u01b0\u1edbng d\u1eabn Xu\u1ea5t kh\u1ea9u danh m\u1ee5c V\u1eadt t\u01b0 h\u00e0ng h\u00f3a. <strong><a href=\"https:\/\/helpsme.misa.vn\/2023\/kb\/xuat-khau-hang-hoa\/\" target=\"_blank\" rel=\"noopener noreferrer\">T\u1ea1i \u0111\u00e2y<\/a><\/strong><\/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<h4><strong>2.2. Xu\u1ea5t kh\u1ea9u CH\u1ee8NG T\u1eea ra excel<\/strong><\/h4>\n<p><\/div><div class=\"su-spoiler-content su-u-clearfix su-u-trim\">\n<p>\u0110\u00ea\u0309 xu\u00e2\u0301t kh\u00e2\u0309u ch\u1ee9ng t\u1eeb ra t\u00ea\u0323p excel, th\u01b0\u0323c hi\u00ea\u0323n <span style=\"color: #ff0000;\">theo 2 tr\u01b0\u1eddng h\u1ee3p <\/span>nh\u01b0 sau:<\/p>\n<p><strong>V\u00ed d\u1ee5:<\/strong> Danh s\u00e1ch Ch\u1ee9ng t\u1eeb b\u00e1n h\u00e0ng<\/p>\n<table style=\"border-collapse: collapse; width: 100%;\">\n<tbody>\n<tr>\n<td style=\"width: 100%;\"><\/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><strong>Tr\u01b0\u1eddng h\u1ee3p 1: Ch\u1ec9 mu\u1ed1n xu\u1ea5t kh\u1ea9u ra Danh s\u00e1ch ch\u1ee9ng t\u1eeb (kh\u00f4ng c\u00f3 chi ti\u1ebft b\u00ean trong)<\/strong><\/p>\n<p><\/div><div class=\"su-spoiler-content su-u-clearfix su-u-trim\">\n<p><strong>B\u01b0\u1edbc 1:<\/strong> Tr\u00ean danh s\u00e1ch ch\u1ee9ng t\u1eeb, thi\u1ebft l\u1eadp \u0111i\u1ec1u ki\u1ec7n c\u1ea7n xu\u1ea5t kh\u1ea9u.<\/p>\n<p><strong>B\u01b0\u1edbc 2: <\/strong>Cho\u0323n ch\u1ee9c n\u0103ng <strong>Xu\u1ea5t kh\u1ea9u<\/strong>\u00a0tr\u00ean thanh c\u00f4ng c\u1ee5<\/p>\n<p style=\"padding-left: 40px;\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-26991\" src=\"\/2022\/wp-content\/uploads\/2018\/12\/xk_3.png\" alt=\"\" width=\"1158\" height=\"617\" srcset=\"\/2023\/wp-content\/uploads\/2018\/12\/xk_3.png 1158w, \/2023\/wp-content\/uploads\/2018\/12\/xk_3-700x373.png 700w, \/2023\/wp-content\/uploads\/2018\/12\/xk_3-800x426.png 800w, \/2023\/wp-content\/uploads\/2018\/12\/xk_3-768x409.png 768w, \/2023\/wp-content\/uploads\/2018\/12\/xk_3-50x27.png 50w, \/2023\/wp-content\/uploads\/2018\/12\/xk_3-60x32.png 60w, \/2023\/wp-content\/uploads\/2018\/12\/xk_3-100x53.png 100w\" sizes=\"auto, (max-width: 1158px) 100vw, 1158px\" \/><\/p>\n<p><strong>B\u01b0\u1edbc 3: <\/strong>Tr\u00ean m\u00e0n h\u00ecnh h\u1ed9p tho\u1ea1i L\u01b0u t\u1ec7p, ch\u1ecdn \u0111\u01b0\u1eddng d\u1eabn l\u01b0u file d\u1eef li\u1ec7u xu\u1ea5t kh\u1ea9u t\u1eeb ch\u01b0\u01a1ng tr\u00ecnh ra m\u00e1y t\u00ednh<\/p>\n<p><strong>B\u01b0\u1edbc 4: <\/strong>Nh\u1ea5n <strong>Save<\/strong>.<\/p>\n<p style=\"padding-left: 40px;\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-26992\" src=\"\/2022\/wp-content\/uploads\/2018\/12\/xk_2-1.png\" alt=\"\" width=\"612\" height=\"421\" srcset=\"\/2023\/wp-content\/uploads\/2018\/12\/xk_2-1.png 612w, \/2023\/wp-content\/uploads\/2018\/12\/xk_2-1-50x34.png 50w, \/2023\/wp-content\/uploads\/2018\/12\/xk_2-1-60x41.png 60w, \/2023\/wp-content\/uploads\/2018\/12\/xk_2-1-100x69.png 100w\" sizes=\"auto, (max-width: 612px) 100vw, 612px\" \/><\/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<p><strong>Tr\u01b0\u1eddng h\u1ee3p 2: Mu\u1ed1n xu\u1ea5t kh\u1ea9u ra danh s\u00e1ch ch\u1ee9ng t\u1eeb (c\u00f3 chi ti\u1ebft b\u00ean trong)<\/strong><\/p>\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 ph\u1ea7n m\u1ec1m, nh\u1ea5n n\u00fat <strong>T\u00ecm ch\u1ee9ng t\u1eeb<\/strong><\/p>\n<p><strong>B\u01b0\u1edbc 2: <\/strong>Ch\u1ecdn \u0111i\u1ec1u ki\u1ec7n t\u00ecm ki\u1ebfm (v\u00ed d\u1ee5 Ng\u00e0y h\u1ea1ch to\u00e1n, t\u1eeb ng\u00e0y \u0111\u1ebfn ng\u00e0y, Lo\u1ea1i ch\u1ee9ng t\u1eeb&#8230;.).<\/p>\n<p><strong>B\u01b0\u1edbc 3: <\/strong>Nh\u1ea5n n\u00fat <strong>C\u1eadp nh\u1eadt<\/strong> \u0111\u1ec3 \u0111i\u1ec1u ki\u1ec7n t\u00ecm ki\u1ebfm \u0111\u01b0\u1ee3c ghi nh\u1eadn sang khung b\u00ean ph\u1ea3i<\/p>\n<ul>\n<li>L\u01b0u \u00fd: N\u1ebfu t\u00ecm theo 2 \u0111i\u1ec1u ki\u1ec7n tr\u1edf l\u00ean th\u00ec l\u00e0m nh\u01b0 sau:\n<ul style=\"list-style-type: square;\">\n<li>Ch\u1ecdn \u0111i\u1ec1u ki\u1ec7n t\u00ecm ki\u1ebfm theo <strong>Ng\u00e0y hach to\u00e1n<\/strong> v\u00e0 g\u00f5 th\u1eddi gian c\u1ea7n t\u00ecm \/ nh\u1ea5n <strong>C\u1eadp nh\u1eadt<\/strong><\/li>\n<li>Ch\u1ecdn ti\u1ebfp \u0111i\u1ec1u ki\u1ec7n t\u00ecm ki\u1ebfm theo <strong>Lo\u1ea1i ch\u1ee9ng t\u1eeb<\/strong> \/ ch\u1ecdn lo\u1ea1i <strong>B\u00e1n h\u00e0ng<\/strong> \/ sau \u0111\u00f3 nh\u1ea5n <strong>Th\u00eam<\/strong><\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-39587 size-medium\" src=\"\/2023\/wp-content\/uploads\/2018\/12\/D2-700x173.jpg\" alt=\"\" width=\"700\" height=\"173\" srcset=\"\/2023\/wp-content\/uploads\/2018\/12\/D2-700x173.jpg 700w, \/2023\/wp-content\/uploads\/2018\/12\/D2-800x198.jpg 800w, \/2023\/wp-content\/uploads\/2018\/12\/D2-768x190.jpg 768w, \/2023\/wp-content\/uploads\/2018\/12\/D2-50x12.jpg 50w, \/2023\/wp-content\/uploads\/2018\/12\/D2-60x15.jpg 60w, \/2023\/wp-content\/uploads\/2018\/12\/D2-100x25.jpg 100w, \/2023\/wp-content\/uploads\/2018\/12\/D2.jpg 838w\" sizes=\"auto, (max-width: 700px) 100vw, 700px\" \/><\/p>\n<p><strong>B\u01b0\u1edbc 4: <\/strong>Ch\u1ecdn m\u1ee5c <strong>Ch\u1ee9ng t\u1eeb \u0111\u00e3 ghi s\u1ed5<\/strong><\/p>\n<p><strong>B\u01b0\u1edbc 5: <\/strong>Nh\u1ea5n <strong>T\u00ecm ki\u1ebfm<\/strong><\/p>\n<p><strong>B\u01b0\u1edbc 6: <\/strong>Sau khi d\u1eef li\u1ec7u \u0111\u01b0\u1ee3c l\u1ecdc ra th\u00ec ki\u1ec3m tra l\u1ea1i v\u00e0 nh\u1ea5n n\u00fat <strong>Xu\u1ea5t kh\u1ea9u excel<\/strong><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-39589 size-large\" src=\"\/2023\/wp-content\/uploads\/2018\/12\/D1-800x533.jpg\" alt=\"\" width=\"800\" height=\"533\" srcset=\"\/2023\/wp-content\/uploads\/2018\/12\/D1-800x533.jpg 800w, \/2023\/wp-content\/uploads\/2018\/12\/D1-700x467.jpg 700w, \/2023\/wp-content\/uploads\/2018\/12\/D1-768x512.jpg 768w, \/2023\/wp-content\/uploads\/2018\/12\/D1-50x33.jpg 50w, \/2023\/wp-content\/uploads\/2018\/12\/D1-60x40.jpg 60w, \/2023\/wp-content\/uploads\/2018\/12\/D1-100x67.jpg 100w, \/2023\/wp-content\/uploads\/2018\/12\/D1.jpg 1137w\" sizes=\"auto, (max-width: 800px) 100vw, 800px\" \/><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p>&nbsp;<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div><\/div>\n<\/div>\n","protected":false},"excerpt":{"rendered":"","protected":false},"author":120,"comment_status":"closed","ping_status":"closed","template":"","format":"standard","meta":{"_links_to":"","_links_to_target":"","footnotes":""},"ht-kb-category":[2618,2622,2568],"ht-kb-tag":[4309,4575],"class_list":["post-2749","ht_kb","type-ht_kb","status-publish","format-standard","hentry","ht_kb_category-cau-hoi-thuong-gap-khi-bat-dau-su-dung","ht_kb_category-khac-cau-hoi-thuong-gap-khi-bat-dau-su-dung","ht_kb_category-cau-hoi-thuong-gap","ht_kb_tag-excel","ht_kb_tag-xuat-khau-du-lieu"],"_links":{"self":[{"href":"https:\/\/helpsme.misa.vn\/2023\/wp-json\/wp\/v2\/ht-kb\/2749","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/helpsme.misa.vn\/2023\/wp-json\/wp\/v2\/ht-kb"}],"about":[{"href":"https:\/\/helpsme.misa.vn\/2023\/wp-json\/wp\/v2\/types\/ht_kb"}],"author":[{"embeddable":true,"href":"https:\/\/helpsme.misa.vn\/2023\/wp-json\/wp\/v2\/users\/120"}],"replies":[{"embeddable":true,"href":"https:\/\/helpsme.misa.vn\/2023\/wp-json\/wp\/v2\/comments?post=2749"}],"version-history":[{"count":6,"href":"https:\/\/helpsme.misa.vn\/2023\/wp-json\/wp\/v2\/ht-kb\/2749\/revisions"}],"predecessor-version":[{"id":54045,"href":"https:\/\/helpsme.misa.vn\/2023\/wp-json\/wp\/v2\/ht-kb\/2749\/revisions\/54045"}],"wp:attachment":[{"href":"https:\/\/helpsme.misa.vn\/2023\/wp-json\/wp\/v2\/media?parent=2749"}],"wp:term":[{"taxonomy":"ht_kb_category","embeddable":true,"href":"https:\/\/helpsme.misa.vn\/2023\/wp-json\/wp\/v2\/ht-kb-category?post=2749"},{"taxonomy":"ht_kb_tag","embeddable":true,"href":"https:\/\/helpsme.misa.vn\/2023\/wp-json\/wp\/v2\/ht-kb-tag?post=2749"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}