{"id":10545,"date":"2025-01-14T15:05:06","date_gmt":"2025-01-14T15:05:06","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2025\/01\/14\/tai-ve-mau-bang-kiem-ke-quy-dung-cho-ngoai-te-vang-tien-te-theo-thong-tu-200-tren-excel-moi-nhat-nam-2018\/"},"modified":"2025-01-14T15:05:06","modified_gmt":"2025-01-14T15:05:06","slug":"tai-ve-mau-bang-kiem-ke-quy-dung-cho-ngoai-te-vang-tien-te-theo-thong-tu-200-tren-excel-moi-nhat-nam-2018","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2025\/01\/14\/tai-ve-mau-bang-kiem-ke-quy-dung-cho-ngoai-te-vang-tien-te-theo-thong-tu-200-tren-excel-moi-nhat-nam-2018\/","title":{"rendered":"T\u1ea3i v\u1ec1 M\u1eabu B\u1ea3ng ki\u1ec3m k\u00ea qu\u1ef9 (D\u00f9ng cho ngo\u1ea1i t\u1ec7, v\u00e0ng ti\u1ec1n t\u1ec7) theo Th\u00f4ng t\u01b0 200 tr\u00ean Excel m\u1edbi nh\u1ea5t n\u0103m 2018"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-nJy84WMn#1\">\n<p>Excel l\u00e0 m\u1ed9t c\u00f4ng c\u1ee5 h\u1eefu \u00edch trong k\u1ebf to\u00e1n. X\u00e2y d\u1ef1ng\u00a0c\u00e1c m\u1eabu ch\u1ee9ng t\u1eeb\u00a0tr\u00ean Excel l\u00e0 m\u1ed9t trong nh\u1eefng y\u00eau c\u1ea7u k\u1ebf to\u00e1n th\u01b0\u1eddng g\u1eb7p trong c\u00f4ng vi\u1ec7c k\u1ebf to\u00e1n tr\u00ean Excel.<\/p>\n<p>Trong b\u00e0i vi\u1ebft n\u00e0y,\u00a0<strong>H\u1ecdc Excel Online<\/strong>\u00a0s\u1ebd h\u01b0\u1edbng d\u1eabn c\u00e1c b\u1ea1n v\u1ec1\u00a0<strong>C\u00e1ch t\u1ea1o v\u00e0 t\u1ea3i m\u1eabu B\u1ea3ng ki\u1ec3m k\u00ea qu\u1ef9\u00a0(D\u00f9ng cho ngo\u1ea1i t\u1ec7, v\u00e0ng ti\u1ec1n t\u1ec7) theo Th\u00f4ng t\u01b0 200 tr\u00ean Excel\u00a0theo<\/strong>\u00a0<strong>m\u1eabu m\u1edbi nh\u1ea5t n\u0103m 2018<\/strong>. Ch\u00fang ta c\u00f9ng t\u00ecm hi\u1ec3u c\u00e1ch l\u00e0m nh\u00e9:<\/p>\n<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_61 counter-hierarchy ez-toc-counter ez-toc-transparent ez-toc-container-direction\">\n<p class=\"ez-toc-title\">Xem nhanh<\/p>\n<p><label for=\"ez-toc-cssicon-toggle-item-67867d21e9eaf\" class=\"ez-toc-cssicon-toggle-label\"><span class=\"\"><span class=\"eztoc-hide\">Toggle<\/span><span class=\"ez-toc-icon-toggle-span\"><\/span><\/span><\/label><\/p>\n<nav>\n<ul class=\"ez-toc-list ez-toc-list-level-1 \">\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/blog.hocexcel.online\/tai-ve-mau-bang-kiem-ke-quy-dung-cho-ngoai-te-vang-tien-te-theo-thong-tu-200-tren-excel-moi-nhat-nam-2018.html#Mau_Bang_kiem_ke_quy_Dung_cho_ngoai_te_vang_tien_te_theo_Thong_tu_200_tren_Excel\" title=\"M\u1eabu B\u1ea3ng ki\u1ec3m k\u00ea qu\u1ef9 (D\u00f9ng cho ngo\u1ea1i t\u00ea, v\u00e0ng ti\u1ec1n t\u1ec7) theo Th\u00f4ng t\u01b0 200 tr\u00ean Excel:\">M\u1eabu B\u1ea3ng ki\u1ec3m k\u00ea qu\u1ef9 (D\u00f9ng cho ngo\u1ea1i t\u00ea, v\u00e0ng ti\u1ec1n t\u1ec7) theo Th\u00f4ng t\u01b0 200 tr\u00ean Excel:<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/blog.hocexcel.online\/tai-ve-mau-bang-kiem-ke-quy-dung-cho-ngoai-te-vang-tien-te-theo-thong-tu-200-tren-excel-moi-nhat-nam-2018.html#Huong_dan_viet_Bang_kiem_ke_quy_Dung_cho_ngoai_te_vang_tien_te_tren_theo_Thong_tu_200_tren_Excel\" title=\"H\u01b0\u1edbng d\u1eabn vi\u1ebft\u00a0B\u1ea3ng ki\u1ec3m k\u00ea qu\u1ef9 (D\u00f9ng cho ngo\u1ea1i t\u1ec7, v\u00e0ng ti\u1ec1n t\u1ec7)\u00a0tr\u00ean theo Th\u00f4ng t\u01b0 200 tr\u00ean Excel:\">H\u01b0\u1edbng d\u1eabn vi\u1ebft\u00a0B\u1ea3ng ki\u1ec3m k\u00ea qu\u1ef9 (D\u00f9ng cho ngo\u1ea1i t\u1ec7, v\u00e0ng ti\u1ec1n t\u1ec7)\u00a0tr\u00ean theo Th\u00f4ng t\u01b0 200 tr\u00ean Excel:<\/a>\n<ul class=\"ez-toc-list-level-4\">\n<li class=\"ez-toc-heading-level-4\"><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/blog.hocexcel.online\/tai-ve-mau-bang-kiem-ke-quy-dung-cho-ngoai-te-vang-tien-te-theo-thong-tu-200-tren-excel-moi-nhat-nam-2018.html#Chu_y\" title=\"Ch\u00fa \u00fd:\">Ch\u00fa \u00fd:<\/a><\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<\/nav>\n<\/div>\n<h3><span class=\"ez-toc-section\" id=\"Mau_Bang_kiem_ke_quy_Dung_cho_ngoai_te_vang_tien_te_theo_Thong_tu_200_tren_Excel\"><\/span>M\u1eabu B\u1ea3ng ki\u1ec3m k\u00ea qu\u1ef9 (D\u00f9ng cho ngo\u1ea1i t\u00ea, v\u00e0ng ti\u1ec1n t\u1ec7) theo Th\u00f4ng t\u01b0 200 tr\u00ean Excel:<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-18222 size-full aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/bkkq-nt.png\" width=\"705\" height=\"525\" title=\"bkkq-nt\"><\/p>\n<h3><span class=\"ez-toc-section\" id=\"Huong_dan_viet_Bang_kiem_ke_quy_Dung_cho_ngoai_te_vang_tien_te_tren_theo_Thong_tu_200_tren_Excel\"><\/span>H\u01b0\u1edbng d\u1eabn vi\u1ebft\u00a0<strong>B\u1ea3ng ki\u1ec3m k\u00ea qu\u1ef9 (D\u00f9ng cho ngo\u1ea1i t\u1ec7, v\u00e0ng ti\u1ec1n t\u1ec7)<\/strong><strong>\u00a0tr\u00ean theo Th\u00f4ng t\u01b0 200 tr\u00ean Excel:<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<ul style=\"list-style-type: square\">\n<li><strong>\u0110\u01a1n v\u1ecb,\u00a0\u0110\u1ecba ch\u1ec9<\/strong>: Ghi r\u00f5 T\u00ean \u0111\u01a1n v\u1ecb, b\u1ed9 ph\u1eadn<\/li>\n<li><strong>Gi\u1edd, Ng\u00e0y, th\u00e1ng, n\u0103m: <\/strong>L\u00e0 th\u1eddi gian (gi\u1edd), ng\u00e0y, th\u00e1ng, n\u0103m ti\u1ebfn h\u00e0nh ki\u1ec3m k\u00ea<\/li>\n<li><b>\u00d4ng\/B\u00e0:<\/b> H\u1ecd, t\u00ean c\u1ee7a ng\u01b0\u1eddi \u0111\u1ea1i di\u1ec7n c\u00e1c b\u00ean<\/li>\n<li><strong>S\u1ed1 d\u01b0 theo s\u1ed5 qu\u1ef9: <\/strong>C\u0103n c\u1ee9 v\u00e0o<strong>\u00a0<\/strong>s\u1ed1 t\u1ed3n qu\u1ef9 tr\u00ean s\u1ed5 qu\u1ef9 t\u1ea1i ng\u00e0y, gi\u1edd c\u1ed9ng s\u1ed5 ki\u1ec3m k\u00ea qu\u1ef9 \u0111\u1ec3 ghi v\u00e0o <strong>C\u1ed9t 2 v\u00e0 C\u1ed9t 4<\/strong><\/li>\n<li><strong>S\u1ed1 ki\u1ec3m k\u00ea th\u1ef1c t\u1ebf: <\/strong>C\u0103n c\u1ee9 v\u00e0o s\u1ed1 ki\u1ec3m k\u00ea th\u1ef1c t\u1ebf ghi theo t\u1eebng lo\u1ea1i ngo\u1ea1i t\u1ec7, v\u00e0ng ti\u1ec1n t\u1ec7 \u0111\u1ec3 ghi s\u1ed1 l\u01b0\u1ee3ng \u0111\u01a1n gi\u00e1, t\u1ef7 gi\u00e1 v\u00e0 s\u1ed1 ti\u1ec1n \u00a0t\u01b0\u01a1ng \u1ee9ng v\u00e0o <strong>C\u1ed9t 1, C\u1ed9t 2, C\u1ed9t 3 v\u00e0 C\u1ed9t 4<\/strong><\/li>\n<li><strong>Ch\u00eanh l\u1ec7ch:\u00a0<\/strong>L\u00e0 s\u1ed1 ch\u00eanh l\u1ec7ch gi\u1eefa S\u1ed1 d\u01b0 theo s\u1ed5 qu\u1ef9 v\u00e0 S\u1ed1 ki\u1ec3m k\u00ea th\u1ef1c t\u1ebf<\/li>\n<li><strong>L\u00fd do<\/strong>: Ghi r\u00f5 nguy\u00ean nh\u00e2n\u00a0th\u1eeba ho\u1eb7c thi\u1ebfu ti\u1ec1n<\/li>\n<li><strong>K\u1ebft lu\u1eadn sau khi ki\u1ec3m k\u00ea qu\u1ef9:\u00a0<\/strong>K\u1ebft lu\u1eadn ti\u1ec1n qu\u1ef9 \u0111\u1ee7, th\u1eeba ho\u1eb7c thi\u1ebfu<\/li>\n<\/ul>\n<h4><span class=\"ez-toc-section\" id=\"Chu_y\"><\/span>Ch\u00fa \u00fd:<span class=\"ez-toc-section-end\"><\/span><\/h4>\n<p>\u2013\u00a0Vi\u1ec7c ki\u1ec3m k\u00ea qu\u1ef9 \u0111\u01b0\u1ee3c ti\u1ebfn h\u00e0nh theo:<\/p>\n<ul style=\"list-style-type: square\">\n<li>\u0110\u1ecbnh k\u1ef3 v\u00e0o cu\u1ed1i th\u00e1ng, cu\u1ed1i qu\u00fd, cu\u1ed1i n\u0103m<\/li>\n<li>Khi c\u1ea7n thi\u1ebft c\u00f3 th\u1ec3 ki\u1ec3m k\u00ea \u0111\u1ed9t xu\u1ea5t<\/li>\n<li>Khi b\u00e0n giao qu\u1ef9<\/li>\n<\/ul>\n<p>\u2013 Khi ti\u1ebfn h\u00e0nh ki\u1ec3m k\u00ea ph\u1ea3i l\u1eadp Ban ki\u1ec3m k\u00ea, trong \u0111\u00f3: th\u1ee7 qu\u1ef9 v\u00e0 k\u1ebf to\u00e1n ti\u1ec1n m\u1eb7t ho\u1eb7c k\u1ebf to\u00e1n thanh to\u00e1n l\u00e0 c\u00e1c th\u00e0nh vi\u00ean.<\/p>\n<p>\u2013 Bi\u00ean b\u1ea3n ki\u1ec3m k\u00ea qu\u1ef9 ph\u1ea3i ghi r\u00f5 s\u1ed1 hi\u1ec7u ch\u1ee9ng t\u1eeb v\u00e0 th\u1eddi \u0111i\u1ec3m ki\u1ec3m k\u00ea (\u2026 gi\u1edd \u2026 ng\u00e0y \u2026 th\u00e1ng \u2026 n\u0103m \u2026).<\/p>\n<p>\u2013 Tr\u01b0\u1edbc khi ki\u1ec3m k\u00ea qu\u1ef9, th\u1ee7 qu\u1ef9 ph\u1ea3i ghi s\u1ed5 qu\u1ef9\u00a0 t\u1ea5t c\u1ea3 c\u00e1c Phi\u1ebfu thu, Phi\u1ebfu chi v\u00e0 t\u00ednh s\u1ed1 d\u01b0 t\u1ed3n qu\u1ef9 \u0111\u1ebfn th\u1eddi \u0111i\u1ec3m ki\u1ec3m k\u00ea.<\/p>\n<div class=\"code-block code-block-1\" style=\"margin: 8px 0;clear: both\">\n<div class=\"ad-inserterpro\">\n<a href=\"https:\/\/hocexcel.online\/course\/preview\/ex101-excel-tu-co-ban-den-chuyen-gia-danh-cho-nguoi-di-lam\"><br \/>\n<img decoding=\"async\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/ex101_92019-nho-186.gif\" title=\"ex101_92019-nho-186\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<p>\u2013 Khi ti\u1ebfn h\u00e0nh ki\u1ec3m k\u00ea ph\u1ea3i ti\u1ebfn h\u00e0nh ki\u1ec3m k\u00ea ri\u00eang <strong>t\u1eebng lo\u1ea1i ti\u1ec1n<\/strong> c\u00f3 trong qu\u1ef9: ngo\u1ea1i t\u1ec7, v\u00e0ng ti\u1ec1n t\u1ec7, \u2026<\/p>\n<p>\u2013 B\u1ea3ng ki\u1ec3m k\u00ea qu\u1ef9 ph\u1ea3i c\u00f3 ch\u1eef k\u00fd c\u1ee7a th\u1ee7 qu\u1ef9, Tr\u01b0\u1edfng ban ki\u1ec3m k\u00ea v\u00e0 k\u1ebf to\u00e1n tr\u01b0\u1edfng.<\/p>\n<p>\u2013 M\u1ecdi kho\u1ea3n ch\u00eanh l\u1ec7ch qu\u1ef9 \u0111\u1ec1u ph\u1ea3i b\u00e1o c\u00e1o gi\u00e1m \u0111\u1ed1c doanh nghi\u1ec7p xem x\u00e9t gi\u1ea3i quy\u1ebft.<\/p>\n<p>\u2013 B\u1ea3ng ki\u1ec3m k\u00ea qu\u1ef9 do ban ki\u1ec3m k\u00ea qu\u1ef9 l\u1eadp th\u00e0nh 02 b\u1ea3n:<\/p>\n<ul>\n<li>1 b\u1ea3n l\u01b0u \u1edf th\u1ee7 qu\u1ef9<\/li>\n<li>1 b\u1ea3n l\u01b0u \u1edf k\u1ebf to\u00e1n qu\u1ef9<\/li>\n<\/ul>\n<p>\u2013 Tr\u01b0\u1eddng h\u1ee3p ki\u1ec3m k\u00ea v\u00e0ng ti\u1ec1n t\u1ec7: s\u1ed1 ki\u1ec3m k\u00ea th\u1ef1c t\u1ebf ph\u1ea3i \u0111\u01b0\u1ee3c ghi theo t\u1eebng lo\u1ea1i, t\u1eebng th\u1ee9<\/p>\n<p>\u2014<\/p>\n<p>Ch\u00fac c\u00e1c b\u1ea1n h\u1ecdc t\u1ed1t c\u00f9ng H\u1ecdc Excel Online!<\/p>\n<\/div>\n<div class=\"uk-panel uk-margin uk-width-xlarge\">\n<p>Click \u0111\u0103ng k\u00fd h\u1ecdc t\u1ea1i:<\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/khoa-hoc\" target=\"_blank\" rel=\"noopener\">T\u1ea5t c\u1ea3 kho\u00e1 h\u1ecdc\u00a0<span>\ud83d\udcd6<\/span><\/a><\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/huong-dan-kich-hoat-khoa-hoc-tai-hoc-excel-online.html\" target=\"_blank\" rel=\"noopener\">H\u01b0\u1edbng d\u1eabn k\u00edch ho\u1ea1t<\/a><\/p>\n<p>HKD H\u1ecdc Excel Online<br \/>S\u1ed1 \u0110K: 17A80048102<\/p>\n<\/div>\n<div class=\"uk-panel uk-text-small uk-margin uk-margin-remove-bottom uk-text-center\">\n<p>\u00a9  document.currentScript.insertAdjacentHTML(&#8216;afterend&#8217;, &#8221; + new Intl.DateTimeFormat(document.documentElement.lang, {year: &#8216;numeric&#8217;}).format() + &#8221;);  H\u1ecdc Excel Online. All rights reserved.<\/p>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<div class=\"ad-inserterpro\">\n<a href=\"https:\/\/hocexcel.online\/course\/preview\/ex101-excel-tu-co-ban-den-chuyen-gia-danh-cho-nguoi-di-lam\"><br \/>\n<img decoding=\"async\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/ex101_92019-nho-186.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":10546,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[],"class_list":["post-10545","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-excel-co-ban"],"_links":{"self":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/10545","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/comments?post=10545"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/10545\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/10546"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=10545"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=10545"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=10545"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}