{"id":10930,"date":"2020-10-13T15:10:34","date_gmt":"2020-10-13T08:10:34","guid":{"rendered":"http:\/\/helpact.amis.vn\/?post_type=ht_kb&#038;p=10930"},"modified":"2020-10-13T15:10:34","modified_gmt":"2020-10-13T08:10:34","slug":"cai-tien-nhap-tu-excel-truong-mo-rong","status":"publish","type":"ht_kb","link":"http:\/\/helpasp.misa.vn\/accounting\/kb\/cai-tien-nhap-tu-excel-truong-mo-rong\/","title":{"rendered":"C\u1ea3i ti\u1ebfn nh\u1eadp t\u1eeb Excel tr\u01b0\u1eddng m\u1edf r\u1ed9ng"},"content":{"rendered":"<p><strong>1. M\u1ee5c \u0111\u00edch:<\/strong><\/p>\n<p>Cho ph\u00e9p nh\u1eadp t\u1eeb Excel tr\u01b0\u1eddng m\u1edf r\u1ed9ng v\u1edbi c\u00e1c ki\u1ec3u d\u1eef li\u1ec7u ngo\u00e0i d\u1ea1ng Text \u0111\u1ec3 ph\u1ee5c v\u1ee5 nhu c\u1ea7u qu\u1ea3n l\u00fd kh\u00e1c nhau c\u1ee7a ng\u01b0\u1eddi d\u00f9ng.<\/p>\n<p><strong>2.Chi ti\u1ebft thay \u0111\u1ed5i:<\/strong><\/p>\n<ul>\n<li>L\u1ea5y th\u00f4ng tin ki\u1ec3u d\u1eef li\u1ec7u t\u1eeb <strong>Thi\u1ebft l\u1eadp\\T\u00f9y ch\u1ecdn\\Thi\u1ebft l\u1eadp tr\u01b0\u1eddng m\u1edf r\u1ed9ng<\/strong>:<\/li>\n<li><strong>Ki\u1ec3u s\u1ed1 l\u01b0\u1ee3ng:<\/strong> Ki\u1ec3u ti\u1ec1n quy \u0111\u1ed5i\/Ki\u1ec3u nguy\u00ean t\u1ec7\/Ki\u1ec3u \u0111\u01a1n gi\u00e1 quy \u0111\u1ed5i\/Ki\u1ec3u \u0111\u01a1n gi\u00e1 ngo\u1ea1i t\u1ec7\/Ki\u1ec3u t\u1ef7 gi\u00e1\/Ki\u1ec3u h\u1ec7 s\u1ed1,t\u1ef7 l\u1ec7\/Ki\u1ec3u t\u1ef7 l\u1ec7 ph\u00e2n b\u1ed5.\n<ul>\n<li>Cho ph\u00e9p nh\u1eadp t\u1ed1i \u0111a 14 ch\u1eef s\u1ed1.<\/li>\n<li>Cho ph\u00e9p nh\u1eadp c\u1ea3 s\u1ed1 \u00e2m<\/li>\n<li>\u0110\u1ecbnh d\u1ea1ng s\u1ed1 l\u1ea5y theo <strong>Thi\u1ebft l\u1eadp\\T\u00f9y ch\u1ecdn\\\u0110\u1ecbnh d\u1ea1ng s\u1ed1<\/strong>.<\/li>\n<li>N\u1ebfu ng\u01b0\u1eddi d\u00f9ng nh\u1eadp k\u00fd t\u1ef1 kh\u00e1c s\u1ed1 th\u00ec ch\u01b0\u01a1ng tr\u00ecnh s\u1ebd b\u00e1o l\u1ed7i v\u00e0 kh\u00f4ng cho ph\u00e9p ng\u01b0\u1eddi d\u00f9ng c\u1ea5t ch\u1ee9ng t\u1eeb.<\/li>\n<\/ul>\n<\/li>\n<li><strong>Ki\u1ec3u t\u00edch ch\u1ecdn:<\/strong> Ch\u1ec9 cho ph\u00e9p ng\u01b0\u1eddi d\u00f9ng nh\u1eadp <strong>C\u00f3\/Kh\u00f4ng<\/strong><\/li>\n<li><strong>Ki\u1ec3u danh s\u00e1ch:<\/strong>\n<ul>\n<li>N\u1ebfu \u0111\u00e3 thi\u1ebft l\u1eadp th\u00ec cho ph\u00e9p nh\u1eadp v\u00e0o b\u00ecnh th\u01b0\u1eddng.<\/li>\n<li>N\u1ebfu ch\u01b0a thi\u1ebft l\u1eadp gi\u00e1 tr\u1ecb th\u00ec th\u00eam m\u1edbi \u0111\u1ed3ng th\u1eddi thi\u1ebft l\u1eadp gi\u00e1 tr\u1ecb m\u1edbi v\u00e0o ch\u01b0\u01a1ng tr\u00ecnh.<\/li>\n<\/ul>\n<\/li>\n<li><strong>Ki\u1ec3u ng\u00e0y th\u00e1ng:<\/strong> Nh\u1eadp kh\u1ea9u theo \u0111\u1ecbnh d\u1ea1ng tr\u00ean file excel.<\/li>\n<li><strong>Ki\u1ec3u ch\u1eef:<\/strong> Cho ph\u00e9p nh\u1eadp d\u1ea1ng Text.<\/li>\n<li><strong>Li\u1ec7t k\u00ea:<\/strong> T\u1ea5t c\u1ea3 c\u00e1c m\u00e0n h\u00ecnh cho ph\u00e9p nh\u1eadp kh\u1ea9u tr\u01b0\u1eddng m\u1edf r\u1ed9ng:\n<ul>\n<li>Nh\u1eadp ch\u1ee9ng t\u1eeb ph\u00e2n h\u1ec7 <strong>Qu\u1ef9<\/strong> t\u1eeb Excel: Phi\u1ebfu chi, Phi\u1ebfu thu<\/li>\n<li>Nh\u1eadp ch\u1ee9ng t\u1eeb ph\u00e2n h\u1ec7 <strong>Ng\u00e2n h\u00e0ng<\/strong> t\u1eeb Excel: Chi ti\u1ec1n g\u1eedi, Thu ti\u1ec1n g\u1eedi<\/li>\n<li>Nh\u1eadp ch\u1ee9ng t\u1eeb ph\u00e2n h\u1ec7 <strong>Kho<\/strong> t\u1eeb Excel: Nh\u1eadp kho, Xu\u1ea5t kho, Chuy\u1ec3n kho, L\u1eafp r\u00e1p th\u00e1o d\u1ee1<\/li>\n<li>Nh\u1eadp ch\u1ee9ng t\u1eeb ph\u00e2n h\u1ec7 <strong>Mua h\u00e0ng<\/strong> t\u1eeb Excel: \u0110\u01a1n mua h\u00e0ng, Ch\u1ee9ng t\u1eeb mua h\u00e0ng trong n\u01b0\u1edbc, Mua nh\u1eadp kh\u1ea9u, Mua d\u1ecbch v\u1ee5, Gi\u1ea3m gi\u00e1 h\u00e0ng mua, Tr\u1ea3 l\u1ea1i h\u00e0ng mua.<\/li>\n<li>Nh\u1eadp ch\u1ee9ng t\u1eeb ph\u00e2n h\u1ec7 <strong>B\u00e1n h\u00e0ng<\/strong> t\u1eeb Excel: \u0110\u01a1n \u0111\u1eb7t h\u00e0ng, B\u00e1o gi\u00e1, H\u1ee3p \u0111\u1ed3ng b\u00e1n, Ch\u1ee9ng t\u1eeb b\u00e1n h\u00e0ng, b\u00e1n d\u1ecbch v\u1ee5; B\u00e1n tr\u1ea3 l\u1ea1i, gi\u1ea3m gi\u00e1 h\u00e0ng b\u00e1n<\/li>\n<li>Nh\u1eadp ch\u1ee9ng t\u1eeb ph\u00e2n h\u1ec7 <strong>T\u1ed5ng h\u1ee3p<\/strong> t\u1eeb Excel: Ch\u1ee9ng t\u1eeb quy\u1ebft to\u00e1n t\u1ea1m \u1ee9ng, Ch\u1ee9ng t\u1eeb nghi\u1ec7p v\u1ee5 kh\u00e1c.<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<p>&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>1. M\u1ee5c \u0111\u00edch: Cho ph\u00e9p nh\u1eadp t\u1eeb Excel tr\u01b0\u1eddng m\u1edf r\u1ed9ng v\u1edbi c\u00e1c ki\u1ec3u d\u1eef li\u1ec7u ngo\u00e0i d\u1ea1ng Text \u0111\u1ec3 ph\u1ee5c v\u1ee5 nhu c\u1ea7u qu\u1ea3n l\u00fd kh\u00e1c nhau c\u1ee7a ng\u01b0\u1eddi d\u00f9ng. 2.Chi ti\u1ebft thay \u0111\u1ed5i: L\u1ea5y th\u00f4ng tin ki\u1ec3u d\u1eef li\u1ec7u t\u1eeb Thi\u1ebft l\u1eadp\\T\u00f9y ch\u1ecdn\\Thi\u1ebft l\u1eadp tr\u01b0\u1eddng m\u1edf r\u1ed9ng: Ki\u1ec3u&#8230;<\/p>\n","protected":false},"author":115,"comment_status":"closed","ping_status":"closed","template":"","format":"standard","meta":{"footnotes":"","_links_to":"","_links_to_target":""},"ht-kb-category":[3284],"ht-kb-tag":[],"class_list":["post-10930","ht_kb","type-ht_kb","status-publish","format-standard","hentry","ht_kb_category-r10"],"_links":{"self":[{"href":"http:\/\/helpasp.misa.vn\/accounting\/wp-json\/wp\/v2\/ht-kb\/10930","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=10930"}],"version-history":[{"count":1,"href":"http:\/\/helpasp.misa.vn\/accounting\/wp-json\/wp\/v2\/ht-kb\/10930\/revisions"}],"predecessor-version":[{"id":10931,"href":"http:\/\/helpasp.misa.vn\/accounting\/wp-json\/wp\/v2\/ht-kb\/10930\/revisions\/10931"}],"wp:attachment":[{"href":"http:\/\/helpasp.misa.vn\/accounting\/wp-json\/wp\/v2\/media?parent=10930"}],"wp:term":[{"taxonomy":"ht_kb_category","embeddable":true,"href":"http:\/\/helpasp.misa.vn\/accounting\/wp-json\/wp\/v2\/ht-kb-category?post=10930"},{"taxonomy":"ht_kb_tag","embeddable":true,"href":"http:\/\/helpasp.misa.vn\/accounting\/wp-json\/wp\/v2\/ht-kb-tag?post=10930"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}